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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Yes, I did say no.

"Andy" wrote:

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

Andy.

"pywhacket" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in
message
...
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" wrote in message
...
Yes, I did say no.

"Andy" wrote:

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

Andy.

"pywhacket" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in
message
...
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!

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.

"pywhacket" wrote in message
...
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" wrote in message
...
Yes, I did say no.

"Andy" wrote:

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

Andy.

"pywhacket" wrote in message
...
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" wrote in message
...
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" wrote in
message
...
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" wrote in
message
...
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" wrote in message
...
Yes, I did say no.

"Andy" wrote:

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

Andy.

"pywhacket" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in
message
...
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 didn't do anything!! You did it yourself!

Andy. 8=)

"pywhacket" wrote in message
...
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" wrote in message
...
Yes, I did say no.

"Andy" wrote:

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

Andy.

"pywhacket" wrote in message
...
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" wrote in message
...
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" wrote in
message
...
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" wrote in
message
...
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!