This tool is designed to reduce the size and speed up Excel workbooks. It will only work with the new XML file formats (XLSX and XLSM files). It cleans the files by reducing the number of styles in use and the number of activated cells.
See the following Knowledge Base articles for more information:
- (KB213904) You receive a 'Too many different cell formats' error message in Excel ( http://support.microsoft.com/kb/213904 )
- (KB244435) How to reset the last cell in Excel ( http://support.microsoft.com/kb/244435 )
To use this application, click Options, set your desired settings then click Open and Clean to correct the Excel file (XLSX or XLSM).
NOTE: The code provided under this download for cleaning workbook styles is protected by a patent (USP#8,281,236) awarded to Microsoft. The use of this source code is FREE for non-commercial usage. Put more plainly, you cannot use the source code provided in this project in ANY commercial software product that you plan to sell or license. For an additional tool to clean styles from your workbook, please see the following tool provided by Sergei Gundorov.
You can download the tool by clicking this link. To run the tool, extract the ZIP to a folder and run ExcelFileCleaner.exe.