O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Saving Your Workbooks for Use with Older Versions of Excel

Over the years, Microsoft has added many features to Excel and has changed its file format several times. As a result, two problems occur:

  • An older version of Excel may not be able to open a workbook you create in Excel 2011. If the older version can open the workbook, it may not display correctly.
  • An older version of Excel can't support the features that have been added to Excel in subsequent versions. For example, Microsoft added sparklines (in-cell charts) in Excel 2011; earlier versions, such as Excel 2008 and Excel 2004, don't have sparklines.

The first essential for sharing a workbook with older versions of Excel is to choose a suitable file format:

  • Excel Workbook format. 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