Subscribe to How-To Geek

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. His daily articles can be found at Mysticgeek's Realm. This article was written on 06/22/07 and tagged with: Microsoft Excel, Microsoft Office, Microsoft Outlook

Daily Email Updates

You can get our how-to articles in your inbox each day for free. Just enter your name and email below:


Name:
Email:
Similar Articles Featured Wiki Articles
Latest Software Reviews Quick Linux Tips
Geek Arcade Popular Forum Threads

Comments (4)

  1. michael Lui

    How is the fastest way to convert 3000+ files from Excel 2003 to Excel 2007 besides the obvious way of converting each file individually?

    Thanks.

  2. MJM

    I have hundrerds of Excel 2003 that i want to convert to Excel 2007. Any short cuts other than opening and converting them individually?

    Thanks

  3. John Mitchell

    Thanks, but the description on this page seems to involve opening each one individually. What have I missed?

  4. Kevin

    I get a excel statistical workbook from a friend with 3 worksheets that have formulas relating to each sheet that’s in 97-03 version – when I open with 2007, some of the formulas do not calculate – I get this #VALUE! in the cell that should have information from the other 2 sheets in some of the cells. Please help, thanks


Leave a Comment




Leave your friendly comment here.

If you have a computer help question, click here to leave it on the forums instead.

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

Sponsored Links
Getting Started
About How-To Geek
What Is That Process?
svchost.exe
jusched.exe
dwm.exe
ctfmon.exe
wmpnetwk.exe
wmpnscfg.exe
rundll32.exe
wfcrun32.exe
Ipoint.exe
Itype.exe
Wfica32.exe
Mobsync.exe
Cmd.exe
Dpupdchk.exe Adobe_Updater.exe

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