I have previously written about one of my many responsibilities; contacting users whose login credentials have shown up in breach lists. While the pertinent results of the breach files are delivered to me in a flat file, I use Excel’s Text to Columns feature to separate logins (usually email addresses) from the password. While this might take a little fiddling with the delimiters, it is worth it to ensure that you have a good basis on which to work.
Many companies, my employer included, uses spreadsheets on a more or less consistent basis in order to track such things as vacation planning and KPI reporting. For me, as an employee, keeping track of these spreadsheets can, from time to time, be a bit annoying. Much to my surprise, at some point in the past few years, Microsoft added a pin item feature to MS Office.
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:
A while back, a user called in, asking me how she could change the name and initials that Word used when filling in Author and when showing who had made a comment. Not having had to do that for some time, I quickly researched it, finding it was simple enough to do. In order to avoid having to research it in the future, here’s how:
So, you’ve minimized your menu ribbon. Now, let’s get rid of that pesky scroll bar. You’ve got a perfectly good scroll wheel on your mouse, and just don’t need it. It’s simple; here’s how:
If you have a problem opening Word documents from the Windows Explorer, the problem probably lies in how the document files are registered with the operating system. The first thing…
Over the last year or so I’ve had at least fifteen users complain that when they double-click an Excel document in Windows Explorer, Excel opens, but no workbook. They then have to open the document manually in Excel.
Here’s how to resolve this problem:
I recently had a user call in with a problem; whenever she’d open a word-document, word would flash an error message, then to open in safe mode.
Normal.dot is the default template file in Microsoft Word. Because it contains a lot of customization settings, it is prone to corruption. Thus, many problems experienced while working in Microsoft Word can be attributed to this file. The most common fix is to force generate a new, clean version of this troublesome file. Here’s how:
My employer is slowly but surely implementing Microsoft Office 2007. One of the errors we’ve encountered has been a fatal error. It seems to be caused by one of the following two things: