Software

Ask something
Discussion Locked

"Slow" Excel file

0 helpful
5 replies

by qb4006

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have Office XP on a 2Ghz PC with 1GB of RAM and I have an excel file that is 2mb in size that opens and closes extremely slowly - it takes about 40 seconds to open. All other excel files open OK except for this one. The file doesn't have any charts or pictures in it. It's just numbers, text, formulas with 10 worksheets.

Any help would be great.

Thanks

5 replies

by sgt_shultz

hi, i wonder what service pack level you are on for office and for xp. is this slow file on the network or local?

by qb4006

I have Office XP service pack 2 including all recent patches. The file is on a file server just like all the other files. The other excel files work OK except this one. In fact no computer in the office can open this particular file with out having problems

by dklippert

Take a look here concerning putting your spreadsheet on a diet:

http://tinyurl.com/99gl

Alo try Tools>Options Calculations.
Tuoff Automatic and Update remote references.
You'll have to use F9 to update after it's opened , but it may be worth a try.

by dklippert

The problem with obese speadsheets did not end in '97.
As an experiment, go to one of your work sheets and hit Ctrl+End. This will take you to the "last" cell on the worksheet. If it goes anywhere beyond the last cell being used then your spreadsheet is pudgy.

This discussion is closed to new replies.