Questions tagged [microsoft-office]
Application suite from Microsoft which includes always Word, PowerPoint and Excel. Depending on what edition of Microsoft Office you have you can also have OneNote, Outlook, Publisher and Access.
3,279
questions
1
vote
3
answers
4k
views
Error message when I try to install Microsoft Office 2003 to my new computer running Windows 10
This is the error code I get: Error 1919. Error configuring ODBC data source: Visual FoxPro Database, ODBC error 6: Component not found in the registry. Verify that the file Visual FoxPro Database ...
0
votes
1
answer
227
views
Microsoft 365 - disabling autosave and touch/mouse mode in the Quick Access Toolbar [UPDATE]
I just renewed my MS365 software and I've noticed that when I load Excel or Word, "Automatically Save" and "Touch/Mouse Mode" in the Quick Access Toolbar pop up. I'm able to ...
0
votes
3
answers
4k
views
How to add VBA to MS Office installation
I am missing VBA on my Office 2016 installation (installed via Office deployment tool). When attempting to open Visual basic for Applications (Alt + F11) nothing happens. The Macros options are greyed ...
1
vote
1
answer
4k
views
Links to Network Shares not opening in Outlook
When clicking a shared network file path (\\server-1\) from an email message in Outlook, there are 3 dots that go across the top of the message window like Outlook is thinking about opening the link ...
1
vote
1
answer
98
views
How to move some mails from Outlook.com to free up some space while keeping the complete conversation view in Outlook of Office?
Due to the recent policy changes to the Outlook.com, i.e. 5GB limit on attachment, my email account is running out of space online, and I’m thinking to move some mails offline to free up some space.
...
1
vote
1
answer
4k
views
Syncing OneNote does not work with Office 2013
I have Office 2013 both at home and at office and I am logged on to both machines. Now, when I want to sync some of the notes from Home and Office then I basically went to File> Settings>Sync but as ...
3
votes
3
answers
19k
views
Copying Chart to Another Sheet with Updated References in Excel
I have made a chart within a sheet in Excel. Within the sheet, the chart refers to specific cells in the sheet to display (i.e. cells that contain my data points).
I would like to know how to copy ...
0
votes
2
answers
9k
views
Repair an Access database from the command line
I just solved an issue after about a week of headaches: I had an Access 97 database which I could not open with anything (Access 2007, Excel 16 importing, etc). It would say "The operation is invalid ...
1
vote
2
answers
6k
views
Outlook refuses to work without Cached Exchange Mode
I have a shared Windows 7 computer with Office 2010 on it that dozens of people use. That computer has a disk space problem on it. >60% of the hard drive space is being wasted on Outlook OST files. ...
1
vote
1
answer
9k
views
Excel remove document recovery pane?
I tried a few registery tweaks but that doesnt seem to work. I use a batch script that switches between 2 excel sheets, but it forces closure of the excelsheet. This makes it so the Document recovery ...
0
votes
1
answer
4k
views
Microsoft Office 2016 access to offline documentation
We just got Microsoft Office 2016 installed on a secure system without Internet access. When we try to use Help it tries and fails to go online. How do I get the offline help to work?
(Note I had the ...
2
votes
1
answer
4k
views
Can't install Visio 2016, "the following products can not be installed at the same time"
I'm trying to install visio 2016 (licence for 5 installs, but only 3 have been used so far) on a office PC but when I do I get this error message:
I thought I this was because office 2010 was ...
3
votes
2
answers
7k
views
Import EML emails into Outlook 2010 64-bit
Evening everyone. I'm helping setup a small office network, where a number of old PC's are being replaced with new ones with a 64-bit copy of Outlook 2010. The old emails were stored in Windows Live ...
5
votes
2
answers
12k
views
Still possible to deploy Office 2016 using ODT in 2020?
TLDR;
I'm looking for a method for installing Office 2016 Pro Plus VL using ODT in 2020.
My workplace just updated all employee computers to Windows 10, but a few of them have to be reverted back to ...
0
votes
1
answer
6k
views
Change Office 2016 setup log directory to custom location
I can't seem to figure out how to change the default Office setup.exe log location from C:\users\username\AppData\Local\Temp\SetupExe(blablabalbaba).log to somewhere else locally on the disk. This ...
0
votes
1
answer
221
views
Microsoft Office: Your account has multiple licenses
So I have an older laptop which came with Office Home & Student 2016 for PC. I now got a new laptop with Office Home & Student 2021.
Both laptops use the same live.com account for the licenses....
1
vote
1
answer
3k
views
Word always shows markup/comments automatically when opening a document, even after saving it with "No Markup"
Office Word automatically opens this comment section whenever I open the file, until I select No Markup in the section that says Simple Markup.
But it is annoying to have to do this every time I open ...
1
vote
1
answer
5k
views
Two-Factor Authentication for Microsoft Office Document
I have a particularly sensitive Microsoft Office document on my computer (Excel Spreadsheet). I have password protected it, but to feel truly secure, I would like set up two-factor authentication for ...
1
vote
2
answers
147
views
Excel 365 - retain all changes to a file beyond 60 days
Our order review process requires that we be able to tell when a company rep has corrected or changed anything on an order form. The order form is currently an Excel 365 spreadsheet.
A recent revision ...
1
vote
0
answers
155
views
How to remove custom Office meeting template?
A long time ago I set up a custom meeting template in Outlook Calendar that would include some basic information, a link to a web meeting tool, and some default agenda. When I double-click in my ...
0
votes
1
answer
73
views
How do I stop this install of Office
For a few days now, after a boot, I see this error
Microsoft Office Professional Plus 2010
The feature you are trying to use is on a network resource that is unavailable.
Click OK to try again, or ...
0
votes
0
answers
107
views
How to create Excel histogram from frequency table?
I have an Excel table with two rows.
One header row with positive integers representing different event properties and another row with the frequency of events with said property number.
Here's a ...
5
votes
0
answers
1k
views
Any way to move Office Starter To-Go to a non-flash drive?
Microsoft's Office Starter edition has an interesting option to create a portable version on a USB flash drive using the "Microsoft Office Starter To-Go Device Manager". This creates a portable ...
7
votes
2
answers
13k
views
Make a left panel not auto collapsible in MS Teams
After I pressed some keys on keyboard this panel has disappeared and now appears only on mouse hovering:
How do I lock it back again?
UPD. Below are some screenshots.
1
vote
1
answer
262
views
Run Microsoft Office apps in guest VM from host with VirtualBox
Main goal
I'm using VirtualBox to use Microsoft Office apps in a Windows 10 virtual machine. My host OS is Ubuntu 23.04. I've made a few scripts that allows to launch Microsoft Office apps from the ...
0
votes
2
answers
4k
views
Getting rid of "Tell us the account you want to use to open autodiscover.xml" which pops up in Word (Office 365)
Every time I open Word, this pops up:
When I type in the e-mail address associated with my personal account and hit Next, the window disappears, only to reappear the next time I open Word.
I recently ...
0
votes
1
answer
1k
views
How can I put this MASSIVE excel spreadsheet as an appendix in word?
I am writing a math report and in it I need to include appendices, the only issue is that two of them are absolutely massive excel spreadsheets with over 2000 rows each that would just not be ...
0
votes
0
answers
1k
views
Missing Registry keys: HKEY_CURRENT_USERS\Software\Microsoft\Office
I have a bit of a pickle: One of my clients does not have an Office Directory in their Registry (HKEY_CURRENT_USERS\Software\Microsoft\Office). We use M365 and the Office Suite was installed through a ...
2
votes
1
answer
1k
views
Extract Saved Word Document inside OneNote Notebook on OneDrive
In Microsoft Office 2013, saving documents on SkyOneDrive is fully integrated into Word. On a computer using Word 2013, I wrote a document and saved it into a folder in my OneDrive.
When I went to a ...
2
votes
3
answers
863
views
How to back up Documents with OneDrive, while also using another cloud service?
I use OneDrive for Business on Windows 11 and I want to back up the Documents folder on my harddrive to OneDrive.
In the OneDrive settings I go to "Sync and backup > Manage backup". Here, ...
2
votes
0
answers
4k
views
Word 2007 - "Save as" / Save dialog window won't show, even for unsaved documents
I have a situation where when I try to save an unsaved document using Ctrl+S, or choosing File -> Save or File -> Save As, the save dialog window won't appear, so I can't save the document, and I have ...
1
vote
1
answer
190
views
Hyperlink does not change along with cell when filtered
I’m having a problem with hyperlink when using filters. So let’s say I have these table rows:
A
B
C
I have a hyperlink to cell C using the usual hyperlink option. But if I change the filter from “A to ...
1
vote
1
answer
551
views
How to apply the MATCH() function only to a filtered range? Or is there another way to do that?
I have a filtered list of values. Let's say I have the numbers from 0 to 5, and 2 is filtered out:
A (with auto-filter against "2")
0
1
3
4
5
Now I want to find out whether one of the ...
0
votes
0
answers
161
views
Offline Installation and Updating of Microsoft 365 on Remote Desktop Services (RDS) Server
In an environment where my RDS 2019 server lacks internet connectivity, what steps should I follow to download Microsoft 365 installation files to another machine, transfer them to the server, and ...
1
vote
3
answers
11k
views
MS Word 2010: Hide citation title when 2 publications by same first author from different years are in one citation block
I'm trying to hide the display of the titles for two publications by the same first author from different years that are in the same citation block. By default, the title is shown in citations when ...
0
votes
2
answers
96
views
Does the Outlook 365 UI in Cached Exchange Mode periodically lock up for everyone with a spotty Internet connection?
I spend a lot of time in Outlook in-flight where the connection is spotty. For years, I've noticed the UI often freezes for several seconds, sometimes longer, if it loses connection with Exchange ...
0
votes
1
answer
62
views
when I try to output the final version of my document as pdf, my cool new Google (or other) TrueType font changes weight
I love how many fonts are available for free from Google and other places, as well as from subscriptions like your Adobe plan.
When I finished a document recently with a popular TrueType font from ...
1
vote
2
answers
328
views
Customize or Create Picture Style in Outlook
I often use the same picture style when pasting (not attaching) images into e-mails in Outlook. Even with the Ribbon, setting this style every time is a 4-click process.
Is there anyway to set a ...
1
vote
2
answers
3k
views
Excel 2007 or 2010 copy/paste without merging cells & with shift all down
Let say I have an excel sheet with structure like
I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116):
And click Ctrl+V. It gives me an ...
0
votes
0
answers
22
views
How to change the order of explorer-contextmenu
I've created a contectmenu in Explorer on desktop with 9 options for Office :)
How can I change the order of the items?
For me the most important App is Excel then outlook, word, Access, ...
But ...
3
votes
4
answers
9k
views
Cannot install Microsoft Office 64-bit after removing Office 32-bit
I have been working with Microsoft Office 365 32-bit installation on my laptop with Windows 10 Pro 64-bit for a long time, and now need to replace it with the 64-bit edition. However, I can't do this. ...
0
votes
0
answers
70
views
Cmd uninstall string not working
I have to remove a software from several computers with remotely. Uninstall-Package and wmic commands seems working but not working, the software still there.
I thought I can uninstall with uninstall ...
1
vote
1
answer
194
views
If Excel has an accuracy of 15 significant figures, why are there presets for number styles with > 15 decimal places?
And what is the difference if it was 0,############... or #,########...?
0
votes
1
answer
161
views
Outlook 365 online, Outlook online, creating folders: View contents of subfolder in parent folder for team emails
I am super new to MS, windows and Office since I worked in Apple my whole life. here is my goal which I could do in Apple mail, thunder mail and others.
Folder My sales team.
Subfolders
Bill, jack, ...
0
votes
0
answers
50
views
Main Office 365 (O365) left navigation pane keeps opening and closing
When I'm logged into Microsoft O365 on the main/primary dashboard, the left navigation pane that shows all your applications keeps opening and closing on its own. What is causing this and how can I ...
2
votes
2
answers
634
views
Powerpoint's eyedropper all of a sudden returning inverted (or, at any rate, wrong) colors
I was trying to fill a shape with a color that exists elsewhere in my slide, so I used the indispensable Eyedropper tool, which normally works very well.
However, this now returns a color that is ...
1
vote
1
answer
3k
views
Branching based on rating in Microsoft Form
Is it possible to branch the option based on rating?
Like, if rating is one star, it must go to "What you dislike most" and if rating is 5-star, it must go to "What you like most"
0
votes
0
answers
48
views
(Microsoft Word) How to stop styles opening in a box?
I'm trying to make some text be in the style of Header 1, Header 2, Header 3, etc
When I change the style of text, it opens up in this box instead of staying normal text that is in line with the rest ...
0
votes
0
answers
135
views
How do I make calendar entries for a Microsoft 365 dynamic group appear in the member's individual calendars?
I have a Microsoft 365 dynamic group with a number of calendar items in it. If a member views the group calendar in Outlook they can see the items but this requires them to manually select the ...
1
vote
1
answer
405
views
How to fix legacy and third-party systems that send emails to office365 users?
Esp. in the last couple of years, we have seen steadily increasing problems when our internal applications/servers send emails (reports, alerts, warnings, and what-not info) to our internal employees/...