View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Reverse Engineer complex spreadsheet


Maybe the "Formula Map" code in this post will help...
http://snipurl.com/1joun
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"davegb"
wrote in message
I'm working with a team reverse engineering a rather complex workbook.
The author is helping, but is available on a very limited basis. I've
mostly been using the Audit features to trace precedents and
dependents and manually drawing diagrams showing these relationships,
which is cumbersome and slow. Does anyone have any good suggestions
beyond what I'm already doing on how to expedite this process? Any
tracing macros that will ID all downstream dependents cells of a given
cell? Any clever techniques that would make this easier? I feel like
I'm sawing down a redwood with a Swiss Army knife! :)

Thanks!