General discussion

Locked

"Slow" Excel file

By qb4006 ·
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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to "Slow" Excel file

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

Collapse -

by qb4006 In reply to

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

Collapse -

by DKlippert In reply to "Slow" Excel file

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.

Collapse -

by qb4006 In reply to

The tinyurl.com info refers to Office 97

Collapse -

by DKlippert In reply to "Slow" Excel file

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.

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums