Has "Download a Snapshot" functionality been removed from "Office Online Server"?

Question

Hello, we recently migrated our on premises farm from Sharepoint 2013 to Sharepoint 2019. With Sharepoint 2013 we used "Office Web Apps" and the user of our farm were used to work on some excel files that had one or more active connections with SSAS. We used to gave the user "View Only" permissions on those files in Sharepoint, so the users could not download the file but still could download a Snapshot, like shown below.

In the recently migrated farm to Sharepoint 2019 we are using "Office Online Server" and everything works as intended but the button to Download a Snapshot is nowhere to be seen.

Has the functionality been removed from Office Online Server? Is still possible somehow to Download a Snapshot of an excel file from "Office Online Server"? In case the functionality is not available anymore, is there any workaround to download a Snapshot of an excel document with active connections to an external data provider? Thank you very much

Answer 1

Hi George.

I have the same problem. Did you get to solve this issue?

Regards.

Answer 2

I found a solution that works for me. When the user access the URL containing parameter workbookType with value "FullWorkbook", the page is redirected to other page with other parameter workbookType with value "FullSnaphot". Then, the download of the report is made as "Download a Snapshot". Follow the steps to do this:

In IIS settings, after install URL Rewrite (https://www.iis.net/downloads/microsoft/url-rewrite), open it.

1. Add Rule(s)...
   1. Put a name.
2. In Match URL:
   1. Maches the Pattern
   2. Using Regular Expressions
      1. Set Pattern: (.*)
      2. Check Ignore Case
3. In Conditions:
   1. Add two conditions:
      1. First:
         1. Input: {QUERY_STRING}
         2. Type: Matches the Pattern
         3. Pattern: ^(.)FullWorkBook(.*)$
      2. Second:
         1. Input: {QUERY_STRING}
         2. Type: Does Not Matches the Pattern
         3. Pattern: ^(.)Ignore(.*)$
4. In Action:
   1. Action Type: Redirect
   2. Action Properties: {R:0}?{QUERY_STRING}&Ignore=true&workbookType=FullSnapshot
   3. Uncheck Append query string
   4. Redirect type: Permanent (301)

Save the rule and test.

• After that, the old button "FullWorkBook" isn't work now.
• Always the download will be as a snapshot.