Excel save print settings within document

Hi there guys,

We have just recently shifted our users from one print server to another with updated universal drivers for the lexmark printers we have. In this context we are dealing with some issues when printing older excel documents, they get scaled down to abe 25% in the upper leftcorner,  I have tried to find a solution for this but sadly no luck, hopefulyl any of you can help...

I have googled alot and found some articles regarding this and for some reason the solutions doesn't works in our enviroment.

this is what we have tried:

*ClickStart, clickRun, typeregedit, and then clickOK.
*Locate and then click the following key in the registry:
*Excel 2003 -HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
*Excel 2007 -HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options
*Excel 2010 -HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
*On the Edit menu, point to New, and then click DWORD value.
*Type QFE_Sitka, and then press ENTER.
 On the Edit menu, click Modify.
*Type 1, and then clickOK.

even this has ben tried.

Change the default printer to a different printer.
In Excel, open the workbook that is experiencing the problem.
On the File menu, click Print.
In the Printdialog box, clickCancel.
On the File menu, click Save.


Is there a way to delete the printpropeties for the document itself?

these are the article i have looked at:

https://support2.microsoft.com/default.aspx?scid=kb;en-us;829766
http://community.spiceworks.com/topic/154021-printer-settings-being-saved-to-worksheet-and-transferring-to-other-users-who-op

thank you in advance.
LVL 1
HakumAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ThomasMcA2Commented:
Did you reset the Application.ActivePrinter property like the Spiceworks link suggested?
HakumAuthor Commented:
My problem is that in the offices and braches there a various printers and so its difficult for me to set the printer to a standard printer... or have i misunderstood it?

here is there code:

Private Sub Workbook_Open()
'
' This macro resets print settings to remove saved settings
'
'Store the name of the current printer as a string variable
Dim STDprinter As String
STDprinter = Application.ActivePrinter

'Change the default printer
Application.ActivePrinter = "Microsoft XPS Document Writer on ne00:"

'Save the active workbook
ActiveWorkbook.Save

' restore original printer
Application.ActivePrinter = STDprinter

'Save the active workbook
ActiveWorkbook.Save

End Sub

Open in new window

ThomasMcA2Commented:
It doesn't matter what their real printer name is. The macro saves it, then changes the saved printer to one that is common to many Microsoft Office installations, and then restores their old printer name.

Running that script should clear any saved print settings.

Note that the port for my XPS Document Writer is "XPSPort", not "ne00." Check the Ports tab of the printer properties on one or two of the systems that need to be fixed to see what their port name is called.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

HakumAuthor Commented:
I have tried this and did try to set it to the XPS printer and a PDF printer... but no luck :(

is there maybe a way to delete this cached print config / printer setting within the document? and start from scratch?
ThomasMcA2Commented:
Try making the Registry change that the Microsoft link suggested, then save the workbook, then close it and reopen it. Based on the wording of the Microsoft link, I'm expecting the save process to clear the settings that Excel saved.

If that fixes it, then both the Registry change and re-saving the broken workbooks can be automated via VBA.
HakumAuthor Commented:
sadly it did not fix it, i have taken the issue to ms

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HakumAuthor Commented:
No working solution.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.