Office Tips

How to Export Your Emails from Microsoft Outlook to CSV or PST

by File in: Office Tips

Are you planning on leaving a job and want to make sure you get a copy of all your emails in case you need to refer to them at a later point? Or maybe you just want to export them for backup purposes in case your Outlook PST file becomes corrupt, which happens quite often. […]

How to Install 64-bit Office via Office 365

by File in: Office Tips

Office 365 Personal, Home or Business products are great ways to access all of Microsoft’s Office products on your desktop, tablet or mobile phone. It’s way better than having to buy each version of Office individually and enter a product key, like we used to have to do before. With Office 365, you get free […]

Fix End Tag Start Tag Mismatch Error When Opening DOCX Files

by File in: Office Tips

If you’re using Word 2007, 2010 or 2013, you might run into a strange error when opening a DOCX file. Recently, I tried to open a DOCX file I had created on Windows 10 using Office 2013 and got the following error message: The name in the end tag of the element must match the […]

Troubleshoot and Fix Office Problems with Repair

by File in: Office Tips

If you’re having problems with any Office program like Word, Excel or Outlook, you can always perform a repair, which will try to fix any issues that may be causing the program to not load properly or ┬ásome other type of problem. Repair MS Office To repair Office, you first have to open the Control […]

Fix Word Opens in Safe Mode Only

by File in: Office Tips

I installed Office on my Windows machine a long time ago and everything was working fine until today. I tried to open a Word document from my desktop and for some strange reason Word opened in Safe Mode. Strange I thought, so I shut it down and opened the file again. Safe mode again! Then […]

Can’t Open Hyperlinks in Outlook?

by File in: Office Tips

I recently ran into a very annoying problem while using Outlook on my computer. When I tried to click on a link, I ended up getting the following message: This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator. Hmm, I was able to open hyperlinks just […]

How to Trace Dependents in Excel

by File in: Office Tips

If you work with formulas a lot in Excel, you know that the value of a single cell can be used in a formula in many different cells. In fact, cells on a different sheet may reference that value also. This means that those cells are dependent on the other cell. Trace Dependents in Excel […]

How to Write an IF Formula/Statement in Excel

by File in: Office Tips

Excel is such a powerful spreadsheet program that I doubt anyone can possibly know everything that it can do. There are so many aspects to the program, it’s amazing that it can all be encapsulated in such a simple interface. I was recently using Excel for some work at home and found myself using the […]

Where to Find Character/Word Count in Word 2010

by File in: Office Tips

It seems like every time Microsoft releases a new version of Office, they move everything around! You get used to seeing one thing under one menu and then next version of Office moves that option to another menu! Grrrr. I’ve upgraded to Office 2010 and one of the most common features I use is the […]

Outlook Autocomplete Not Working or Resetting?

by File in: Office Tips

One of the great things about online email services like Gmail is that you never have to worry about things like autocomplete because all your contacts are stored in the cloud and Gmail automatically builds a giant index of everyone who has emailed you or everyone you have emailed. When you start typing a name […]