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.
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.
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.