Adobe Report Builder scheduled Reports opening in Excel in protected view | Community
Skip to main content
D
drawrk
Level 2
January 4, 2023
Solved

Adobe Report Builder scheduled Reports opening in Excel in protected view

  • January 4, 2023
  • 1 reply
  • 1360 views

 When I send a scheduled excel workbook generated by Report Builder, the excel file opens in protected view . It displays all the data from report builder requests whilst still in "protected view" however it it does not execute the excel formula using this data until I click on "Enable Editing".  Is there a way to get the output of the excel formula displayed when a user opens the file in protected view without asking them to click on "Enable Editing" ? is there a setting in report builder I have missed that does this?  I want to avoid asking the recipients of the reports to  change their Trust Center settings in excel to switch off protected view.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by FarazHusain

Hey, @drawrk, Protected View is a read-only mode where most editing functions are disabled. This can be due to the following reasons :

- The file was opened from an Internet location.
- The file was received as an Outlook attachment, and your computer policy has defined the sender as unsafe.

And there are several other reasons as well which are mentioned here - Link.

There is no setting in the report builder for this; rather I believe this is due to your internal network policy, which is causing the report to be opened in a Protected view. 

 

1 reply

FarazHusain
Adobe Employee
FarazHusainAdobe EmployeeAccepted solution
Adobe Employee
January 4, 2023

Hey, @drawrk, Protected View is a read-only mode where most editing functions are disabled. This can be due to the following reasons :

- The file was opened from an Internet location.
- The file was received as an Outlook attachment, and your computer policy has defined the sender as unsafe.

And there are several other reasons as well which are mentioned here - Link.

There is no setting in the report builder for this; rather I believe this is due to your internal network policy, which is causing the report to be opened in a Protected view. 

 

    D
    drawrkAuthor
    Level 2
    January 5, 2023

    Without changing the organisation's internal network policy, is there anything I can do to get the Excel formula to populate the cells so they are not blank when a user who receives the report initially opens it without clicking on "Enable Editing". That is the issue I am trying to get around.

    FarazHusain
    Adobe Employee
    FarazHusainAdobe Employee
    Adobe Employee
    January 5, 2023

    Hey, @drawrk I'm uncertain that would work; I believe you have to use Enable Editing to populate cells.

    Terms & ConditionsAccessibility statement

    Loading footer...