Workbook Cleaner

Workbook Cleaner - Improve efficiency by cleaning up your workbook

Over time many workbooks become bloated with unused stuff.
Workbook Cleaner gives you a range of option for cleaning up your workbook and returning it to full efficiency.
for details on all the available options see Help.

Where-Used Maps

Two of the options in Clean Workbook produce where-used Maps for Styles and Number Formats.

You can also access these options directly from the 'Where Used' button on the FastExcel Manager tab on the ribbon.

For example the Number Format Map could look like this:

[

If you select a cell on the map sheet (for example one of the 3 s in the Pricing column) and Click the FastExcel GoTo button, the cells on the pricing sheet that use that number format will be selected.
This provides a visual way of seeing where the number format is being used and an easy way to modify the formats consistently within a workbook.

Try it out for yourself:

Download the 15-day full-featured trial of FastExcel V3 build 231.655.789.380

Note: the trial version of FastExcel V3 profiler does not enable Profile Workbook, Profile Worksheet and Profile Formulas, and the Drill down wizard will only profile a single worksheet.

You can convert the trial version of FastExcel V3 to a fully licensed version at any time by purchasing one of the FastExcel V3 licensing options.

© 2001-2014 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster