Convert Older Excel Documents to Excel 2007 Format

Excel 2007 can open a document from a previous version of outlook in Compatibility Mode, but if you want to take advantage of some of the new features you’ll need to convert the document.(You can use 1.1 million rows in Excel 2007 instead of only 65k in previous versions)

When you open a document from a previous version, you can see [Compatibility Mode] in the title bar.

excelcompat.png

To convert the document, click on the Microsoft Office button in the left hand corner, and then click on Convert.

You should be prompted to save the converted document to a new filename. 

Once the document is saved, now you’ll need to close the current one and reopen the converted document. Thankfully there’s a ridiculously wide dialog window that will let you do that automatically. 

You can see that the new window doesn’t say “[Compatibility Mode]” in the title bar anymore.

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+