help! printing locks up excel

P

pywhacket

Hello, I have a workbook that contains several macros and many formulas. It
works beautifully until I try to print or do a print preview. Then it locks
up excel and I have to restart. Any ideas about what is causing this?

Thanks!
 
G

Guest

Hi pywhacket

The first thing to check is that your printer driver is up-to-date. I
believe that the Print Preview is 'managed' by the printer driver, as the
print is, of course!

Andy.
 
P

pywhacket

Andy,

My print driver is up-to-date. I have also gotten other people to try it -
same problem for all.

Michele
 
G

Guest

Michele

What happens if you try to print another, simpler sheet? This should
determine whether the macros may be affecting the printing.

Andy.
 
P

pywhacket

The simpler sheets do print.

Andy said:
Michele

What happens if you try to print another, simpler sheet? This should
determine whether the macros may be affecting the printing.

Andy.
Click to expand...
 
G

Guest

OK. I've never had a sheet not print because there were too many formulas on
it, so I would say that one of your macros is to blame.
Try setting your macro security to High, then opening the sheet and
printing. Does that change anything?

Andy.
 
G

Guest

OK. The next thing to try is renaming your excel.xlb. Close Excel and do a
search for it on your PC and rename it to excel.xlbold (or similar). I know
that this has caused printing problems in the past with some users. Excel
will recreate an xlb file when you restart the program.

Andy.
 
P

pywhacket

It still won't work! This thing is making me nuts!!! I have to get it working
today. I really appreciate the time you are taking.
 
G

Guest

Try starting Excel in safe mode. From Start/Run . . . browse to Excel.exe
(probably in C:\program files\microsoft office\office). Select is and before
you click OK add /s to the end (so it ends excel.exe /s).
The next step after that is to reregister Excel with Windows Registry, which
means you need to run "Excel.exe /unregserver" and then "Excel.exe
/regserver" from the run line in the same way as before (with its path).

Andy.
 
P

pywhacket

I figured it out!!! I have an image - company logo - and it was being
repasted on it self so it was on the sheets hundreds of times. It overloaded
excel.


Thanks for your help!!!
 
Top