Solved

Printer Setup Pop-up when Opening Excel File

Posted on 2016-10-14
4
368 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
  • 2
4 Comments
 
LVL 6

Expert Comment

by:DPatel
ID: 41843489
Hi mamelas,

Is there any VBA code within the workbook?

Regards,
D Patel
0
 
LVL 8

Accepted Solution

by:
Koen earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
splitting text of cell to columns 14 25
macro for closing opened workbook 6 21
Excel Copy Macro down foe each row 4 21
simple vba query 9 23
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now