Clean Workbook Options

Navigation: FXLV4_Manager > Clean Workbook >

Delete Temporary Files (not available with Mac Excel)

Temporary files may accumulate in your \Windows\Temp directory (Win95/98/ME), or your \Documents and Settings\<user>\local settings\temp directory (Win2K/WinXP/Win 7/Win 8/Win 10).

Excel creates Temporary files for the workbook, and in particular for controls being used by open workbooks. If Excel crashes for any reason these files may not be deleted.
Software installation programs may also create temporary files.

Make sure you have completed any pending software install, including a reboot if required, before deleting the Temp Files

Too many temporary files can cause problems, so delete them from time to time
Be careful not to delete temp files if you have done a software install that requires you to reboot your PC, but have not yet done so.
In this case you should reboot before deleting the temp files.

Note: a very large number of temp files may cause FastExcel to hang with the status bar showing “Checking Temp Files”. If this happens close Excel, reboot your PC and then delete all files in your temp folder. You can locate your temp folder using StartRun, entering %temp% in the run box and pressing enter.

Close VBE Windows (not Available with Mac Excel)

Each open Visual Basic Environment (VBE) window consumes resources, and the number that are open can build up very rapidly.
This option closes all VBE windows except for windows like Project Explorer.

Remove Invalid Names

This option deletes all names containing errors.

Delete Empty Worksheets

This option deletes any worksheets that do not contain any cell content (formatting, data, formulas) or shapes.

Remove zero height or width shapes

In some conditions a large number of shapes with either zero height or width can be created on a sheet. It can be very difficult to see, select or delete these shapes, so this option deletes them for you.

Remove Zero-sized Shapes

In some conditions a large number of shapes with both zero height and width can be created on a sheet. It can be very difficult to see, select or delete these shapes, so this option deletes them for you.

Clean Pivot Tables

If you change the data for a pivot table and refresh it old items which are no longer in the data may still be held in the Pivot Cache Clean Pivot Tables removes these leftover items from each of the pivot tables in the workbook. Calculated Items and Fields are preserved.

Remove Unused Styles

Selecting this option will delete any styles which are not currently in use, excluding the built-in styles. For very large numbers of styles this option can take a long time.

Remove ALL styles

This option will remove ALL the non-built-in styles from the workbook:
Make sure you have backed up the workbook first.

Map Styles

The Map Styles option produces a report sheet showing the count of each style used by each worksheet.
You can use this map to identify where and how often the styles are being used.

Selecting one of the count cells in the map (for instance the 169 TrueFalse on sheet 2Funding) and clicking the FastExcel GoTo button will show you that sheet with all the cells using that style selected. This makes it easy to change or remove styles.

Remove Unused Number Formats (not available with Mac Excel)

The Screen Flicker you see is expected!

Selecting this option will delete any custom number formats which are not currently in use, excluding the built-in number formats. The screen will flicker for several seconds as FastExcel scans the available number formats.

Because the Excel object model does not provide any standard method of accessing the number formats in a workbook, FastExcel uses a method developed by Leo Heuser of accessing Excel’s number Formats Listbox using Sendkeys.

The technique used to find the number formats in the workbook is based on a method developed by Leo Heuser, and is used in FastExcel with his kind permission.

Map Number Formats

The Map Formats option produces a report sheet showing the count of each number format used by each worksheet.
You can use this map to identify where and how often the number formats are being used.
Selecting one of the count cells in the Map Formats sheet and clicking the FastExcel GoTo button will show you the sheet with all the cells on the sheet that use this Number Format selected.

This makes it easy to change or remove Number Formats.

Clear Undo Memory

Excel uses memory to store the information required to be able to undo recent actions. This option allows you to clear this memory.

Many of the Clean Workbook options will automatically clear the Undo Memory. For these cases the option will be ticked but disabled (greyed out).

Clear Clipboard Memory

Many of the Clean Workbook options will also automatically clear the Excel Windows clipboard Memory. For these cases the option will be ticked but disabled (greyed out).