O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required