Excel prints blank rows instead of data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tstephan@gmail.com - 01 Jun 2006 14:55 GMT

I recently received a new laptop with Office 2003. When I print excel
spreadsheet, several blocks of rows will simply not print - leaving
blanks in the middle of my documents. Pressing "print" twice in a row
produces completely different sets of blank rows. After printing many
times I may get one with all the rows present (obviously with long
spreadsheet I am statistically not a happy camper).

Regards,
Todd

Reply to this Message

Nick Hodge - 01 Jun 2006 22:06 GMT

Try re-installing your print drivers

Signature

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

>I recently received a new laptop with Office 2003. When I print excel
> spreadsheet, several blocks of rows will simply not print - leaving
[quoted text clipped - 5 lines]
> Regards,
> Todd

Reply to this Message

tstephan@gmail.com - 02 Jun 2006 16:53 GMT

I never manually installed any drivers as these are network printers.
The problem occurs across several of the printers I have tried (all
different brands/models).

> Try re-installing your print drivers
>
[quoted text clipped - 15 lines]
> > Regards,
> > Todd

Reply to this Message

Nick Hodge - 02 Jun 2006 20:56 GMT

The same applies...Excel relies on interaction with print drivers, often
upgrades, update and new installs can disturb this, ask you administrator to
re-install on your machine

Signature

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

>I never manually installed any drivers as these are network printers.
> The problem occurs across several of the printers I have tried (all
[quoted text clipped - 19 lines]
>> > Regards,
>> > Todd

Reply to this Message

tstephan@gmail.com - 05 Jun 2006 16:37 GMT

Hi Nick,

I spoke with our IT and they stated that when connecting to a network
printer it automatically installs the printer driver (as I knew). They
state that the drivers are all the latest drivers available for those
printers. Is there anything else I can try? This is a new laptop with
few apps on it other than visual studio (most versions). Excel is
somewhat useless to me as I can not get a printout without at least a
few blank rows (I have started to patch partial printouts together to
acheive one good printout).

Regards,
Todd

> The same applies...Excel relies on interaction with print drivers, often
> upgrades, update and new installs can disturb this, ask you administrator to
[quoted text clipped - 31 lines]
> >> > Regards,
> >> > Todd

Reply to this Message

Ravi - 06 Jun 2006 14:08 GMT

Hi Nick,

Try using another orinter and see if the same issue persists while you
are trying to print the excel sheet.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

Reply to this Message

tstephan@gmail.com - 07 Jun 2006 14:18 GMT

I tried to clear the print area which seemed to work yesterday - every
printout worked. However this morning, same spreadsheet, same clear
print area, and I received blank rows again. I have tried several
network printers and all have the same problem so I believe it must be
Excel or something specific to my machine.. It would be difficult to
setup a local printer since none are available at the office.

> Hi Nick,
>
[quoted text clipped - 12 lines]
> Regards
> Ravi

Reply to this Message

David McRitchie - 08 Jun 2006 03:51 GMT

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

> Hi Nick,
>
[quoted text clipped - 12 lines]
> Regards
> Ravi

Reply to this Message

tstephan@gmail.com - 08 Jun 2006 20:26 GMT

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.

> Does Print Preview operate the same as the attached printer.
> Does File, Print operate the same as the print button.
[quoted text clipped - 29 lines]
> > Regards
> > Ravi

Reply to this Message

Nick Hodge - 08 Jun 2006 21:18 GMT

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

Signature

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

> 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
[quoted text clipped - 39 lines]
>> > Regards
>> > Ravi

Reply to this Message

M.Hunt - 20 Jun 2006 20:44 GMT

I have recently started getting the same problem. Was there an update from
Microsoft around the beginning of June?

I can print the same spreadsheet three times. One time there might be
several rows with no data. Another time things look OK with no blank rows,
but there are rows that did not print. Another time it prints OK. For a while
it was printing one row plus part of another row in the same output row --
again with missing data.

It ALWAYS looks OK in print-preview.
I have tried this on three different network printers with the same results.
I send the same spreadsheet to someone else and have them print it and the
results are always OK.

Today I ran into another issue. I typically to a ctrl-p to print; but today
I get a subscript out of range error.

Any new ideas?

M.Hunt

> 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
[quoted text clipped - 5 lines]
>
> I hope that helps.

Reply to this Message

tstephan@gmail.com - 26 Jun 2006 18:19 GMT

Unfortunately I received this new laptop recently, so everything had
been loaded recently making it difficult to track down what is causing
the problem. I repaired office but that didn't fix the problem. In
fact, with different spreadsheets my problem has changed to crashing
randomly, missing or garbled data in printouts. Suddenly it popped
into my head that I installed VS 2005 Team System Explorer which
integrates with Excel - something I didn't have on my previous laptop.
I uninstalled it and so far 5/5 printouts have been perfect. I expect
there is a bug in the integration even if you aren't using it (which I
never had).

> I have recently started getting the same problem. Was there an update from
> Microsoft around the beginning of June?
[quoted text clipped - 26 lines]
> >
> > I hope that helps.

Reply to this Message

Rate this thread: