Very Slow Cell Formatting

[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

 

[dderolph]

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

 

[Dave Peterson]

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.

 

[Dave Peterson]

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

 

[Gord Dibben]

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

 

[dderolph]

And if it doesn't help, can you can to a different printer--you don'

need to He did not mention printing. How would changing printers or printe

drivers help

 

[Dave Peterson]

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.