Save Excel Workbook For Compatibility

Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.

Save Excel Workbook For Compatibility. Office Button Excel Options Save and change the Save files in this format. Right click on Excel shortcut or Excel file - Click Properties - Tab Compatibility - Change Setting for All Users - Remove tick from Run this program in compatibility mode for - Apply.

Estimation Excel Sheet Best Online Engineering Resource Construction Estimating Software Construction Cost Construction
Estimation Excel Sheet Best Online Engineering Resource Construction Estimating Software Construction Cost Construction from www.pinterest.com

Under the Save files in this format drop-down menu select Excel Workbook xlsx and then click OK. The new file will be saved in the latest Excel 2010 format but the old file will still open in compatibility mode. To Excel Workbook xlsx Newer versions of Office.

Open an Excel file to confirm the issue is fixed.

When you no longer need backward compatibility click File Info Convert to convert the workbook to the current file format so you can take advantage of I also tried this but there is no convert button even in XLSX version. I have a function that looks for open workbooks and pulls them into a master workbook. Run the Compatibility Checker for Excel 2007 and later. Save an Excel workbook for compatibility with earlier versions of Excel Save a file to xls format and review Compatibility Checker issues.