Why does it take longer time for re-calculation?
 

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

Why does it take longer time for re-calculation?
 

Hi Eric,

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

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Eric" wrote in message ...
| 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

Why does it take longer time for re-calculation?
 

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

"Niek Otten" wrote:

Hi Eric,

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

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Eric" wrote in message ...
| 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