software

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.

quot;pywhacketquot; gt; wrote in message
...
gt; Hello, I have a workbook that contains several macros and many formulas.
gt; It
gt; works beautifully until I try to print or do a print preview. Then it
gt; locks
gt; up excel and I have to restart. Any ideas about what is causing this?
gt;
gt; Thanks!
gt;
Andy,

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

Michele

quot;Andyquot; wrote:

gt; Hi pywhacket
gt;
gt; The first thing to check is that your printer driver is up-to-date. I
gt; believe that the Print Preview is 'managed' by the printer driver, as the
gt; print is, of course!
gt;
gt; Andy.
gt;
gt; quot;pywhacketquot; gt; wrote in message
gt; ...
gt; gt; Hello, I have a workbook that contains several macros and many formulas.
gt; gt; It
gt; gt; works beautifully until I try to print or do a print preview. Then it
gt; gt; locks
gt; gt; up excel and I have to restart. Any ideas about what is causing this?
gt; gt;
gt; gt; Thanks!
gt; gt;
gt;
gt;
gt;

Michele

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

Andy.

quot;pywhacketquot; gt; wrote in message
...
gt; Andy,
gt;
gt; My print driver is up-to-date. I have also gotten other people to try it -
gt; same problem for all.
gt;
gt; Michele
gt;
gt; quot;Andyquot; wrote:
gt;
gt;gt; Hi pywhacket
gt;gt;
gt;gt; The first thing to check is that your printer driver is up-to-date. I
gt;gt; believe that the Print Preview is 'managed' by the printer driver, as the
gt;gt; print is, of course!
gt;gt;
gt;gt; Andy.
gt;gt;
gt;gt; quot;pywhacketquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello, I have a workbook that contains several macros and many
gt;gt; gt; formulas.
gt;gt; gt; It
gt;gt; gt; works beautifully until I try to print or do a print preview. Then it
gt;gt; gt; locks
gt;gt; gt; up excel and I have to restart. Any ideas about what is causing this?
gt;gt; gt;
gt;gt; gt; Thanks!
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
The simpler sheets do print.

quot;Andyquot; wrote:

gt; Michele
gt;
gt; What happens if you try to print another, simpler sheet? This should
gt; determine whether the macros may be affecting the printing.
gt;
gt; Andy.
gt;
gt; quot;pywhacketquot; gt; wrote in message
gt; ...
gt; gt; Andy,
gt; gt;
gt; gt; My print driver is up-to-date. I have also gotten other people to try it -
gt; gt; same problem for all.
gt; gt;
gt; gt; Michele
gt; gt;
gt; gt; quot;Andyquot; wrote:
gt; gt;
gt; gt;gt; Hi pywhacket
gt; gt;gt;
gt; gt;gt; The first thing to check is that your printer driver is up-to-date. I
gt; gt;gt; believe that the Print Preview is 'managed' by the printer driver, as the
gt; gt;gt; print is, of course!
gt; gt;gt;
gt; gt;gt; Andy.
gt; gt;gt;
gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hello, I have a workbook that contains several macros and many
gt; gt;gt; gt; formulas.
gt; gt;gt; gt; It
gt; gt;gt; gt; works beautifully until I try to print or do a print preview. Then it
gt; gt;gt; gt; locks
gt; gt;gt; gt; up excel and I have to restart. Any ideas about what is causing this?
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks!
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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.
quot;pywhacketquot; gt; wrote in message
...
gt; The simpler sheets do print.
gt;
gt; quot;Andyquot; wrote:
gt;
gt;gt; Michele
gt;gt;
gt;gt; What happens if you try to print another, simpler sheet? This should
gt;gt; determine whether the macros may be affecting the printing.
gt;gt;
gt;gt; Andy.
gt;gt;
gt;gt; quot;pywhacketquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Andy,
gt;gt; gt;
gt;gt; gt; My print driver is up-to-date. I have also gotten other people to try
gt;gt; gt; it -
gt;gt; gt; same problem for all.
gt;gt; gt;
gt;gt; gt; Michele
gt;gt; gt;
gt;gt; gt; quot;Andyquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi pywhacket
gt;gt; gt;gt;
gt;gt; gt;gt; The first thing to check is that your printer driver is up-to-date. I
gt;gt; gt;gt; believe that the Print Preview is 'managed' by the printer driver, as
gt;gt; gt;gt; the
gt;gt; gt;gt; print is, of course!
gt;gt; gt;gt;
gt;gt; gt;gt; Andy.
gt;gt; gt;gt;
gt;gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Hello, I have a workbook that contains several macros and many
gt;gt; gt;gt; gt; formulas.
gt;gt; gt;gt; gt; It
gt;gt; gt;gt; gt; works beautifully until I try to print or do a print preview. Then
gt;gt; gt;gt; gt; it
gt;gt; gt;gt; gt; locks
gt;gt; gt;gt; gt; up excel and I have to restart. Any ideas about what is causing
gt;gt; gt;gt; gt; this?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Thanks!
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
It still locks up when the macro security is set to high.
quot;Andyquot; wrote:

