We have a large 5MB Excel Workbook consisting of 58 Worksheets and many VBA modules. We use many methods of improving the performance of this worksbook like:
1.) Empty Excel Temporary Directory
2.) Control Calculations on non-essential worksheets
3.) Optimize sequence of worksheets to minimize backward references
4.) Compile VBA into DLLs for computational efficiency
5.) Disable Excel's screen updates until computations are done

QUESTION: Does anybody know how to visualize the Excel Dependency Tree used by the calculation engine? We would like to look at this to determine if there are other efficiencies/errors we can fix to make the workbook more responsive to the users interaction.