Sharepoint Edit Warning

Question

Hello.

I have a user who benefited from an old warning in Sharepoint/Excel.

Before, when a user would open a file that was already being edited, they would receive a warning stating that the document was locked for editing. They no longer receive this warning, or any indication that the file has been opened previously. When they go to save it, they are alerted that a newer file exists on the server and they must work with the other user to see which changes have been made.

How can I configure Sharepoint and/or Excel so that there is a clear indication of who has a file open?

Answer 1

That is all for now, thank you.

The users who have the share the document prefer the way it worked before, but I showed them this method and they are evaluating whether they will continue to use it.

Thanks.

Answer 2

Hi Michael,

From version 1707 (Build 8326.2058) of Excel, Excel 2016 supports for co-authoring.

What's the version number of your Excel 2016? Please go to Excel > File > Account to capture a screenshot about the Product Information.

If this is not your scenario, please follow the steps below if you want to library to require someone to check the file out first before changing it.

1. Go to Settings > Library Settings.

2) In the Settings page, click Versioning Settings.

3. In the Versioning Settings page, scroll down and click Yes for Require documents to be checked out before they can be edited. 

Regards,

William

Answer 3

I spoke to the user again, and he reworded the problem.

When using Onedrive for Business, he used to receive an alert that a file was locked for editing. Now it allows both users to edit the same file, only warning when the second person

He can't pinpoint when, but it stopped giving him that alert.

Answer 4

Hi Michael,

In OneDrive for Business, Excel documents are support for  co-authoring.

You know you're co-authoring with one other person if you see a message in the upper-right corner says they are editing

If your user share documents with other and don't want to other jump into, please let him check out the file first. If him can't find the check out button, please click Return to classic OneDrive and try it again.

Regards,

William

Answer 5

Hi Michael,

Please let us know if you have any question.

Regards,

William