Microsoft Office Tutorials and References
In Depth Information
Saving files
Here are some of the things that can trigger compatibility error messages:
A workbook contains too many rows, columns, or both
A formula exceeds the maximum allowed number of characters
A formula exceeds seven nested levels
A formula exceeds the maximum number of arguments in a function
A formula contains more than 40 operands
A workbook contains too many cross-sheet array formulas
A workbook has more than 4,050 unique cell formats
A PivotTable field has more than 32,500 unique items
A PivotTable item has a string length greater than 255 characters
A PivotTable caption has more than 255 characters
A PivotTable field list has more than 1,024 fields
In case you’re wondering how to get out of Compatibility mode, all you have to do is
use the Save As command to save the workbook in one of the new file formats, such as
XLSX or XLSM, and then close and reopen the new converted file you just saved.
 
Search JabSto ::




Custom Search