While working with Excel 2007 several users have been inadvertently creating files that are not compatible with the older version of MS Excel e.g. 2003, 97 etc. One way to ensure that you workbook is compatible with the older version you need to Save your workbook in appropriate Excel format that recipient of the file is expected to have or use the compatibility checker tool on your workbook so that you can fix potential issues.
To ensure that a MS Office Excel 2007 workbook does not have compatibility issues that may cause loss of some or several functionality in an earlier version of Excel, you must run the Compatibility Checker tool unless you are already working on a file created in earlier version of MS Excel. The Compatibility Checker tool discovers any potential compatibility issues and can create a report for you. Follow the below instructions to use Excel 2007’s Compatibility Checker tool…
- In Office Excel 2007, open the workbook that you want to check for compatibility.
- Click Microsoft Office Button (
) - Click Prepare
- Click Run Compatibility Checker.
- To ensure the Compatibility is checked for every time you save the workbook, select the Check compatibility when saving this workbook check box.
- To create a report in a separate worksheet of all the issues that are listed in the Summary box, click Copy to New Sheet.
- Clicking Fix button may resolve some simple compatibility issues.
I hope you found the information useful and Thank you for reading.
No comments:
Post a Comment