Blank Worksheets in Excel

Summary

This article provides step-by-step instructions to resolve the issue where Excel reports downloaded from PeopleSoft open to a blank worksheet. The problem is often caused by Excel's Protected View settings, which prevent certain content from being displayed. By adjusting these settings, you can ensure the report opens correctly.

Detailed Steps

If you download a report in Excel format from PeopleSoft and it opens to a blank worksheet, follow these steps to adjust your Excel settings:

  1. Open Excel

    • Launch Microsoft Excel on your computer.

  2. Access Excel Options

    • Click on File in the top menu.

    • Select Options from the dropdown menu to open the Excel Options window.

  3. Navigate to Trust Center

    • In the Excel Options window, select Trust Center from the left sidebar.

    • Click on the Trust Center Settings button to open the Trust Center.

  4. Adjust Protected View Settings

    • Within the Trust Center window, select Protected View from the left sidebar.

    • Uncheck all options under the Protected View section. This includes:

      • Enable Protected View for files originating from the Internet

      • Enable Protected View for files located in potentially unsafe locations

      • Enable Protected View for Outlook attachments

  5. Save Changes and Restart Excel

    • Click OK to save your changes and exit the Trust Center.

    • Close Excel completely and then reopen it.

  6. Open the Excel Document Again

    • Try opening the Excel report downloaded from PeopleSoft once more. It should now display the content correctly.

Conclusion

By following these steps, you should be able to view your PeopleSoft Excel reports without encountering a blank worksheet. Adjusting the Protected View settings in Excel allows these files to be displayed properly. If you continue to experience issues, please ensure that your Excel software is updated to the latest version or contact technical support for further assistance.

Contact Information

If you encounter any issues or need further assistance, please contact the Technical Service Desk by submitting a ticket at help.fscj.edu.