Willow Solutions, Inc.

Clean Copy Workbook Repair Tool

Once the Audit Report(s) has been generated and reviewed, the user can proceed to the clean-up or repair stage. Some of this process will require manual intervention, but a number of problems can also be repaired through the use of automated repair tools.

There are five repair tools:

Remove Invalid Range Names
Removes range names that refer to #REF. This reduces size of workbook and may decrease calculation and overhead. This will also make it easier to maintain the workbook over time.

Compress VB Forms and Modules
The VBA Macros section of the Workbook Audit Report will help to identify a workbook that has code modules and forms behind it that may be plagued by “bloat”. Compressing these VB forms and modules may drastically reduce the size of the workbook file.

Convert Office 95 Controls
Converts Office 95 controls to COM compliant Office 97/2000 controls. Office 95 controls are less efficient and not COM compliant. These controls are easily converted through the use of this tool.

Remove Extra Row Formatting
Formatting may be removed from un-used rows as listed in the Worksheets section of the General Audit Report. Removing extra row formats may reduce the size of a worksheet.

Remove Extra Column Formatting
Formatting may be removed from un-used columns as listed in the Worksheets section of the Workbook Audit Report. Removing extra column formats may reduce the size of a worksheet.