I have an Excel workbook that, on opening, displays a message "Current printer is unavailable. Select another printer." Followed by a dialogue box with a list of print drivers.
Based on this thread, I thought the problem might be that one of the pages was set to Page Break Preview. But I've checked all the pages and they're set to Normal view.
What can I do to keep this message from popping up whenever I open the workbook?
2 Answers
There's a few things that we could take a look at for this one. Here are a few ideas that I have:
VBA Script or Macro: It could be that the workbook has an OnOpen script assigned that triggers printing when the workbook is opened. Does the workbook have any macros? Is it .XLSM?
Print Devices: Do you see this prompt when opening any other Office documents, including in other Office applications? Are you able to print normally to your default printer? This prompt could mean that Excel is trying to simply query the printers associated with the computer, and one of them isn't responding. It could be a network printer or an old printer that's no longer used but still added to Windows. I'd take a look at which printers are installed and remove any that you no longer use, as well.
Hope this helps! Let me know what you find.
3Try the below checklist in order.
- Save workbooks
- Restart Printer
- Restart PC
If the problem persists it may be a print queue issue, try deleting the affected print queue.
- Open Regedit by clicking on Start -> RUN -> Regedit
- Navigate to the affected print queue, HKEY_CURRENT_USER -> Printers -> Connections
- Delete the ,,[YOURPRINTERNAMEHERE]
