Issue: When user opened the Excel files which exported from AMS system, no information displayed.
blank_excel

If user checked the box for Unblock
Report_unblock

Click Yes
Yes_excel
User will able to see the information exported from AMS system.

Solution:

  1. open Excel program
  2. Click on File, Options, Trust Center
  3. Click on Trust Center Settings… button
  4. Click on Protected View (left pane)
  5. uncheck Enable Protected View for files originating from the internet and Enable Protected View for files located in potentially unsafe locations
    TrustCenter
  6. Click ok
  7. Open the exported excel file. It will display information without prompt or error message.
Advertisements