The Real (and Virtual) Adventures of Nathan the IT Guy

Feb 18 2009   4:47AM GMT

Excel Printing out Duplicates

Nathan Simon Nathan Simon Profile: Nathan Simon

 Well here’s a good one for you, and I hope that this helps someone if they run into the same issue. Two PC’s both have the same printer, and both have the exact same drivers. The printer was an HP LaserJet 1320. The issues was that Excel would print out duplicate copies of everything. Running Excel in safe mode, resulted in the same issue, duplicates. One would think that renaming book.xlt may fix the issue as it may be an underlying setting in the workbook, but that wasn’t the issue either as one did not exist on either PC.

The next step was to go after the printers. Now here is the kicker… the old printer was a USB Printer shared to other PC’s, thus the printer would show up as “HP LJ 1320 on pcname” but the port was a TCP/IP Port pointing to 192.168.1.25. What I ended up doing was wiping the printer out completely, and installing from scratch, using the existing port. After doing that excel printing was fine.

I guess the moral of this story is if you having printing issues with Excel, check to see if it is Excel causing the issues, running Excel in safe mode* will give you a temporary clean slate  to work with. If Printing issues persist, check the workbook file(book.xlt), just search for it under program files. Lastly for duplicate print-outs in Excel… wipe out and re-add the printer. More troubleshooting tips can be found here on the official Microsoft “How to troubleshoot startup problems in Excel” KB article 280504

NS

* click on start – run – then type “C:\Program Files\Microsoft Office\Office\Excel.exe” /s (change this based on the location of your installation)

1  Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Saqib
    Nathan, I had the same issue, which was due the corrupt installation procedure i.e. instead of installing as local printer i had installed it as network printer on the machine where the printer connected. If u or anyone need support, do inform me. Thanks.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: