help! printing locks up excel

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

It still locks up when the macro security is set to high.
"Andy" wrote:

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

Did you say 'No' to the 'Enable Macros?' question when you opened the sheet?

Andy.

"pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
news:288BDA6D-96E8-43AE-951C-4CCD081DD832@microsoft.com...
> It still locks up when the macro security is set to high.
> "Andy" wrote:
>
>> 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!
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

Yes, I did say no.

"Andy" wrote:

> Did you say 'No' to the 'Enable Macros?' question when you opened the sheet?
>
> Andy.
>
> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
> news:288BDA6D-96E8-43AE-951C-4CCD081DD832@microsoft.com...
> > It still locks up when the macro security is set to high.
> > "Andy" wrote:
> >
> >> 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!
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

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.

"pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
news:098295E4-04A5-4541-A18F-CFCB171C6A47@microsoft.com...
> Yes, I did say no.
>
> "Andy" wrote:
>
>> Did you say 'No' to the 'Enable Macros?' question when you opened the
>> sheet?
>>
>> Andy.
>>
>> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
>> news:288BDA6D-96E8-43AE-951C-4CCD081DD832@microsoft.com...
>> > It still locks up when the macro security is set to high.
>> > "Andy" wrote:
>> >
>> >> 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!
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

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.

"Andy" wrote:

> 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.
>
> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
> news:098295E4-04A5-4541-A18F-CFCB171C6A47@microsoft.com...
> > Yes, I did say no.
> >
> > "Andy" wrote:
> >
> >> Did you say 'No' to the 'Enable Macros?' question when you opened the
> >> sheet?
> >>
> >> Andy.
> >>
> >> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
> >> news:288BDA6D-96E8-43AE-951C-4CCD081DD832@microsoft.com...
> >> > It still locks up when the macro security is set to high.
> >> > "Andy" wrote:
> >> >
> >> >> 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!
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

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

"Andy" wrote:

> 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.
>
> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
> news:098295E4-04A5-4541-A18F-CFCB171C6A47@microsoft.com...
> > Yes, I did say no.
> >
> > "Andy" wrote:
> >
> >> Did you say 'No' to the 'Enable Macros?' question when you opened the
> >> sheet?
> >>
> >> Andy.
> >>
> >> "pywhacket" <pywhacket@discussions.microsoft.com> wrote in message
> >> news:288BDA6D-96E8-43AE-951C-4CCD081DD832@microsoft.com...
> >> > It still locks up when the macro security is set to high.
> >> > "Andy" wrote:
> >> >
> >> >> 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!
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>