Allowing read-only users to download a document and edit the local copy (via IRM)

%3CLINGO-SUB%20id%3D%22lingo-sub-1749075%22%20slang%3D%22en-US%22%3EAllowing%20read-only%20users%20to%20download%20a%20document%20and%20edit%20the%20local%20copy%20(via%20IRM)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1749075%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20share%20a%20certain%20excel%20database%20with%20users%20on%20our%20sharepoint%20platform.%3CBR%20%2F%3EI%20have%20created%20a%20document%20library%20and%20applied%20the%20following%20IRM%20policy%20on%20it%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Krisch_0-1601988072791.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224397iADA9E2B343282817%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Krisch_0-1601988072791.png%22%20alt%3D%22Krisch_0-1601988072791.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20users%20should%20not%20be%20able%20to%20edit%20this%20file%20on%20the%20sharepoint%20directory.%3CBR%20%2F%3ETherefor%20they%20have%20been%20granted%20only%20Read%20permissions.%3CBR%20%2F%3EBut%20they%20should%20be%20able%20to%20edit%20the%20file%20once%20it's%20downloaded%20(offline%20copy).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I'm%20testing%20this%20out%20a%20user%2C%20I%20always%20receive%20this%20error%20upon%20opening%20it%20on%20my%20local%20excel%20app%20(reading%20in%20the%20web%20view%20is%20no%20problem)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Krisch_1-1601988233786.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224398i60DA05D9580AC73C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Krisch_1-1601988233786.png%22%20alt%3D%22Krisch_1-1601988233786.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20Office%20account%20is%20the%20same%20on%20both%20the%20sharepoint%20environment%20and%20my%20Excel%20installation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20should%20I%20change%20in%20my%20configuration%20to%20achieve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1749075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I want to share a certain excel database with users on our sharepoint platform.
I have created a document library and applied the following IRM policy on it: 

Krisch_0-1601988072791.png

The users should not be able to edit this file on the sharepoint directory.
Therefor they have been granted only Read permissions.
But they should be able to edit the file once it's downloaded (offline copy).

 

However, when I'm testing this out a user, I always receive this error upon opening it on my local excel app (reading in the web view is no problem):

Krisch_1-1601988233786.png

 

My Office account is the same on both the sharepoint environment and my Excel installation.

 

What should I change in my configuration to achieve this?

 

Kind regards

0 Replies