In an excel work book I have a (large number of) dynamic formula linked to Pi, vlookup and standard calculation formulas in another worksheet(s). Using the calculation options in the formulas menu I can update all the worksheets individually except the sheet that contains the dynamic links (approximately 600). Excel crashes at this point. How do I get this tab to calculate without crashing?
Solved by C. C. in 14 mins