Office Tips

Automatically Remove Duplicate Rows in Excel

by File in: Office Tips

Excel is a versatile application having grown far beyond its early versions as simply a spreadsheet solution. Employed as a record keeper, address book, forecasting tool, and much more, many people even use Excel in ways it was never intended. If you use Excel a lot at home or in the office, you know that […]

Connecting Excel to MySQL

by File in: Office Tips

Sure Excel is used for spreadsheets, but did you know you can connect Excel to external data sources? In this article we’re going to discuss how to connect an Excel spreadsheet to a MySQL database table and use the data in the database table to populate our spreadsheet.  There are a few things you need […]

Fix Outlook Spell Checker Not Working

by File in: Office Tips

I recently upgraded the version of Microsoft Office on my computer and learned that my spell checker was no longer working! Usually, it would automatically show me misspelled words immediately if I mistyped them, however, after the upgrade, nothing was being marked. Even if I ran the spell checker manually, it would complete without marking […]

Fix “Word Cannot Start the Converter MSWRD632.WPC/SSPDFCG_x64.CNV” Error

by File in: Office Tips

Recently, I had a user in my office get the following errors when trying to open a Word document: Word cannot start the converter mswrd632.wpc. or Word cannot start the converter SSPDFCG_x64.cnv Whenever the user clicked the OK button, it would simply pop back up. What was really weird is that if she clicked on […]

How to Create Multiple Linked Dropdown Lists in Excel

by File in: Office Tips

So previously I wrote about how you can create a simple dropdown list in Excel, which is perfect for any kind of data validation. If you have a range of values that people are required to enter repeatedly, it’s best to create a dropdown list so that no invalid data can be entered. That’s all […]

How to Use Excel’s Speak Cells Feature

by File in: Office Tips

I am a big fan of text-to-speech technology, mostly because it doesn’t work all that well.  However, sometimes it ends up being useful for certain situations. Excel is packed with many features, including one called Speak Cells, which basically lets you feed your chosen cells to a text-to-speech engine. It is a great accessibility tool […]

Get Outlook Email Stats using StatView

by File in: Office Tips

Just about every corporate email account is using Outlook and Exchange server to handle user email and there is an awful lot of data stored in those PST files. My own work PST file for Outlook is close to 2 Gb, which is why I wrote a post on how to optimize your PST file so […]

How to Fix Microsoft Office Error 25090

by File in: Office Tips

Working in a corporate environment as an IT support technician always means you’ll end up dealing with weird problems that would never occur on a normal consumer PC. Why? Well, it’s because weird stuff can occur when you have 20 people using one computer! One such error I ran across recently was while using Microsoft […]

How to Clear Recently Opened File List in Word

by File in: Office Tips

You may have noticed that in Word, Excel and all other Office programs, there is a list of recently used or opened documents in the File menu. It’s kind of like the Recent Items features on the Windows 7 Start Menu. However, if you want to remove the recently used file list so that it […]

How to Repair a Damaged or Corrupt Outlook PST File

by File in: Office Tips

If you have ever used Outlook for more than a month, you’ve probably seen several occasions where the message “The Outlook data file did not close properly” pops up and you have to wait a few minutes for Outlook to repair the file. Pretty annoying, but at least you can view your emails after waiting. […]