solution Contentsolution Content

HP LaserJet Printer Series and Multifunction Printers (MFPs) - Printing from Microsoft Excel: Printer Properties Settings Are Saved with Microsoft Excel File

Issue

A user may experience unexpected results when printing from Microsoft Excel, for example in terms of paper size, paper source, duplexing, page formatting, and/or job storage. Additionally, when opening the printer properties dialog box within Excel, printer settings are different from what is expected.

Solution

A user many encounter this behavior under the following conditions when an Excel workbook is shared among different users:
  • User A creates or opens an Excel workbook, makes changes within the Printer Properties dialog, and saves the workbook.
  • User B has the same printer (driver) model set as default as User A.
  • User B accesses the same Excel workbook that User A had saved.
  • User B will now inherit the configuration settings that User A had defined within Printer Properties prior to saving the workbook. These configuration settings may differ from those default settings of User B.
This behavior is a known issue specific to Excel 2003, Excel 2007, Excel 2010 and Excel 2013, and it is described in detail in the Microsoft Knowledge Base Article 829766, Mailbox and other printer-specific settings are saved with an Excel file.
To locate this article, go to https://support.microsoft.com, and then search for 829766.
Microsoft offers potential workarounds and solutions within the article.
note:
A common example of this issue is when User A has printed the Excel workbook as a stored job and saves the workbook. User B, again with the same default printer model as User A, opens the shared Excel workbook and prints it, is likely expecting the workbook to output directly to the printer. But instead the job was sent as a stored job with User A's credentials. From the perspective of User B, the job failed to print.
Again, a key requirement for this behavior is that both User A and User B have the same default printer model. They do not necessarily have to be printing to the same physical device but just the same default printer driver.