SOLVED
Home

Excel book located in Sharepoint open as "read only" by default

%3CLINGO-SUB%20id%3D%22lingo-sub-290684%22%20slang%3D%22en-US%22%3EExcel%20book%20located%20in%20Sharepoint%20open%20as%20%22read%20only%22%20by%20default%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290684%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EIs%20it%20possible%20to%20desactivate%20the%20default%20%22read%20only%22%20protection%20when%20we%20open%20an%20Excel%20book%20located%20in%20Sharepoint%3F%3CBR%20%2F%3EThe%20users%20have%20to%20click%20%22Edit%20Workbook%22%20to%20save%20the%20document%20with%20the%20same%20name%20and%20we%20pretend%20to%20avoid%20this%20step.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F60592i601D8FEDF139EA99%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222018-11-23_17-20-58.jpg%22%20title%3D%222018-11-23_17-20-58.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrederico%20Borges%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-290684%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291217%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20book%20located%20in%20Sharepoint%20open%20as%20%22read%20only%22%20by%20default%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291217%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20deploys%20new%20functionality%20gradually%2C%20version%201707%20only%20means%20that%20functionality%20was%20first%20introduced%20with%20this%20build%2C%20after%20that%20it's%20deployed%20step%20by%20step%20by%20channels%20and%20by%20tenants.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Efor%20example%2C%20Collaborative%20editing%20functionality%20on%20semi-annual%20channel%20(targeted)%20was%20started%20deploying%20from%20September%20this%20year%20from%20build%201808.10730.20102%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fsemi-annual-channel-targeted-2018%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fsemi-annual-channel-targeted-2018%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20on%20semi-annual%20channel%2C%20thus%20it'll%20be%20even%20later%2C%20at%20least%20I%20didn't%20find%20it%20for%20your%20channel%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fsemi-annual-channel-2018%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fsemi-annual-channel-2018%3C%2FA%3E%2C%20you%20may%20check%20yourselves.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnyway%2C%20you%20may%20check%2C%20if%20you%20have%20co-authoring%20(aka%20collaborative%20editing)%20you%20shall%20have%20no%20such%20alert.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291206%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20book%20located%20in%20Sharepoint%20open%20as%20%22read%20only%22%20by%20default%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291206%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20again%20Sergei%2C%3C%2FP%3E%3CP%3EI%20was%20wrong%20about%20the%20version...%20We%20have%20already%201803.%3C%2FP%3E%3CP%3EIs%20it%20possible%20that%20have%20been%20changes%20after%20version%201707%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F60675i4DFAE4488423D11D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222018-11-26_16-54-08.jpg%22%20title%3D%222018-11-26_16-54-08.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291196%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20book%20located%20in%20Sharepoint%20open%20as%20%22read%20only%22%20by%20default%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291196%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20welcome.%20Hope%20you'll%20update%20soon.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291193%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20book%20located%20in%20Sharepoint%20open%20as%20%22read%20only%22%20by%20default%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291193%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%3C%2FP%3E%3CP%3EI've%20realised%20that%20we%20are%20still%20working%20with%20version%2016.0.9%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-290777%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20book%20located%20in%20Sharepoint%20open%20as%20%22read%20only%22%20by%20default%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290777%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20the%20introduction%20of%20co-authoring%20mode%20that%20disappeared%2C%20please%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fblogs.technet.microsoft.com%2Foffice_integration__sharepoint%2F2015%2F11%2F12%2Fexcel-2016-opens-sharepoint-workbooks-as-read-only%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.technet.microsoft.com%2Foffice_integration__sharepoint%2F2015%2F11%2F12%2Fexcel-2016-opens-sharepoint-workbooks-as-read-only%2F%3C%2FA%3E%2C%20thus%20for%20today%20that's%20version%20issue.%3C%2FP%3E%0A%3CP%3EAlso%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftcsp360.com%2Fblog%2Fissues-and-solutions%2Fms-excel-2016-opens-workbooks-read%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftcsp360.com%2Fblog%2Fissues-and-solutions%2Fms-excel-2016-opens-workbooks-read%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10205019-read-only-mode%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10205019-read-only-mode%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
FBorges
New Contributor

Hi,
Is it possible to desactivate the default "read only" protection when we open an Excel book located in Sharepoint?
The users have to click "Edit Workbook" to save the document with the same name and we pretend to avoid this step.

 

2018-11-23_17-20-58.jpg

 

Regards,

 

Frederico Borges

 

5 Replies

Hi Sergei,

Thanks for your reply.

I've realised that we are still working with version 16.0.9

Thank you for your help.

Regards

You are welcome. Hope you'll update soon.

Hi again Sergei,

I was wrong about the version... We have already 1803.

Is it possible that have been changes after version 1707?

 

2018-11-26_16-54-08.jpg

 

 

Microsoft deploys new functionality gradually, version 1707 only means that functionality was first introduced with this build, after that it's deployed step by step by channels and by tenants.

 

for example, Collaborative editing functionality on semi-annual channel (targeted) was started deploying from September this year from build 1808.10730.20102 https://docs.microsoft.com/en-us/officeupdates/semi-annual-channel-targeted-2018

 

You are on semi-annual channel, thus it'll be even later, at least I didn't find it for your channel https://docs.microsoft.com/en-us/officeupdates/semi-annual-channel-2018, you may check yourselves.

 

Anyway, you may check, if you have co-authoring (aka collaborative editing) you shall have no such alert.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies