?
Solved

Printer Setup Pop-up when Opening Excel File

Posted on 2016-10-14
4
Medium Priority
?
5,851 Views
Last Modified: 2016-10-21
Dear Excel Experts,

I am using Excel 2007 SP3 with Win 7 Pro (64bit) and I have noticed thatsometimes when I open an Excel Workbook the following window pops-up preventing me to work in the Workbook as well as print it.
( I am not sure if it is being caused in specific Workbooks or randomly)

Page Setup Pop-up Window
The workaround that I have currently found is to log-off and log-on to Windows again.
That said the same Excel file will open with no issue this time.

Please also note that the Excel files are stored/edited on a Network drive and not locally.

Seems that this issue is related to Excel application or/and Excel File and not to Printer's Driver/Software.

Kindly advise if you have faced the above issue and the workaround that worked for you.

Thank you in advance,
Mamelas
0
Comment
Question by:mamelas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 7

Expert Comment

by:D Patel
ID: 41843489
Hi mamelas,

Is there any VBA code within the workbook?

Regards,
D Patel
0
 
LVL 8

Accepted Solution

by:
Koen earned 2000 total points
ID: 41843651
could it be that the printer default is set to a printer that is not available at the moment you open the file ?

if you have printer related items in your sheet (e.g. the page breaks are visible), excell requires a default printer to be 'reachable'. if you have set your default printer to a network printer, you will then get this error if the printer is not available.
0
 

Author Comment

by:mamelas
ID: 41843872
Dear Patel
I have to check this next time that the error will reappear since it is generated randomly and not to specific Workbook.

Dear Koen
This printer is connected locally and is always available.
I have not seen any connection problem to the Printer using various apps so far.

Any other possible reason ??
0
 

Assisted Solution

by:mamelas
mamelas earned 0 total points
ID: 41853327
Dear Sirs,

I have also found the below workarounds which I would like to post for future reference of the community.

Workaround 1:
As per Koen advise, having a network printer as default, even when you print using a completely different printer or no printer at all it will cause this error to sometimes on some machines pop up.
Because of this random issue it is recommended to use as default printer a LOCAL printer connected
via USB or a virtual printer such as XPS.

Workaround 2:
In case that at least one of the sheets in your workbook had been saved with the "Page Break Preview" this may cause the error in subject since in Page Break Preview the Excel will automatically search for a printer.If the printer is down, not reachable etc., it will cause the Page Setup pop-up.
You should change it to normal mode for all worksheets within the workbook.

Mamelas
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question