A not infrequent question at work, is how to add a second mailbox in Outlook. Here’s how: (more…)
Category: Microsoft Office
-
Word: “Track changes” shows up as “Author” instead of author name
A user called in, reporting that Word’s Track changes-function tagged her as “Author”, instead of her name. I opened a remote session, and started out by confirming that everything else was working correctly, and that her name had been set as the author in the settings for Microsoft Word. Stalling for time while I researched the issue, I found that it seemed to be a problem affecting particular documents. Knowing this set me on the path to the solution, as follows:
(more…) -
Excel freezes on 10 MB file
A few months ago, I had a user call in complaining that Excel would freeze and become completely unresponsive when she was working in a specific workbook. It was fairly large (10MB), but well within what the computer should have been able to handle. I opened a remote session to the computer, and started troubleshooting. My first step, as always in these cases, was to look at the event logs, which showed no relevant entries. Next, I inspected one of the files in question.
-
Excel: Quickly remove blank cells
From time to time, Excel worksheets fill up with blank cells interspersed among the content. While the judicious use of whitespace can be useful, it may also make reading the worksheet somewhat challenging. Luckily, Excel has a tool to help us get rid of the blank cells. Here’s how: (more…)
-
Outlook: Meeting invitations added to other mailboxes
A while back, I had a user call in, telling me that all meeting invitations she received for some reason also showed up in the inboxes of a couple of shared mailboxes. I logged in to her computer remotely, and started poking about. I tried a number of fixes, including deleting her profile and recreating it, at which point i stumbled across a reference to delegates.
-
Reducing the size of your Powerpoint presentations
On a surprisingly regular basis, I get requests from users who want to send Powerpoint-presentations via email, but are stopped because the presentations are too big. 30 MB isn’t uncommon, and just the other day, I had someone with a presentation of a whopping 75 MB.
-
MS Excel: Create PDF of active worksheet
I recently had a user call in and ask me how he could export the contents of a single worksheet to PDF while working in Microsoft Excel 2010. As I told him, that is a simple feat to achieve. Here is how: (more…)
-
Hiding the Office Ribbon menu
For most of my time as a computer user, my main text editing tool has been Microsoft Office. I have grown accustomed to using, and even sort of liking the ribbon menu. However, as I often work on a laptop with its severely limited monitor real estate, I needed to find a way to hide it when I am not using it. Luckily enough, that is very simple.