When printing a document on deskjet an empty page comes out

S

Sanna

I try to print an Excel document on an HP Desjet 3820 printer, but both print
prewiew and printout are blank. When checking the print area my data shows
correctly.
 
S

Sanna

I'm sorry, it didn't work to clear the print area. I'm still grateful for
more ideas!
best/sanna
 
D

Dave Peterson

Donald's suggestion usually works ok for me (I don't think it's ever failed.)

What happened when you selected the range to print and then reset the print
area?
 
S

Sanna

Helps for you guys doesn’t necessarily mean it helps for me, sorry. Donald’s
suggestion perhaps never failed running under Windows, but I run under Mac
OSX 10.3.5.

I’ll tell you step by step exactly what I’m doing, and see if we at least
can confirm the problem.

1. I choose ‘File’ -> ‘Print...’ and then ‘Print Preview...’, just to
confirm the print preview is empty. After having closed the empty preview I
notice a part of the document have got marked with dashed lines.

2. I do ‘File’ -> ‘Print Area’ -> ‘Clear Print Area’, and the dashed lines
dissapears.

3. I mark a rectangle including all non-empy cells in my document, and do
‘File’ -> ‘Print area’ -> ‘Set print area’. The dashed lines appear as
expected.

4. I do ‘File’ - > ‘Print...’ and again ‘Print Preview...’. Again empty. If
I confirm the print dialog, an empty page really comes out.

I’ve tried Print Selection, Print Active Sheets, Print All, Print 1 to 1,
Normal Size, Fit to One Page, ... but in general I try stick to normal
settings. What I can do is to open a new document and do copy-paste, and that
print works, but then I have to rearrange column widths and row heights.
There are also other solutions for me to print (copy into Illustrator for
example), but it is very anoying that sooner or later my excel documents get
“locked†like this and I have to do a lot of extra work to get them out on
paper.

Thanks for taking your time.

P. S. Just tried to print on my lab-PC - no problem. I guess this is an
Excel-OSX incompatibility problem. In that case, what can be done about this?
 
D

Dave Peterson

It could be a "helpful" macro that's making your life miserable.

Can you open you workbook with macros disabled?

Maybe you can just toggle the security setting ot High (or whatever macxl
supports).

In windows xl2002, I'd do:
Tools|macro|security|Security level tab
and set it to high.

then open the workbook. And answer no to the enable macros prompt.

Now try that same stuff you did before.

There are quite a few questions about how to stop users from printing
worksheets. Maybe the developer (if it wasn't you) didn't want you to print the
workbook/worksheet.
 
S

Sanna

Sorry, cannot be that either. I created the document myself and it contains
no macros. I will simply try copy-paste once and see if the problem comes
back or not. Need to get this thing out of the way.

thanks for bothering..
 
Top