Created By  inflectra.adam Tuesday, July 26, 2016
The symptom is that whenever a user tries to open an Excel format report in SpiraTest, SpiraPlan or SpiraTeam, the report will download. When the user clicks on it to open, Excel opens but the area where the report should be is blank and gray. It affects all reports types in Excel format. Other formats (HTML, XML, etc.) work fine.

The Solution

The solution is to disable the Protected View setting within Excel. To do this, please do the following:

  1. Open MS Excel 
  2. Go to File > Options 
  3. Click Trust Center (from the menu on the left) 
  4. Click the 'Trust Center Settings' button 
  5. Click Protected View (from the menu on the left) 
  6. Remove the check mark next to "Enable Protected View for files originating from the internet" 
  7. Click OK 
  8. Click OK

Now you will be able to open Excel reports from Spira.

Article Info
  • Last Updated: 7/26/2016
  • Article ID: KB212
  • Views: 9453