Pete Mccann
Member
I hope that Hui won't mind me posting this thread but a recent thread of mine in the "Visualizations and Charting" forum called "Dynamically updating Charts with new and different data" (sorry, I am not sure how to link to the other thread) gave us a lot of problems with respect to being able to open Hui's solution.
This got me thinking....is there a way of checking an excel workbook such that we can be sure that there are no bad links to external files, bad connections, bad references, un-used Name ranges etc., etc.
I'm sure I am not alone, but if I find a file useful then I use it for my own use without really knowing the history or the provenance of the file.
Essentially a list of tricks or checks to audit the file before use would be very useful.
This got me thinking....is there a way of checking an excel workbook such that we can be sure that there are no bad links to external files, bad connections, bad references, un-used Name ranges etc., etc.
I'm sure I am not alone, but if I find a file useful then I use it for my own use without really knowing the history or the provenance of the file.
Essentially a list of tricks or checks to audit the file before use would be very useful.