Excel File Remediation Tool

Many companies have been using spreadsheets for decades. Sometimes spreadsheet models may go back as much as 20 years, when the first steps were taken to build them, sometimes using Lotus 123 or other spreadsheet applications.

More often than not, these (often business critical) models have been extended considerably over the years:

• Sheets have been inserted, or copied over from other workbooks
• Formatting has been changed hundreds of times to thousands of cells
• Defined names (named ranges) have been inserted. Knowingly or inadvertently (e.g. by copying worksheets)
• Corrupt defined names have remained from merge from other spreadsheet file formats to Excel
• User defined functions in VBA
• .........

My customer (who had already been in contact with Microsoft premium support about these issues without getting resolutions) asked me whether it would be possible to build a wizard-like tool to salvage this kind of files. Even better: to remove possible corruptions entirely, without damaging the integrity of the spreadsheet model, without removing formatting and also making sure any VBA code is retained.

Purchase

A single user license costs € 80 (about $ 90) excluding VAT.

Download

Use the link below to download the tool. Please read this article if the tool does not appear to work: Excel add-ins fail to load

Download The Excel File Remediation Utility (Free demo!!!) V2.0 Build 140, Updated Jan 6, 2025.

The tool will work without a license code but with (only slightly) limited functionality. After purchasing a license, you can simply enter the license code into the tool's settings dialog. The limitations will be removed instantly.

Money back guarantee

If you are in any way dissatisfied with The Excel File Remediation Utility , contact me within 30 days after your purchase and I'll issue a refund.

User interface

The menu of the tool is shown below.

These screenshots show the steps of the wizard.

First Step: file selection.

 Next step: what actions must be performed:

Last step: What statistics must be gathered:

Since remediation may be a lengthy process, the tools shows its progress. Note that the progress indicator has a stop button, with which the process may be exited.

My customer has repeatedly confirmed this tool has proven to be an invaluable time-saver, which has enabled them to salvage business critical files, they otherwise had to consider as being lost.