Excel 2003 speed issue

[JaneC]

Hi everyone,

One of my users has a large spreadsheet (9MB) that consists of several worksheets. its used for budgeting and has iterations and all kind of clever things going on.

With Excel 97 the calculations are performed very quickly, but with Excel 2003 the calculations take long enough for you to make a cup of coffee. This happens everytime she changes a cell. Does this on multiple pcs, including mine.

For now she is continuing to update the sheet on the old excel 97 pc, but that is due to be upgraded to 2003 soon.

I need to try and workout what excel 2003 is doing that excel 97 isnt, to speed it up.

Has anyone got any ideas that could help speed up Excel 2003 ?

Any help gratefully received !

 

[xlbo]

without knowing what kind of formulae / code is involved, it's gonna be virtually impossible to give you any help.....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question