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 120, Updated Mar 23, 2017, downloaded: 1,363 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 24 in total (Show All Comments):

 


Comment by: Orlando Calderon (3/8/2012 12:00:59 PM)

where do I download Excel File Remediation Tool. I have a critical Excel workbook that every so often crashes.
Thanks for the GREAT tools

 


Comment by: Jan Karel Pieterse (3/9/2012 5:47:39 AM)

HI Orlando,

The tool cannot be downloaded. However, you can send your file to me and I'll run it through the tool so you can check whether it helps.

 


Comment by: Alister (7/8/2013 10:46:46 AM)

Hi .. I have a file that gets the following error when saved in Excel 1997-2003. However I have deleted all defined names and their appears to be no external links. Have you come across this problem and how to remove the error from the file. I can send file if required.

"Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned. Defined Name"

 


Comment by: Jan Karel Pieterse (7/8/2013 4:12:55 PM)

Hi Alister,

Download my free name manager from www.jkp-ads.com/officemarketplacenm-en.asp and use it to filter for names with external references. That way you'll be able to locate which are causing havoc.

 


Comment by: Alister (7/8/2013 5:40:18 PM)

Your 'Name Manager' add-on worked fantastically. It found a hidden Defined Name that I could not delete because Excel 2007 would not show it in the list. Using 'Name Manager' I was then able to delete the name and thus solved the problem. Many thanks for such a useful and powerful program.

 


Comment by: Paul D Pruitt (7/31/2013 9:51:45 PM)

Jan, as I reported in my E-mail, my open source tool, S2 Recovery Tools for Microsoft Excel, has been updated moving from version 3 to 4 with new features. Maybe your customers will find it useful:

* http://sourceforge.net/projects/corruptexcelrec/,

Also there is another free tool they might try:

* http://sergeig888.wordpress.com/2011/03/21/net4-0-version-of-the-xlstylestool-is-now-available - the desktop versions. There is also a WIndows 8 app version.

 


Comment by: Thomas (11/10/2016 12:15:50 PM)

Hi,

Your tool is great, I now work from an MacBook with OSx and can't install the remediation tool.

Do you have a Mac version available?

Thanks.

Thomas

 


Comment by: Jan Karel Pieterse (11/14/2016 9:13:50 AM)

Hi Thomas,

I'm afraid this is a Windows-only tool, sorry!

 


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 but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

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