Calculation time - can't find the bottleneck
 

I have a large file, approx 10MB, in excel 2003. Most of the data relates to
calculations for around 5,000 records, and the workbook takes too long to
recalculate. All the vlookup's have been replaced with Index / Match, but
it's still slow, and I have a number of macros that rely upon it
recalculating. Based on a post here, I went to this site:
http://msdn.microsoft.com/en-us/library/aa730921.aspx
and ran the timer macros to try and isolate the problem.
The FullCalcTimer takes around 19 secs
The ReCalcTimer takes 0.00013 secs, and
The SheetTimer takes no more than 0.015 secs for each of the 10 tabs.
(I was expecting there to be a problem on one of the tabs)
Does anyone know why the FullCalcTimer would take so long or another method
of isolating the problem?
Thanks,
Graeme

Calculation time - can't find the bottleneck
 

Depending on the circumstances....I sometimes replace long columns of
formulas with "Copy Pastespecial values", and manupulate the data with
values rather than formulas........then the formulas can be replaced later
by macro if necessary.

Vaya con Dios,
Chuck, CABGx3




"Graeme" wrote in message
...
I have a large file, approx 10MB, in excel 2003. Most of the data relates
to
calculations for around 5,000 records, and the workbook takes too long to
recalculate. All the vlookup's have been replaced with Index / Match, but
it's still slow, and I have a number of macros that rely upon it
recalculating. Based on a post here, I went to this site:
http://msdn.microsoft.com/en-us/library/aa730921.aspx
and ran the timer macros to try and isolate the problem.
The FullCalcTimer takes around 19 secs
The ReCalcTimer takes 0.00013 secs, and
The SheetTimer takes no more than 0.015 secs for each of the 10 tabs.
(I was expecting there to be a problem on one of the tabs)
Does anyone know why the FullCalcTimer would take so long or another
method
of isolating the problem?
Thanks,
Graeme