Excel Repair Tool / Recomendation

ko1967

New Member
Joined
Jan 3, 2017
Messages
20
Does anyone have any unbiased recommendations for an Excel Repair tool. I don't mind paying for a good tool but it seems like if you google Excel repair tool the results are mostly promoted reviews and not unbiased.

I have some xlsm workbooks that crash from time to time so what I wanted to do was run them through a repair tool and see what problems are encountered and where they reside.

I started with the included Open & Repair feature in Excel 365. This is worthless because it provides the same message even if there was nothing repaired. Want to try it. Open a brand new workbook. Enter "a" in cell A1. Save the Test file. Then Go to File > Open and select the Test file with Open and Repair. It obviously can't have any errors since it has 1 character but Excel will still display the message "Excel completed file level validation and repair. Some parts of the workbook may have been repaired or discarded" which means this message and tool is hardly useful since we can't rely on it to identify if a repair was or was not performed. And if you look at the log file it is even more useless and it pretty much states the same thing with no indication of if there was a repair and if so what.

So in looking for a good repair tool I would want to work with as many Excel features Excel as possible (i.e. macros, charts, pivot tables, table, queries, etc). Some tools won't work on macro enabled workbooks (e.g. Stellar). Some won't work with conditional formatting (e.g. Excel Repair Toolbox). And it must (if I'm going to pay for it) have a log file that indicates exactly what problems it found and where they are located so that I can learn and understand what might be causing the problems and how to avoid them in the future. Messages like "tables rebuilt" isn't sufficient as there could be 20 tables in a workbook so the exact table that was repaired is necessary (as an example).

Thanks for any thoughts or recommendations.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,736
Office Version
2010
Platform
Windows
Again, you can do the same thing manually; export all the modules (including sheet modules and ThisWorkbook), then save as xlsx, close, reopen, import all the modules, then save as xlsm.
 

Forum statistics

Threads
1,089,599
Messages
5,409,207
Members
403,256
Latest member
Viq

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top