Home / server / Questions / 927457
In Process
Mikael Dyreborg Hansen
Asked: 2018-08-23 00:21:29 +0800 CST

Open Excel files in read-only mode if already open by another user in write mode

  • 772

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?

windows-server-2012

0 Answers