Excel File is blank after exported from AMS system

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s