Re: Excel prints blank rows instead of data

Tech-Archive recommends: Fix windows errors by optimizing your registry

This may be a shot in the dark, but in the first versions of XL97 I had
print issues where the preview looked fine and the printout data crossed
gridlines and looked really strange. The solution to that was to update my
video drivers...yes, it was the Video drivers!!!

To test without doing too much change you could start windows in safe mode
which I think loads VGA or SVGA and then try printing from XL...seems
strange, but it worked all those versions ago

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxxx


<tstephan@xxxxxxxxx> wrote in message
news:1149794811.686166.16990@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Print Preview always shows the correct output - no missing rows. I
haven't tried file/print vs the button. I have always used the button
or printed from print preview (both print missing rows). The printers
are all vastly different kinds (even a copier in one case). Yes rows
are missing randomly in the middle of the pages. I have never used the
set print area and most of the spreadsheets are created from scratch
(not from previous versions or other people).

I hope that helps.

David McRitchie wrote:
Does Print Preview operate the same as the attached printer.
Does File, Print operate the same as the print button.

Some of the things sound like a last cell problem (Ctrl+End), but
you get different results on different printers and you get empty
cells in middle. Are the printers all the same kind of printer.
Don't know what might show up from the answers, I guess it's more
to make sure different possibilities are tried.

Usually when people mess with the Print Area it is because they
have last cell problems.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ravi" <ravi.gyanguru@xxxxxxxxx> wrote in message
news:1149599311.889713.171440@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi Nick,

Try using another orinter and see if the same issue persists while you
are trying to print the excel ***.This will eleminate the printer
issue.
1.You might face this issue if you are setting the printing area in
excel.Try this
click on file then pint area then click clear print area.Then do page
setup..try to print

Perform all these steps in a local printer and not a network printer.If
the issue persisits in the local printer also probably calling
microsoft would be the best option


Regards
Ravi




.

Quantcast