Here is an interesting one.

User 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.

No idea Manny, but in the interim you could try setting the spreadsheet to manually update calculations instead of automatically. If the user is changing a lot of cells then this could save quite a bit of time (as long as you remember to recalculate!)

Sounds odd for a 9mb spreadsheet - that's not really 'big', especially for budgets and stuff...

You could heck it's not referencing external spreadsheets, check any formulae to see if they can be simplified... any formula that can be copied and pasted as values to get the size/complexity down, etc...

(I was going to suggest the manual recalculation thing, but I see someone beat me to it!)

No solution, but I have similar problems - stuff runs perfectly in Excel (and access) 97 yet at a snailspace in 2003.

And this, big Bill would tell us, is progress...

One idea... office 2003 seems to have really increased the default security - maybe there's some kind of excess checking going on?