Why does it take longer time for re-calculation?

[Guest]

Does anyone have any idea on why it take longer time for re-calculation?
I get a table with formula for 54 columns x 4000 rows within 1 file, which
takes a very long time for re-calculation.
However, if I split this table into 3 files, which include formula for 18
columns x 4000 rows, then the periods for re-calculation is shorter than the
file [54 x 4000] including the time for opening and closing files.
Does anyone know why the file with table [54 x 4000] takes longer than 3
files with table [18 x 4000] for re-calculation?
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

 

[Niek Otten]

Hi Eric,

For lots of info about Excel performance, visit Charles Williams' site:

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Does anyone have any idea on why it take longer time for re-calculation?
| I get a table with formula for 54 columns x 4000 rows within 1 file, which
| takes a very long time for re-calculation.
| However, if I split this table into 3 files, which include formula for 18
| columns x 4000 rows, then the periods for re-calculation is shorter than the
| file [54 x 4000] including the time for opening and closing files.
| Does anyone know why the file with table [54 x 4000] takes longer than 3
| files with table [18 x 4000] for re-calculation?
| Does anyone have any suggestions?
| Thanks in advance for any suggestions
| Eric

 

[Guest]

I am currently using Office 2000, will Office 2007 already solve this
problem? or will it perform better on my issue?
Thank you for your suggestions
Eric