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

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" <(E-Mail Removed)> wrote in message
news:8D42EF1D-A8E5-4544-9139-(E-Mail Removed)...
>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