REP0001 - Distribution - Can not print Excel report when Protected View is enabled

DESCRIPTION

The protected view settings of Excel 2010 are enabled and printing is blocked.

SEVERITY

Warning

IMPACT

Reports will not print successfully.

TROUBLESHOOTING STEPS

If Protected View is enabled for Excel 2010, then Report Distribution will be unable to printing Excel reports.

You must disable protected view for printing to function.

  1. Open the excel report.
  2. Click the File : Options.
  3. In the left pane, Click Trust Center.
  4. Now, on the right pane, click the Trust Center Settings button.
  5. At this point you should be in the Trust Center dialog window.
  6. In the left pane, click Protected View.
  7. Untick the following options:
  8. Click OK.

To verify if this was successful return to the Report Inbox and click on a report. If excel opens and protected view is still enabled try setting the following registry key;

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security\FileValidation] “EnableOnLoad”=dword:00000000

APPLIES TO

CCM

References