Excel tries "Accessing Printer" while opening specific workbook

windows-7 microsoft-excel microsoft-excel-2010

130,884

Solution 1

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.

Solution 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.

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

Good luck!

Solution 3

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.

130,884

vaindil

Updated on September 18, 2022

Comments

vaindil almost 2 years

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.
- Ramhound about 10 years
  
  There has to be something unique about this file. Honestly the only way I know how to determine the cause, is to to create a copy of the excel document and to elminate the possible causes 1-by-1. This assumes this problem only happens with this specific file.
- vaindil about 10 years
  
  I just updated the OP to clarify that this only happens to one user with this one file. Is it possible that it's a printer driver issue?
- Ramhound about 10 years
  
  Its your hardware and network. If this was my network/hardware I would image the system to defaults. Have you tried my suggestion?
- vaindil about 10 years
  
  I'm not sure what to eliminate 1-by-1--I'm not sure what troubleshooting steps to take.
- Ƭᴇcʜιᴇ007 about 10 years
  
  Are you saying that other users can open the same exact file from other computers without seeing the same results? If this same user logs into a different computer and opens the file, do they have the same problem? If someone else logs into this user's computer, can they open the file OK? What have you tried already? Anything? If so, what was it? IE: have you examined the Excel file for Auto-Open type macros yet?
- Ramhound about 10 years
  
  @Vaindil - The first step would be to restore the configuration of the machine to the default settings. Since you don't understand what to elminate even though I was very specific in my first comment thats the second best solution.
Run5k over 7 years

First of all, welcome to Super User! We always welcome contributions from our community members. However, this doesn't really provide an answer to the question... it is essentially a comment supporting an answer that already exists. We ask that you consider up-voting the existing answer, rather that posting a duplicate answer instead of a comment because you don't have sufficient reputation yet. Thanks for your help!
Synn over 7 years

I think this is a more concise answer than the one from the original poster.
Seany84 about 7 years

Choosing the XPS printer when the file was opened resolved the issue for me. I tried different machines and all had the "printer popup". Nothing to do with printer drivers.
edi almost 4 years

I had similar problems with some network printers which are not always available. Excel tries to optimize the view to the current printer. So as suggested you could change to any printer device driver which is never offline - you could also use e.g. any PDF document printer.
Community over 2 years

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.