gt; OK. I've never had a sheet not print because there were too many formulas on
gt; it, so I would say that one of your macros is to blame.
gt; Try setting your macro security to High, then opening the sheet and
gt; printing. Does that change anything?
gt;
gt; Andy.
gt; quot;pywhacketquot; gt; wrote in message
gt; ...
gt; gt; The simpler sheets do print.
gt; gt;
gt; gt; quot;Andyquot; wrote:
gt; gt;
gt; gt;gt; Michele
gt; gt;gt;
gt; gt;gt; What happens if you try to print another, simpler sheet? This should
gt; gt;gt; determine whether the macros may be affecting the printing.
gt; gt;gt;
gt; gt;gt; Andy.
gt; gt;gt;
gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Andy,
gt; gt;gt; gt;
gt; gt;gt; gt; My print driver is up-to-date. I have also gotten other people to try
gt; gt;gt; gt; it -
gt; gt;gt; gt; same problem for all.
gt; gt;gt; gt;
gt; gt;gt; gt; Michele
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Andyquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Hi pywhacket
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; The first thing to check is that your printer driver is up-to-date. I
gt; gt;gt; gt;gt; believe that the Print Preview is 'managed' by the printer driver, as
gt; gt;gt; gt;gt; the
gt; gt;gt; gt;gt; print is, of course!
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Andy.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt; Hello, I have a workbook that contains several macros and many
gt; gt;gt; gt;gt; gt; formulas.
gt; gt;gt; gt;gt; gt; It
gt; gt;gt; gt;gt; gt; works beautifully until I try to print or do a print preview. Then
gt; gt;gt; gt;gt; gt; it
gt; gt;gt; gt;gt; gt; locks
gt; gt;gt; gt;gt; gt; up excel and I have to restart. Any ideas about what is causing
gt; gt;gt; gt;gt; gt; this?
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Thanks!
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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

Andy.

quot;pywhacketquot; gt; wrote in message
...
gt; It still locks up when the macro security is set to high.
gt; quot;Andyquot; wrote:
gt;
gt;gt; OK. I've never had a sheet not print because there were too many formulas
gt;gt; on
gt;gt; it, so I would say that one of your macros is to blame.
gt;gt; Try setting your macro security to High, then opening the sheet and
gt;gt; printing. Does that change anything?
gt;gt;
gt;gt; Andy.
gt;gt; quot;pywhacketquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; The simpler sheets do print.
gt;gt; gt;
gt;gt; gt; quot;Andyquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Michele
gt;gt; gt;gt;
gt;gt; gt;gt; What happens if you try to print another, simpler sheet? This should
gt;gt; gt;gt; determine whether the macros may be affecting the printing.
gt;gt; gt;gt;
gt;gt; gt;gt; Andy.
gt;gt; gt;gt;
gt;gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Andy,
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; My print driver is up-to-date. I have also gotten other people to
gt;gt; gt;gt; gt; try
gt;gt; gt;gt; gt; it -
gt;gt; gt;gt; gt; same problem for all.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Michele
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Andyquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; Hi pywhacket
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; The first thing to check is that your printer driver is up-to-date.
gt;gt; gt;gt; gt;gt; I
gt;gt; gt;gt; gt;gt; believe that the Print Preview is 'managed' by the printer driver,
gt;gt; gt;gt; gt;gt; as
gt;gt; gt;gt; gt;gt; the
gt;gt; gt;gt; gt;gt; print is, of course!
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Andy.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt;gt; gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;gt; gt; Hello, I have a workbook that contains several macros and many
gt;gt; gt;gt; gt;gt; gt; formulas.
gt;gt; gt;gt; gt;gt; gt; It
gt;gt; gt;gt; gt;gt; gt; works beautifully until I try to print or do a print preview.
gt;gt; gt;gt; gt;gt; gt; Then
gt;gt; gt;gt; gt;gt; gt; it
gt;gt; gt;gt; gt;gt; gt; locks
gt;gt; gt;gt; gt;gt; gt; up excel and I have to restart. Any ideas about what is causing
gt;gt; gt;gt; gt;gt; gt; this?
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Thanks!
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Yes, I did say no.

quot;Andyquot; wrote:

