Clean Workbook
Clean Workbook helps you minimise the size and memory footprint of your workbooks.
|
The Clean Workbook button shows you the Clean workbook options form. Some options are not available with Mac Excel:
Delete temporary files
Close VBE Windows
Remove unused Number Formats & Map Number Formats
|
|
Check Workbook
This command produces a report showing statistics for the active workbook.
Potential problem areas are highlighted in Orange.
See the Clean Workbook command for details.
Backup Workbook before Clean
Because you cannot “UNDO” the changes made by clean workbook, we strongly recommend that you let FastExcel backup your workbook before cleaning. A copy of the workbook will be saved in the same directory with a .BAC file extension.
Active or All Worksheets
Choose to clean either only the active worksheet or all worksheets.
|