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

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


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

Third party tools

Speed up your file

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 > RefTreeAnalyser > Operating instructions
Deze pagina in het Nederlands

RefTreeAnalyser Operating instructions

Start the tool from the ribbon of Excel 2007 and up, you will find a group on the Formulas tab:

Or use the cell right click menu:

In Excel 2003, Start the tool from Excel's Tools menu:

or use the toolbar:


Buy RefTreeAnalyser now!


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


Comment by: Mario (2/4/2015 10:59:22 PM)

Hi Jan Karel,

Thank you for the prompt response.

I am personally not fussed about the backstage issue, more important that I can use the tool than worry about who moved my cheese.

As for using OneDrive, absolutely no advantage (you don't save space, downloads, etc., aside that the tool's size is relatively insignificant in today's terms) and you get a lot of OneDrive annoyances.




Comment by: Stanley Silverman (3/30/2016 4:15:12 PM)

Hi, Jan Karel -
I recently had to reinstall your excellent product, but made the mistake of doing this from within the zipped folder. I reinstalled by following the instructions, but I still get the various files not found error messages when Excel starts up (Excel 2010, Windows 7). How do I fix the problem?
Thanks for your help!
Stanley Silverman


Comment by: Jan Karel Pieterse (3/30/2016 5:04:37 PM)

Hi Stanley,

Open Excel, go to the add-ins dialog and click on each one. Excel will prompt to remove the ones it cannot locate anymore.


Comment by: Stanley Silverman (3/30/2016 6:37:54 PM)

Hi, Jan Karel -
Thanks so much for your quick response - it worked!
Thanks again,
Stanley Silverman


Comment by: Stanley Silverman (3/30/2016 11:05:09 PM)

Hi, Jan Karel -
The solution only seems to work during the current session.
When I quit out of Excel and then re-launch the program, the same error messages come up again. Somewhere there's a setting or a link that's not being fully updated when I tell Excel to remove the bogus item.
Thanks again,
Stanley Silverman


Comment by: Jan Karel Pieterse (3/31/2016 7:03:05 AM)

Hi Stanley,

That is unusual. Perhaps you need to run Excel as an admin for this (though that should not be needed)?


Comment by: C Lee (8/27/2016 5:39:44 PM)

Hi, Jan Karel,

I am currently using Office 365 in Win 10, and it seems that I can't open the file by double clicking the file. Please kindly help, thanks!

Regards, C Lee


Comment by: Jan Karel Pieterse (8/27/2016 7:20:34 PM)


Probably the file is blocked due to a recent security update. See:


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:

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:

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.