gt; Did you say 'No' to the 'Enable Macros?' question when you opened the sheet?
gt;
gt; Andy.
gt;
gt; quot;pywhacketquot; gt; wrote in message
gt; ...
gt; gt; It still locks up when the macro security is set to high.
gt; gt; quot;Andyquot; wrote:
gt; gt;
gt; gt;gt; OK. I've never had a sheet not print because there were too many formulas
gt; gt;gt; on
gt; gt;gt; it, so I would say that one of your macros is to blame.
gt; gt;gt; Try setting your macro security to High, then opening the sheet and
gt; gt;gt; printing. Does that change anything?
gt; gt;gt;
gt; gt;gt; Andy.
gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; The simpler sheets do print.
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Andyquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Michele
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; What happens if you try to print another, simpler sheet? This should
gt; gt;gt; gt;gt; determine whether the macros may be affecting the printing.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Andy.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt; Andy,
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; My print driver is up-to-date. I have also gotten other people to
gt; gt;gt; gt;gt; gt; try
gt; gt;gt; gt;gt; gt; it -
gt; gt;gt; gt;gt; gt; same problem for all.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Michele
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; quot;Andyquot; wrote:
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;gt; Hi pywhacket
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; The first thing to check is that your printer driver is up-to-date.
gt; gt;gt; gt;gt; gt;gt; I
gt; gt;gt; gt;gt; gt;gt; believe that the Print Preview is 'managed' by the printer driver,
gt; gt;gt; gt;gt; gt;gt; as
gt; gt;gt; gt;gt; gt;gt; the
gt; gt;gt; gt;gt; gt;gt; print is, of course!
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; Andy.
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt; gt;gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt;gt; gt; Hello, I have a workbook that contains several macros and many
gt; gt;gt; gt;gt; gt;gt; gt; formulas.
gt; gt;gt; gt;gt; gt;gt; gt; It
gt; gt;gt; gt;gt; gt;gt; gt; works beautifully until I try to print or do a print preview.
gt; gt;gt; gt;gt; gt;gt; gt; Then
gt; gt;gt; gt;gt; gt;gt; gt; it
gt; gt;gt; gt;gt; gt;gt; gt; locks
gt; gt;gt; gt;gt; gt;gt; gt; up excel and I have to restart. Any ideas about what is causing
gt; gt;gt; gt;gt; gt;gt; gt; this?
gt; gt;gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;gt; gt; Thanks!
gt; gt;gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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.

quot;pywhacketquot; gt; wrote in message
...
gt; Yes, I did say no.
gt;
gt; quot;Andyquot; wrote:
gt;
gt;gt; Did you say 'No' to the 'Enable Macros?' question when you opened the
gt;gt; sheet?
gt;gt;
gt;gt; Andy.
gt;gt;
gt;gt; quot;pywhacketquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; It still locks up when the macro security is set to high.
gt;gt; gt; quot;Andyquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; OK. I've never had a sheet not print because there were too many
gt;gt; gt;gt; formulas
gt;gt; gt;gt; on
gt;gt; gt;gt; it, so I would say that one of your macros is to blame.
gt;gt; gt;gt; Try setting your macro security to High, then opening the sheet and
gt;gt; gt;gt; printing. Does that change anything?
gt;gt; gt;gt;
gt;gt; gt;gt; Andy.
gt;gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; The simpler sheets do print.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Andyquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; Michele
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; What happens if you try to print another, simpler sheet? This
gt;gt; gt;gt; gt;gt; should
gt;gt; gt;gt; gt;gt; determine whether the macros may be affecting the printing.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Andy.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; quot;pywhacketquot; gt; wrote in message
gt;gt; gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;gt; gt; Andy,
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; My print driver is up-to-date. I have also gotten other people to
gt;gt; gt;gt; gt;gt; gt; try
gt;gt; gt;gt; gt;gt; gt; it -
gt;gt; gt;gt; gt;gt; gt; same problem for all.
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Michele
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; quot;Andyquot; wrote:
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt;gt; Hi pywhacket
gt;gt; gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; gt;gt; The first thing to check is that your printer driver is
gt;gt; gt;gt; gt;gt; gt;gt; up-to-date.
gt;gt; gt;gt; gt;gt; gt;gt; I
gt;gt; gt;gt; gt;gt; gt;gt; believe that the Print Preview is 'managed' by the printer
gt;gt; gt;gt; gt;gt; gt;gt; driver,
gt;gt; gt;gt; gt;gt; gt;gt; as
gt;gt; gt;gt; gt;gt; gt;gt; the
gt;gt; gt;gt; gt;gt; gt;gt; print is, of course!
gt;gt; gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; gt;gt; Andy.
gt;gt; gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; gt;gt; quot;pywhacketquot; gt; wrote in
gt;gt; gt;gt; gt;gt; gt;gt; message
gt;gt; gt;gt; gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;gt; gt;gt; gt; Hello, I have a workbook that contains several macros and many
gt;gt; gt;gt; gt;gt; gt;gt; gt; formulas.
gt;gt; gt;gt; gt;gt; gt;gt; gt; It
gt;gt; gt;gt; gt;gt; gt;gt; gt; works beautifully until I try to print or do a print preview.
gt;gt; gt;gt; gt;gt; gt;gt; gt; Then
gt;gt; gt;gt; gt;gt; gt;gt; gt; it
gt;gt; gt;gt; gt;gt; gt;gt; gt; locks
gt;gt; gt;gt; gt;gt; gt;gt; gt; up excel and I have to restart. Any ideas about what is
gt;gt; gt;gt; gt;gt; gt;gt; gt; causing
gt;gt; gt;gt; gt;gt; gt;gt; gt; this?
gt;gt; gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt;gt; gt; Thanks!
gt;gt; gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;