Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel 2003 spreadsheet prinout disagrees with print preview

When printing an 18 col by 191 row spreadsheet on 11x17 paper, the resulting
printout has different data than the actual spreadsheet or the print preview.
Print preview seems to be in agreement with the spreadsheet. The actual
printout is accurate to about the middle of the first page, and then repeats
data from several previous rows and then repeats again. I thought maybe
having word wrap on text cells might cause a problem, so I turned it off only
to get a different permutation. I have certain rows highlighted - the
highlights appear with incorrect data in them so the background attribute
seems to be correctly assigned to the row but the data is not correctly
assigned to the row.

The workaround I have found is to port the spreadsheet to word and then
print it.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2003 spreadsheet prinout disagrees with print preview

It sounds like it's a printer/printer driver problem.

Can you test against a different printer--or install a new version of that
printer's driver?

Marion Douglas wrote:

When printing an 18 col by 191 row spreadsheet on 11x17 paper, the resulting
printout has different data than the actual spreadsheet or the print preview.
Print preview seems to be in agreement with the spreadsheet. The actual
printout is accurate to about the middle of the first page, and then repeats
data from several previous rows and then repeats again. I thought maybe
having word wrap on text cells might cause a problem, so I turned it off only
to get a different permutation. I have certain rows highlighted - the
highlights appear with incorrect data in them so the background attribute
seems to be correctly assigned to the row but the data is not correctly
assigned to the row.

The workaround I have found is to port the spreadsheet to word and then
print it.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel 2003 spreadsheet prinout disagrees with print preview

It seems likely a printer/printer driver problem...

HP LaserJet 5000 Series PCL 5e - all pages have issues
SHARP AR M550N PS - odd pages are bad, even seem OK
Lexmark Optra W810 PCL - looks OK on all pages

"Dave Peterson" wrote:

It sounds like it's a printer/printer driver problem.

Can you test against a different printer--or install a new version of that
printer's driver?

Marion Douglas wrote:

When printing an 18 col by 191 row spreadsheet on 11x17 paper, the resulting
printout has different data than the actual spreadsheet or the print preview.
Print preview seems to be in agreement with the spreadsheet. The actual
printout is accurate to about the middle of the first page, and then repeats
data from several previous rows and then repeats again. I thought maybe
having word wrap on text cells might cause a problem, so I turned it off only
to get a different permutation. I have certain rows highlighted - the
highlights appear with incorrect data in them so the background attribute
seems to be correctly assigned to the row but the data is not correctly
assigned to the row.

The workaround I have found is to port the spreadsheet to word and then
print it.


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2003 spreadsheet prinout disagrees with print preview

Use the Lexmark <bg.

Marion Douglas wrote:

It seems likely a printer/printer driver problem...

HP LaserJet 5000 Series PCL 5e - all pages have issues
SHARP AR M550N PS - odd pages are bad, even seem OK
Lexmark Optra W810 PCL - looks OK on all pages

"Dave Peterson" wrote:

It sounds like it's a printer/printer driver problem.

Can you test against a different printer--or install a new version of that
printer's driver?

Marion Douglas wrote:

When printing an 18 col by 191 row spreadsheet on 11x17 paper, the resulting
printout has different data than the actual spreadsheet or the print preview.
Print preview seems to be in agreement with the spreadsheet. The actual
printout is accurate to about the middle of the first page, and then repeats
data from several previous rows and then repeats again. I thought maybe
having word wrap on text cells might cause a problem, so I turned it off only
to get a different permutation. I have certain rows highlighted - the
highlights appear with incorrect data in them so the background attribute
seems to be correctly assigned to the row but the data is not correctly
assigned to the row.

The workaround I have found is to port the spreadsheet to word and then
print it.


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel 2003 spreadsheet prinout disagrees with print preview

The Lexmark is 2 elevator rides away... however,

there is a Postscript driver for the HP Laserjet 5000 installed on our
machines by IS. It is slower, but it works correctly. There is also a PCL 6e
on the hp.com website, but I need IS permission to install it - it may
perhaps also work.

Thanks for your response!

marion

"Dave Peterson" wrote:

Use the Lexmark <bg.

Marion Douglas wrote:

It seems likely a printer/printer driver problem...

HP LaserJet 5000 Series PCL 5e - all pages have issues
SHARP AR M550N PS - odd pages are bad, even seem OK
Lexmark Optra W810 PCL - looks OK on all pages

"Dave Peterson" wrote:

It sounds like it's a printer/printer driver problem.

Can you test against a different printer--or install a new version of that
printer's driver?

Marion Douglas wrote:

When printing an 18 col by 191 row spreadsheet on 11x17 paper, the resulting
printout has different data than the actual spreadsheet or the print preview.
Print preview seems to be in agreement with the spreadsheet. The actual
printout is accurate to about the middle of the first page, and then repeats
data from several previous rows and then repeats again. I thought maybe
having word wrap on text cells might cause a problem, so I turned it off only
to get a different permutation. I have certain rows highlighted - the
highlights appear with incorrect data in them so the background attribute
seems to be correctly assigned to the row but the data is not correctly
assigned to the row.

The workaround I have found is to port the spreadsheet to word and then
print it.

--

Dave Peterson


--

Dave Peterson



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2003 spreadsheet prinout disagrees with print preview

Maybe a midnight trip to the HP and Sharp sites to get new printer drivers would
be worth the trip???

Or get your boss involved to help with IT??????

Marion Douglas wrote:

The Lexmark is 2 elevator rides away... however,

there is a Postscript driver for the HP Laserjet 5000 installed on our
machines by IS. It is slower, but it works correctly. There is also a PCL 6e
on the hp.com website, but I need IS permission to install it - it may
perhaps also work.

Thanks for your response!

marion

"Dave Peterson" wrote:

Use the Lexmark <bg.

Marion Douglas wrote:

It seems likely a printer/printer driver problem...

HP LaserJet 5000 Series PCL 5e - all pages have issues
SHARP AR M550N PS - odd pages are bad, even seem OK
Lexmark Optra W810 PCL - looks OK on all pages

"Dave Peterson" wrote:

It sounds like it's a printer/printer driver problem.

Can you test against a different printer--or install a new version of that
printer's driver?

Marion Douglas wrote:

When printing an 18 col by 191 row spreadsheet on 11x17 paper, the resulting
printout has different data than the actual spreadsheet or the print preview.
Print preview seems to be in agreement with the spreadsheet. The actual
printout is accurate to about the middle of the first page, and then repeats
data from several previous rows and then repeats again. I thought maybe
having word wrap on text cells might cause a problem, so I turned it off only
to get a different permutation. I have certain rows highlighted - the
highlights appear with incorrect data in them so the background attribute
seems to be correctly assigned to the row but the data is not correctly
assigned to the row.

The workaround I have found is to port the spreadsheet to word and then
print it.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not Responding Excel 2003 during print preview kamel kaled Setting up and Configuration of Excel 0 February 15th 07 06:39 PM
Print Preview Freezes Excel 2003 (spoolsv.exe) [email protected] Excel Discussion (Misc queries) 0 October 17th 06 11:49 PM
Print Preview Zoom grayed out Excel 2003 mesquite57 Excel Discussion (Misc queries) 0 August 15th 06 08:35 PM
Text boxes Excel 2003 change position in print preview James McCann Charts and Charting in Excel 1 March 27th 06 12:51 AM
I cant see my excel spreadsheet but only in Print Preview? Karyn H Excel Worksheet Functions 1 January 7th 06 01:54 AM


All times are GMT +1. The time now is 06:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"