Remove RTD entries from file

[Ron]

Hi Govert and everyone,

I have a funny topic today. Is it possible to remove the RTD references from a xlsm or xlsx file ?

I will explain my issue. From time to time (quite rare actually), some files built with my add-in start freezing Excel when calculating and never come back (the cpu usage is about 99% and it never ends). I can even open the file with a fresh Excel, without my add-in, and press F9, and Excel will get stuck until I kill the process.

After long and painful investigations, I can tell that this happens only on files where I call to RTD functions (and by the way, these are array functions too - though I know that RTD + array is bad...), and only with the xlsm/xlsx format. No way to reproduce that with a xls format.

If you change the extension of the file to .zip, then you can explore the different xml files it contains. The issue seems to come from the "volatileDependencies.xml" file where I can find all the RTD registrations. If I remove that file and restore the extension, then Excel can open the file normally and calculate.

By the way, if I have 2 versions of the same file, one which works fine and one which freezes Excel, without any apparent difference in an user perspective, then I just have to swap the calcChain.xml file from the zips and I will fix the broken file and break the working file. 

Thus I can say that there is something wrong with the dependency graph generated by Excel, probably due to the RTD registrations.

Has anybody faced such an issue ? 

I wanted to try removing the RTD registrations before saving the file but I don't know if it is easily doable.

Thanks for your help.

Ron

[max.g...@gmail.com]

Hello Ron,

I experienced the same issue. Found this post after i applied the same fix. My set up was the same: Rtd+array returning functions+xlsx. Did you make any progress on restoring the workbook without needing to delete files from the archive yourself? 

Regards,

Max