help! print screen locks up excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pywhacket - 24 Mar 2006 14:17 GMT

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!

Reply to this Message

Tom Ogilvy - 24 Mar 2006 15:02 GMT

As a test, try selecting a different printer so that you have a different
print driver selected and try printing. Excel interacts with the print
driver when trying to print, so there may be a problem there.

Note that if you don't have access to a different printer, you can install
any available print driver and then use print preview rather than print (if
print preview causes the same problem) to do the testing.

Signature

Regards,
Tom Ogilvy

> 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!

Reply to this Message

pywhacket - 24 Mar 2006 15:19 GMT

I checked to be sure that the driver is up to date, it is. Also, no luck
printing to other printers or to a pdf.

> As a test, try selecting a different printer so that you have a different
> print driver selected and try printing. Excel interacts with the print
[quoted text clipped - 9 lines]
> >
> > Thanks!

Reply to this Message

Tom Ogilvy - 24 Mar 2006 16:01 GMT

Unless it is just taking a long time I haven't seen any other postings that
would indicate this is a systemic problem. Maybe check the knowledge base
and see if you can find something

http://support.microsoft.com

Signature

Regards,
Tom Ogilvy

> I checked to be sure that the driver is up to date, it is. Also, no luck
> printing to other printers or to a pdf.
[quoted text clipped - 12 lines]
> > >
> > > Thanks!

Reply to this Message

pywhacket - 24 Mar 2006 16:16 GMT

Thanks for your help, Tom. I will try that.

> Unless it is just taking a long time I haven't seen any other postings that
> would indicate this is a systemic problem. Maybe check the knowledge base
[quoted text clipped - 18 lines]
> > > >
> > > > Thanks!

Reply to this Message

Dave Peterson - 24 Mar 2006 16:51 GMT

Just one more thing to check (and it's a wild guess).

Make sure your video drivers are up to date.

> Thanks for your help, Tom. I will try that.
>
[quoted text clipped - 28 lines]
> > > > >
> > > > > Thanks!

Signature

Dave Peterson

Reply to this Message

pywhacket - 24 Mar 2006 20:29 GMT

Thanks for all of the help. I figured it out. There is an image that shows up
on the worksheets and the way I have it refreshing the images were repasting
over and over - there were thousands. I put the image in a header instead. I
felt quite idiotic when I realized what was happening!

> Just one more thing to check (and it's a wild guess).
>
[quoted text clipped - 32 lines]
> > > > > >
> > > > > > Thanks!

Reply to this Message