Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Products > Remediation utility
Deze pagina in het Nederlands

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:

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

Buy The Excel File Remediation Tool now!

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

Download

Use the link below to download the tool.

Download The Excel File Remediation Utility (Free demo!!!) V2.0 (Build 126, Updated Oct 9, 2018, downloaded: 2,373 times)

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.

Menu of remediation tool, Support version

These screenshots show the steps of the wizard.

First Step: file selection.

First Step: file selection (Support).

 Next step: what actions must be performed:

Next step: what actions must be performed (Support):

Last step: What statistics must be gathered:

Last step: What statistics must be gathered (Support):

Buy The Excel File Remediation Tool now!

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.

Remediation progress (Support)

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.

Buy The Excel File Remediation Tool now!

 


Comments

Showing last 8 comments of 36 in total (Show All Comments):

 


Comment by: Joachim Koenen (2/26/2018 3:15:47 PM)

Hi Jan,
that it was. Now it's working.
Thanks
Jo

 


Comment by: Alan (8/7/2018 5:05:35 PM)

Have you seen an issue on an Excel file where Freeze Panes are set but you can not unfreeze? It acts like the file is protected but it is not. I ran into this recently and was really stuck. It was not about getting the data out, we just wanted to fix the sheet.

It was very similar to this where they reference the freeze pane issue at the bottom.

https://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/excel-info-page-shows-protected-workbook-but-it/e8cf6c02-b23c-4ccc-a672-e3c4bc33e9f5?db=5

I was wondering if your tool would have solved this issue.


 


Comment by: Alan Jones (8/7/2018 5:13:06 PM)

Not sure if my first comment went though regarding freeze panes, but was also wondering will this tool clear all Pivot Table caches?

 


Comment by: Jan Karel Pieterse (8/8/2018 9:11:31 PM)

Hi Alan,

No, it does not do that I'm afraid. Good suggestion though.

 


Comment by: Jan Karel Pieterse (8/8/2018 9:14:16 PM)

Hi Alan,

I doubt if it would have, but if you like you can send a sample file exhibiting the problem to me?

 


Comment by: Alan (8/9/2018 4:55:07 PM)

I will email you a cleaned up copy of the sheet in question. We have worked around it but want to fix/prevent in the future.

Might be a good feature to add in the future cleaning Pivot Table cache.

 


Comment by: Don Miller (9/17/2018 9:16:40 PM)

loaded your demo xla, shows to be an add-in, and I tried your demo, now your tool bar will not even show. This is a link to a summary on my file symptoms. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_windows8-mso_2013_release/any-known-issues-with-office-2013-excel-macro/11781434-9ba4-4891-aa42-11356f1fc802

 


Comment by: Jan Karel Pieterse (9/18/2018 10:16:32 AM)

Hi Don,

Can you try just opening the xlam? Excel 2013 and 2016 are a bit problematic when installing add-ins, especially if there are other instances open or if Excel has experienced a crash. The add-in is then listed as installed, but in reality never opens. Also, did you unblock the add-in file?

 


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.