MyUMUC: Issue - Unable to Download Query from PeopleSoft into Excel

 

MyUMUC: Issue – Unable to Download Query from PeopleSoft into Excel

Reporting tools in MyUMUC (PeopleSoft) use Excel for report results.

Issue:

Customer is unable to download a query into Excel (i.e. TRW_EE_W_SALARY). The query results are returned as “null”.

Cause:

The Microsoft Excel Enable Editing function is turned on.

Solution:

Turn of Enable Editing in Microsoft Office 2010 with the following steps:

  • Open Excel 2010
  • Click on Office or File button, and select Options.
  • Under Options select Trust Center in the left pane.
  • Click on Trust Center Settings in the right pane.
  • Click on the Protected View in the left pane of Trust Center window
  • Uncheck Protected Mode Options and select Ok

Retry the query download from Reporting Tools