Re: Excel prints blank rows instead of data



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).

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

I can print the same spread*** 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 spread*** 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

"tstephan@xxxxxxxxx" wrote:

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.


.