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!