HP DesignJet 500 Excel Printing Issue

We are currently using a HP DesignJet 500PS42+HPGL2 and are trying to print an excel spreadsheet.  The issue that we are having is that the entire document isn't being printed.  The background grid is always complete, but the amount of text that is printed vertically is never the same and never complete.  One printout will have 10 lines of text and the next will have 4.  Print it again and you may get 15, but never the full spreadsheet.  Updated the driver to version 5.35 which is the latest one and still nothing.
b2crawfoAsked:
Who is Participating?
 
nobusConnect With a Mentor Commented:
you can uninstall the printer, and reinstall it. Also have the latest drivers :

http://search.hp.com/query.html?hpvc=US+-+English&lang=en&submit.x=7&submit.y=6&qt=DesignJet+500PS42+driver&la=en&cc=us
0
 
Asta CuCommented:
What is your Operating System and which version of Office?  Might want to check WindowsUpdate for the Operating System and this for Office and Excel   http://www.officeupdate.com  Does print preview let you modify the settings for the printer; such as margins, or other printer settings?  Or does print preview look OK, but the output doesn't?  

0
 
b2crawfoAuthor Commented:
OS win2k
Office 2k no updates


The preview is fine and shows all the data.  The adjust print settiings screen (margins and such) also hbas a print prteview and it is fine as well.  Uninstalled the printer already and reinstalled the printer with the latest drivers.  When the excel is printed on a LJ2300 it prints out fine which leads me to believe that it is a printer configuration issue.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
nobusCommented:
Can you test it on another system?
0
 
Asta CuCommented:
Yep; sure agree it is a printer settings issue.  When you uninstalled the printer initially, assume you uninstalled all related software and old drivers, prior to reinstalling with all updates.  Also, at least check out http://www.officeupdate.com to see what patches/fixes may apply to your version; sure can't hurt.  Also WindowsUpdate for the OS.  So many issues out there and updates typically are good things.
0
 
b2crawfoAuthor Commented:
Tested it on an XP Pro SP2 machine with Office 2000 fully updated and had the same results.  The Window 2000 machine is fully updated as well and still got an incomplete printout.
0
 
Asta CuCommented:
Here comes a potentially silly question, but often overlooked.... within Excel are the print parameters set for the full spreadsheet?
0
 
b2crawfoAuthor Commented:
Yup, set the print area to include the whole chart.  The background prints out fine including shading and coloring, it's just the actual text that it is seemingly printing at random.
0
 
Asta CuConnect With a Mentor Commented:
That is really strange; tested it using Office XP and all updates as well on a large spreadsheet but no shading/colors, running XP SP2, no problems on text or truncation, etc.  Curious if text prints OK if/when colors and shading aren't involved; curious if trying to modify the port settings to print when first page spooled makes a difference.  Strange, really strange.
0
 
nobusCommented:
you can try an Office repair
0
 
b2crawfoAuthor Commented:
Turned of the colors (the user was using a conditional filter) but the result was the same.  Tried the office repair and still no dice.
0
 
nobusCommented:
Are you talking about 1 spreadsheet, or do they all show this issue?
0
 
b2crawfoAuthor Commented:
Just one spreadsheet
0
 
Asta CuCommented:
No luck in trying to configure the printer/output to a smaller percentage in case it's some strange margin or printer-definition restriction?
0
 
nobusCommented:
I would copy this spreadsheet over into a new one, and try again
0
 
b2crawfoAuthor Commented:
Hey guys, turns out the fix has to do with a conflict between the print driver and excel's autofilter as seen on the following web page.

http://www.google.ca/search?q=cache:ZKLakY5jZR0J:forums1.itrc.hp.com/service/forums/questionanswer.do%3FthreadId%3D28792+designjet+500+not+printing+complete+spreadsheet&hl=en

I will split the points between you guys for aking the time to help me out.  Thank You.
0
 
Asta CuCommented:
Thank you, b2crawfo;  it is FANTASTIC that you posted the precise solution you found and implemented, it can help others who now will access this item in our database.  The link below also discusses various Excel Autofilter options and configs...
http://office.microsoft.com/en-us/results.aspx?Scope=HP%2CHA%2CRC%2CFX%2CXT&Query=excel+autofilter
Best wishes,
":0) Asta
0
All Courses

From novice to tech pro — start learning today.