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