Excel tries "Accessing Printer" while opening specific workbook

Excel 2010 (Windows 7 Professional 64-bit) is loading a specific Excel file to 100%, then the status message on the splash screen rotates between "Opening (100%)" and "Accessing Printer". It sits and rotates between the two for a full 60-90 seconds before the document finally opens.

What can I do to prevent the "Accessing Printer" message from appearing on this specific document? I've tried repairing it with no luck. This happens only to one user on this one file.

6

6 Answers

Changed the default printer to the XPS document writer and the problem was resolved. I therefore uninstalled his previous default printer and removed the driver through Print Management, then reinstalled it. The problem was resolved.

2

This seems to be a pretty common problem with Excel 2010. There could be a great variety of things wrong with your computer. I cannot help you very much with such a vague and unresearched question. Here is a list of links that may help you research your question more. If you edit your question to be more specific, I will edit this answer with a specific answer.

• Excel 2010 accessing printer when opening file
• "Accessing Printer Press" Freezes Excel and Powerpoint
• Excel 2010 Freezing and Getting "Not Responding" Message
• When Openning Excel 2010 Showing Accessing Printer,
• Excel 'Accessing Printer' issue
• Fix Issue of Microsoft® Excel 2010 Hangs
• Excel 2010 hangs/crashes on a daily basis!

I found all of these results one the first page of Google after searching excel hangs on "accessing printer".

Good luck!

0

Problem for me was that I'm working off network, so when this particular document tries to access the printer it fails and hangs up - did as the original poster answered himself and set the default to XPS and it works perfectly.

2

For this kind of issue, I believe MS Excel tries to access the default printer when opening the document (I had a file in MS Excel 365 set in Page break preview, under the View menu). My default printer had been set to a shared printer from a retired PC, so I guess MS Excel was trying to contact the printer in vain, and hanging at this point. Solution is to change the default printer to a reachable/local printer, and possibly remove/delete the offending printer from control panel. After this, the workbook opens without issue

I found out that if I disable the following Add-ins in Excel: Analysis ToolPak, Analysis ToolPak - VBA, Solver Add-in then the problem goes away.

1

Just had this happen to me and although the first answer is quite helpful another possible solution (the one I actually used) is to do the following.

1. Make sure all documents are out of the print que
2. Restart (or stop ..then start) the "Print Spooler" service by entering "Services.msc" from the run dialogue.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy