I have pretty complex model that I inherited from another banker. Customer is complaining that when cell in Assumptions Sheet is changed, it freezes their computer and runs very very slow.
I want to simplify the model by finding relationship between Assumptions and Data Tables. When I change cell in Assumptions then during the calculation excel send message: Calculate Data Table 1, 2, ... 5.
My question is how I can find what are physically Data Table 1, Data Table 2, .. 5 for change of specific cell, so I can find if any Data Table is unnecessary in order to simplify the model.
Best Regards,
Ned
Bookmarks