Helping people with computers... one answer at a time.
Is the printer at fault? Or the program? One way to troubleshoot is to try printing to a virtual printer.
I just set up my new Windows 7 Professional system. I installed Office 2007 and HP Photosmart C309A and transferred my documents from my XP system. Everything works great except that I can't print from Excel 2007. HP says it's Microsoft's fault and Microsoft says it's HP's fault so no one will help me. It looks like, from HP's site, that I'm not alone and no one has an answer. I've uninstalled and reinstalled, disconnected, reconnected, booted, and rebooted and still get the same error message, "The file could not be printed due to an error on HP Photosmart C309A." No error numbers or reference numbers.
In this excerpt from Answercast #49, I look at a case where a printer cannot print from Microsoft Excel and suggest a work-around.
So, I don't have a specific answer to your problem.
I'm assuming that you've done all of the appropriate things of making sure that the printer is connected, that it's turned on; you know, the really basic stuff.
You've gone on well past that, by reinstalling and reinstalling drivers and so forth.
One test that I'm going to suggest you do, that I think will help identify where the problem lies at least, is to go out and get CutePDF.
CutePDF is a printer driver that will print your document not to a printer but to a PDF file.
It actually creates a PDF file of the document that's being printed.
If that works in Excel, then you know that Excel can print.
You might then be able to take the document and view it in a PDF reader like Acrobat Reader or Foxit:
It is possible that:
a) This could be a work around, but...
b) This then will either confirm or deny that the problem is with the printer or not.
If Foxit (or one of the PDF displaying applications) can print the document;
Then clearly the problem centers around Excel.
I'm not really sure what I would recommend in a case like that. Part of me says you might want to consider reinstalling Office, but that's really just grasping at straws.
If on the other hand Foxit fails or if the PDF reader fails to print the document and the error message is the same;
You will know that the problem is with the printer or the printer software.
So, that's about the best advice I can give you to help narrow it down a
little bit more. If the problem really is only with Excel, then I would
certainly give this PDF approach a try as a work around.. if, for no other
Next from Answercast 49 - My trip pictures vanished from my memory card. How can I recover them?
Comments on this entry are closed.
If you have a question, start by using the search box up at the top of the page - there's a very good chance that your question has already been answered on Ask Leo!.
If you don't find your answer, head out to http://askleo.com/ask to ask your question.