help! printing locks up excel

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!

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.

"pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
news:CFE85F32-4025-4B3E-B31F-9B9CE728E8ED@microsoft.com...
> 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!
>

Andy,

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

Michele

"Andy" wrote:

> 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.
>
> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
> news:CFE85F32-4025-4B3E-B31F-9B9CE728E8ED@microsoft.com...
> > 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!
> >
>
>
>

Michele

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

Andy.

"pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
news:89390FDA-500D-452A-9D1D-DF4E18C20389@microsoft.com...
> Andy,
>
> My print driver is up-to-date. I have also gotten other people to try it -
> same problem for all.
>
> Michele
>
> "Andy" wrote:
>
>> 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.
>>
>> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
>> news:CFE85F32-4025-4B3E-B31F-9B9CE728E8ED@microsoft.com...
>> > 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!
>> >
>>
>>
>>

The simpler sheets do print.

"Andy" wrote:

> Michele
>
> What happens if you try to print another, simpler sheet? This should
> determine whether the macros may be affecting the printing.
>
> Andy.
>
> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
> news:89390FDA-500D-452A-9D1D-DF4E18C20389@microsoft.com...
> > Andy,
> >
> > My print driver is up-to-date. I have also gotten other people to try it -
> > same problem for all.
> >
> > Michele
> >
> > "Andy" wrote:
> >
> >> 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.
> >>
> >> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
> >> news:CFE85F32-4025-4B3E-B31F-9B9CE728E8ED@microsoft.com...
> >> > 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!
> >> >
> >>
> >>
> >>
>
>
>

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.
"pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
news:C512AB89-8AEB-4B9E-ADF5-F04DADF913CC@microsoft.com...
> The simpler sheets do print.
>
> "Andy" wrote:
>
>> Michele
>>
>> What happens if you try to print another, simpler sheet? This should
>> determine whether the macros may be affecting the printing.
>>
>> Andy.
>>
>> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
>> news:89390FDA-500D-452A-9D1D-DF4E18C20389@microsoft.com...
>> > Andy,
>> >
>> > My print driver is up-to-date. I have also gotten other people to try
>> > it -
>> > same problem for all.
>> >
>> > Michele
>> >
>> > "Andy" wrote:
>> >
>> >> 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.
>> >>
>> >> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
>> >> news:CFE85F32-4025-4B3E-B31F-9B9CE728E8ED@microsoft.com...
>> >> > 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!
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>