Excel workbook is not held or stored on the printer when the whole workbook is printed to the private or secure area of the printer (915971)

WORKAROUND

To work around this problem, use one of the following methods.

Method 1:

Note This workaround may not work in all configurations.

Select the first worksheet in the Excel workbook, and then print the whole Excel workbook to the private or secure area of the printer.

Method 2:

Set the printer settings for each worksheet before you print the workbook.

To do this, follow these steps.

Note The following steps were performed with a Xerox Document Centre 265 set as the default printer.

1. Open your workbook.
2. On the File menu, point to Print, and then click Properties.
3. Click the Advanced button.
4. In the Job Type drop down, select Secure Print.
5. Enter the PIN and confirm PIN, and then click OK.
6. Click OK to close the Advanced Properties dialog box.
7. Click OK in the Printer Properties dialog box.
8. Click Close to dismiss the Print dialog box.
9. Repeat this for every sheet in the workbook.
10. Print the entire Workbook.
    
    When you print your workbook, all worksheets are printed with the Secure Print option.

Note Microsoft realizes that having to set the print properties individually on each sheet is very inconvenient for large files, and is considering a fix for a future version.

Method 3:

Add two printers in Microsoft Windows that are connected to the same printer. Name one printer to indicate that it is using the Private Printing or Secure Printing options. On that printer, set the printer to Print to the Printer Storage area using a PIN. When you print from Excel, choose the printer set for Print Storage when you want to use the Private Printing or Secure Printing options.