philfer
03-23-2008, 10:54 AM
I have been asked to work on a workbook that is large and has many intersheet links and many formulae. (It is constantly "calculating cells")
When I open the workbook the whole screen goes blank and it takes ages to open.
Does anyone know why this is happening. Is it re-calculating the cells before it opens? What is it doing? I tried to use Application.Calculation = xlManual in Workbook.Open but it was still slow.
There is no code in the workbook just a shed load of formulae and links to other sheets in the same book. (i.e it groups and summarises the data for different reports)
When I open the workbook the whole screen goes blank and it takes ages to open.
Does anyone know why this is happening. Is it re-calculating the cells before it opens? What is it doing? I tried to use Application.Calculation = xlManual in Workbook.Open but it was still slow.
There is no code in the workbook just a shed load of formulae and links to other sheets in the same book. (i.e it groups and summarises the data for different reports)