Office Tips

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 […]

Fix Outlook Won’t Open Problem

by File in: Office Tips

I have Outlook 2016 installed on a Windows 10 64-bit system and up till now it’s been working fine. Yesterday, I went to open it and I got the following error message: “Cannot start Microsoft Outlook. Cannot open the Outlook window.” What’s sad is that I’ve had this EXACT same problem in Outlook 2010 and […]

Fix MS Office “Cannot Verify License” Error Message

by File in: Office Tips

I’ve been running Office 2013 in a virtual machine on my Mac for over a year, but suddenly the other day when I tried to open Word, I got the following error message: Cannot verify license for this product Hmmm, of course I have a license! The product key was valid and it had activated […]

Fix “Cannot Start Microsoft Office Outlook” Error

by File in: Office Tips

I recently ran into a problem when using Microsoft Outlook on my laptop. It’s got Windows 7 and I am using Office 2010 at the moment. I went to open Outlook and I got the following error: Cannot start Microsoft Office Outlook. Cannot open the Outlook window. I hadn’t run into any problems with Office […]

Show/Hide Field Codes in Word and Convert Fields to Text

by File in: Office Tips

If you have a lot of field codes in your Word document that you are not going to be updating, you may want to convert them to plain text. To do this, you will want to easily find your fields by turning on the field shading. This post shows you how to turn on and […]

Check All Hyperlinks in a MS Word Document in Seconds

by File in: Office Tips

When writing a long term paper, company manual, or other long document in Word, it is almost impossible to avoid inserting hyperlinks. Hyperlinks to relevant Web pages can make a document’s content more powerful. The problem is, the longer the document, the harder it is to do a final check of each hyperlink before submitting […]