1

I've been all over Google for the past days and I simply can't find a solution to this that would work in this setup.

The setup: Windows Server 2012 R2 (RDS), Office 2016, file server is 2012R2.

The problem:

  • User1 opens an Excel file either from the fileserver or from Microsoft SharePoint online in write mode.
  • User2 opens the same Excel sheet - also in write mode and is not prompted that it is already being edited by another user.
  • User1 saves changes and exits
  • User2 saves changes and exits, hence changes by User1 is lost.

I have a vague memory that it was possible, centrally and NOT per sheet, to setup a notification that the sheet is already opened in write mode by another user. Any ideas on this?

JonathanDavidArndt
  • 1,424
  • 3
  • 20
  • 29
Mikael Dyreborg Hansen
  • 559
  • 1
  • 5
  • 16
  • This usually happens automatically. Typically, you don't need to do anything extra to get the "already opened by another user" message, if the workbook is on a network fileshare. Do you have this problem on both a network fileshare and SharePoint? Or just one or the other? – JonathanDavidArndt Aug 23 '18 at 03:39
  • Thanks for the reply Jonathan, and I am aware that this is default behaviour, hence I'm confused as to why it doesn't behave this way any longer. It is the same whether it's opened on sharepoint or network share/mapped drive. – Mikael Dyreborg Hansen Aug 30 '18 at 06:43

0 Answers0