Home

Apply locked for editing

%3CLINGO-SUB%20id%3D%22lingo-sub-962856%22%20slang%3D%22en-US%22%3EApply%20locked%20for%20editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-962856%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWe%20currently%20use%20an%20excel%20spreadsheet%20which%20requires%20input%20by%20different%20users%20within%20the%20department.%20I%20know%20there%20is%20a%20facility%20you%20can%20activate%20which%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Edisplays%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3Ba%20pop%20up%20message%20box%20stating%20another%20user%20is%20currently%20'in'%20the%20spreadsheet%20and%20it%20can%20be%20accessed%20via%20a%20read-only%20action....but%2C%20I%20can't%20seem%20to%20find%20information%20on%20how%20to%20put%20it%20into%20action.%20I%20am%20probably%20typing%20in%20the%20wrong%20HELP%20question%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-962856%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E1%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-963108%22%20slang%3D%22en-US%22%3ERe%3A%20Apply%20locked%20for%20editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-963108%22%20slang%3D%22en-US%22%3EIf%20you%20are%20using%20Office%20365%20and%20the%20file%20is%20either%20in%20Sharepoint%20or%20in%20OneDrive%2C%20you%20won't%20see%20this%20message%20anymore%2C%20as%20multiple%20people%20can%20edit%20the%20same%20file%20at%20the%20same%20time.%20Is%20that%20not%20what%20you%20want%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-965204%22%20slang%3D%22en-US%22%3ERe%3A%20Apply%20locked%20for%20editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-965204%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20taking%20the%20time%20to%20reply%20Jan.%20I%20have%20since%20had%20further%20advice%2C%20and%20it%20would%20seem%20this%20pop-up%20message%20box%20is%20only%20applicable%20in%20a%20shared%20drive%20facility.%20As%20we%20access%20the%20majority%20of%20our%20files%20from%20Dropbox%20the%20Microsoft%20message%20cannot%20be%20displayed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%20x%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
martinarenkacouk
New Contributor

We currently use an excel spreadsheet which requires input by different users within the department. I know there is a facility you can activate which displays a pop up message box stating another user is currently 'in' the spreadsheet and it can be accessed via a read-only action....but, I can't seem to find information on how to put it into action. I am probably typing in the wrong HELP question?

2 Replies
Highlighted
If you are using Office 365 and the file is either in Sharepoint or in OneDrive, you won't see this message anymore, as multiple people can edit the same file at the same time. Is that not what you want?
Highlighted

@Jan Karel Pieterse 

 

Many thanks for taking the time to reply Jan. I have since had further advice, and it would seem this pop-up message box is only applicable in a shared drive facility. As we access the majority of our files from Dropbox the Microsoft message cannot be displayed.

 

Thanks again x

Related Conversations
Adding Comments on a Protected Worksheet
EWillis in Excel on
0 Replies
Team Owner - Can not see who is member of a team
Oskar Kuus in Microsoft Teams on
1 Replies
The Cost of a "Click"
Larry Glickman in Yammer on
4 Replies