How can I prevent Word/Excel from trying to reach the printer?

Question

Whenever I perform certain operations in Word or Excel (2007), these applications are trying to reach the printer. I work on a laptop at work and at home. When I'm at home (not connected to my work's printer), I sometimes have to wait many seconds for Word/Excel to become responsive after performing operations such as making a cell bold in Excel, or pasting a paragraph from a webpage to Word.

In Word I may have a small message at the bottom saying something like "Trying to connect to the printer, press Esc to abort".

However

1. That option does not exist in Excel

2. and Sometimes if I do press Esc, Word crashes.

Is there a workaround?

Solution 1

My default printer is the PDF printer installed via CutePDF, which is free :)

As long as I have a local printer defined, and it's default, everything's fine.

I've seen the exact behavior you describe when switching fonts, and I think it's because some printers have allowable fonts, and Word is checking to see if they'll actually render on the printer (though why this is necessary until you actually print is beyond me).

Solution 2

I think the only way to avoid this is by having a default printer that is not remote. Here is a simple JScript that will set your default printer to "Microsoft XPS Document Writer" (assuming you have it installed) which is always a local, non-hardware printer.

var network = new ActiveXObject("WScript.Network");
network.SetDefaultPrinter("Microsoft XPS Document Writer");

Save that as SetDefaultPrinter.js and you can either run it using the command line:

cscript //nologo SetDefaultPrinter.js

...or you could just save it to your desktop and double-click to run it.

Solution 3

One option would be something like this to automatically switch your printer based on IP address. It presumably could switch to none when you're at home.

Solution 4

It might help to change your default printer to one that is defined locally.

There isn't an obvious (to me at least) rational reason for an application to interact with a printer when changing a font style, but if that is what is happening then at least a local printer won't be across an unconnected network.

Solution 5

Whilst you can check the ActivePrinter property in Excel 2007, you can't set it for some reason (even though you can in a Word VBA script). Here's the workaround in Excel VBA:

Set oWord = CreateObject(Class:="Word.Application")

oWord.ActivePrinter = NewDefaultPrinter$

oWord.Quit False

Set oWord = Nothing

It is especially useful to change the default printer if it's currently set to a network printer, as delays are experienced if the VBA macro modifies a workbook (delete columns etc) - it seems to check on the printer with each change made. To prevent this the default printer needs to be set to a local printer during the workbook modification process, then back again afterwards.

View more solutions

Comments

[Roee Adler]

I don't have a local printer and I really like the fact I have my default printer defined as the work one (I print a lot)

[Roee Adler]

Just made that change, but I'm currently connected to the network. I'll check if it works later, thanks.

[David Yates]

happy you're all set :)