Excel: Overtime (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

 

 

Office -> Prepare  -> Compatibility Checker

 

Compatibility

Microsoft Excel 2007 offers many rich, creative features. However, many of these options are not supported in earlier versions of Excel. For example, Excel 2000 cannot "see" the Icon Set formatting because the Icon programming simply isn't there in the old Excel software. Previous versions of Excel used Lists, which Excel 2007 doesn't use. That capability is now available as Tables.

 

You may get a Compatibility message when you save your Excel 2007 work. You can also check the compatibility with the Office menu.

 

Try It: Check Compatibility

Go to Office ->Prepare.

Select Compatibility Checker.

 

What Do You See? The summary will indicate which new features are not compatible with older versions of Excel. If you want to keep the old functions, you can Copy to a New Sheet, then Continue.

 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 5. Collaborating and Securing Data

  5.4. Save workbooks 

  5.4.1.  Save workbooks for use in a previous version of Excel: Using Compatibility Checker