Improve company productivity with a Business Account.Sign Up

x
?
Solved

Printer Setup Pop-up when Opening Excel File

Posted on 2016-10-14
4
Medium Priority
?
13,133 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 7

Expert Comment

by:D Patel
ID: 41843489
Hi mamelas,

Is there any VBA code within the workbook?

Regards,
D Patel
0
 
LVL 9

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

579 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