Special Edition Using Microsoft® Office Excel® 2007

Chapter 19. Working with Prior Versions of Excel

In this chapter

Opening Excel 2007 Files in Previous Versions of Excel 372

Creating Excel 2007 File Formats in Excel 2003 376

Opening Excel 2003 Files in Excel 2007 377

Preparing to Save Excel 2007 Files for Excel 97 Through Excel 2003 378

The Digital Divide 381

With not just one new file format but three file formats in Excel 2007, you will face a number of problems as you try to share files with people who use previous versions of Excel.

If you are using Excel 2007 and want to open a file created in Excel 5 through Excel 2007, your copy of Excel will gladly open the file, but the file will be in a special Compatibility mode. In this mode, you cannot use more than 65,536 rows, and you cannot use ...