Subscribe to How-To Geek

Recommended: Click Here to Run a Free Scan for Common PC Errors   [Sponsored Link]

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.

Mysticgeek is the resident IT expert at How-To Geek and a huge rock music fan. When he's not writing about Microsoft Office, he's probably writing at his personal blog. This article was written on 06/22/07 and tagged with: Microsoft Office

Leave a Comment




Leave your friendly comment here. If you have a computer help question, leave it on the forums instead.

Note: Your comment may not show up immediately on the site.

Copyright © 2006-2008 HowToGeek.com. All Rights Reserved.