poor excel response

[Fun Kid]

I have an excel worksheet with a lot of information in it. I have had
no problems opening or saving the file in the past. But recently, I
tried to make it presentable by formatting it. I might have gone a
little overboard on formatting but now the file takes for ever to open
and save. Is this normal? What slows down excel more: equations,
formatting, cell contents, size, ...?

Please help.

 

[Gord Dibben]

Fun

See Charles William's site for answers and fixes on this.

http://www.decisionmodels.com/optspeedd.htm

Also David McRitcjie's site.

http://www.mvps.org/dmcritchie/excel/slowresp.htm

Make sure also that your Temp folders are cleared out often.

Gord Dibben Excel MVP

 

[David McRitchie]

Hi "Fun Kid" <[email protected]>,
How did you format, it is better to format an entire column at once
than do format it's cells individually.

 

[Don Guillett]

You should avoid formatting much more than you need at the time.