Excel One Drive File Sharing

%3CLINGO-SUB%20id%3D%22lingo-sub-2810839%22%20slang%3D%22en-US%22%3EExcel%20One%20Drive%20File%20Sharing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2810839%22%20slang%3D%22en-US%22%3E%3CP%3EI%20share%20a%20file%20on%20my%20one-drive%20with%205%20other%20users.%26nbsp%3B%20Previously%2C%20these%20users%20had%20edit%20access.%26nbsp%3B%20I%20am%20the%20account%20owner.%26nbsp%3B%20After%20the%20most%20recent%20excel%20update%2C%20users%20are%20now%20able%20to%20customize%20their%20viewing%20options.%26nbsp%3B%20It%20allowed%20them%20to%20see%20only%20their%20edits%2C%20or%20everyone's%20edits%20(which%20mainly%20they%20were%20using%20to%20filter%20only).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20kept%20occurring%2C%20where...%20If%20I%20went%20in%20and%20made%20an%20edit%2C%20and%20another%20user%20had%20the%20file%20open%2C%20and%20it%20was%20on%20a%20custom%20view%20option%20for%20their%20own%20edits%2C%20they%20would%20not%20be%20able%20to%20see%20the%20edit%20I%20made.%26nbsp%3B%20Even%20worse%2C%20if%20they%20closed%20out%20of%20the%20report%2C%20after%20me%2C%20their%20old%20data%2C%20was%20saving%20over%20the%20new%20data%20I%20had%20entered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20removed%20access%20to%20the%20other%205%20users.%26nbsp%3B%20Re-shared%20the%20file%20with%20view%20access%20only.%26nbsp%3B%20Now%2C%20unfortunately%2C%20they%20cannot%20view%20any%20edits%20that%20I%20made%20to%20the%20document%20after%20the%20initial%20link%20was%20sent.%26nbsp%3B%20They%20are%20unable%20to%20see%20any%20edits%2C%20let%20alone%20edits%20in%20real-time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2810839%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I share a file on my one-drive with 5 other users.  Previously, these users had edit access.  I am the account owner.  After the most recent excel update, users are now able to customize their viewing options.  It allowed them to see only their edits, or everyone's edits (which mainly they were using to filter only).  

 

The problem kept occurring, where... If I went in and made an edit, and another user had the file open, and it was on a custom view option for their own edits, they would not be able to see the edit I made.  Even worse, if they closed out of the report, after me, their old data, was saving over the new data I had entered.

 

I removed access to the other 5 users.  Re-shared the file with view access only.  Now, unfortunately, they cannot view any edits that I made to the document after the initial link was sent.  They are unable to see any edits, let alone edits in real-time.

 

How can I fix this?

0 Replies