Very Slow Cell Formatting

  • Thread starter Thread starter Laser
  • Start date Start date
L

Laser

I'm using windows 98 and office 97. Recently, when I try to format a cell
(bold, change font, or size, etc.) it takes forever. Instead of taking a
second or so it takes a good 30 seconds or more. I can see my disk drive
working but control does not come back quickly.

Any suggestions?

Thanks in advance,

Mike
 
Well, one tactic that would most likely solve the problem is t
uninstall Excel 97, then reinstall it.

A less drastic measure would be to delete your personal.xls fil
(assuming you have one), then let Excel create a new one when yo
create a new macro. Note that this would mean any customizations yo
have made will be lost; you would have to recreate them
 
I don't think deleting personal.xls would have much of an affect on this
problem.

But if the OP wants to try it, move it to another location first. Then test it
out.

If it helps, I was wrong. If it doesn't help, put it back.
 
Just some guesses:

Try closing excel and cleaning up your windows temp folder--it might help and it
can't hurt.

And if it doesn't help, can you can to a different printer--you don't need to
actually have that physical printer--just change to a different default printer.

If that makes it better, then maybe a visit to the printer's web site for a
new/fresh printer driver would help.

And here are a couple of sites that discuss slow performance--I don't think that
they mention the formatting problem (but it's been awhile), but you could still
look:

The first is by Charles Williams and the second by David McRitchie:

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


=======
I think that lots of fonts can slow down windows (in general). Have you added a
bunch lately? If yes, you may want to back them up and uninstall a few (or
lots).
 
Information only.........

Customizations are not saved with the Personal.xls file.

Menu and Toolbar customizations since Excel 95 are saved with the *.XLB file.

Gord Dibben Excel MVP
 
Excel (along with all(?) windows programs), uses the printer driver to make the
screen match what you're printing (what you see is what you get-wysiwyg).

It works pretty well for most things.

So if something is slowing down the display of what gets printed, a common
suggestion is to try changing printer drivers to see if it helps.
 
Back
Top