Slow Re-Calc times
Posted by Giles on February 12, 2002 9:11 AM
I have a 3Meg file which has Dsums, Lookups etc. When I hit f9 to recalc it takes 3-4 seconds. I have recently replaced alot of the DSUMS with CSE formula's and got rid of the DSUMs completely which brings the file size to under 1Meg.
The problem I have now is the recalc takes 15-20 seconds.
Is there anything I can do or is it due to the nature of CSE functions that this is how slow life will be now??
Thanks in advance