We opened this workbook read-only from the server "Edit Workbook" "File In Use"

%3CLINGO-SUB%20id%3D%22lingo-sub-1625421%22%20slang%3D%22en-US%22%3EWe%20opened%20this%20workbook%20read-only%20from%20the%20server%20%22Edit%20Workbook%22%20%22File%20In%20Use%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625421%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStarted%20to%20bang%20our%20heads%20together%20over%20the%20last%20couple%20of%20months%2C%20with%20multiple%20tickets%20logged%20to%20Microsoft%20Support%20regarding%20an%20issue%20a%20client%20of%20ours%20is%20having.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScenario%3C%2FP%3E%3CP%3E-%20Using%20SharePoint%20online%20only%20as%20file%20libraries%3C%2FP%3E%3CP%3E-%20Sync%20function%20is%20turned%20off%20(so%20files%20cannot%20be%20downloaded%20locally)%3C%2FP%3E%3CP%3E-%20Files%20are%20opened%20in%20local%20MS%20Office%20applications%20as%20default%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIssue%3C%2FP%3E%3CP%3EA%20large%20number%20of%20users%20have%20a%20template%20saved%20in%20the%20SharePoint%20library%20which%20they%20then%20edit%20%2B%20save%20(as%20auto%20save%20function%20has%20been%20disabled)%20The%20users%20in%20question%20have%20their%20own%20templates%20which%20are%20not%20shared%20or%20user%20by%20any%20other%20user%20in%20the%20company.%20However%2C%20on%20any%20day%20they%20can%20safely%20click%20on%20the%20file%20and%20open%20it%20without%20any%20problems%2C%20give%20or%20take%20a%20few%20hours%20later%20or%20days%20later%20the%20same%20template%20is%20opened%20by%20the%20same%20user%20and%20the%20following%20error%20is%20given%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%22%3CFONT%3EWe%20opened%20this%20workbook%20read-only%20from%20the%20server%22%20%22Edit%20Workbook%22%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EWhen%20Edit%20workbook%20is%20clicked%20you%20then%20receive%20the%20following%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%22This%20file%20is%20locked%20for%20editing%20by%20*end%20user*%22%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E(see%20screen%20shot)%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Untitled.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215837i648D2AB1C83CF9A1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Untitled.png%22%20alt%3D%22Untitled.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EHas%20anyone%20been%20able%20to%20find%20out%20what%20is%20causing%20this%20issue%3F%20Any%20feedback%20would%20be%20greatly%20appreciated.%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1625421%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi all, 

 

Started to bang our heads together over the last couple of months, with multiple tickets logged to Microsoft Support regarding an issue a client of ours is having. 

 

Scenario

- Using SharePoint online only as file libraries

- Sync function is turned off (so files cannot be downloaded locally)

- Files are opened in local MS Office applications as default

 

Issue

A large number of users have a template saved in the SharePoint library which they then edit + save (as auto save function has been disabled) The users in question have their own templates which are not shared or user by any other user in the company. However, on any day they can safely click on the file and open it without any problems, give or take a few hours later or days later the same template is opened by the same user and the following error is given;

"We opened this workbook read-only from the server" "Edit Workbook"

When Edit workbook is clicked you then receive the following

"This file is locked for editing by *end user*"

(see screen shot)Untitled.png

Has anyone been able to find out what is causing this issue? Any feedback would be greatly appreciated. 

0 Replies