Home

Can I set up a workbook that multiple users update simultaneously without over typing each others?

%3CLINGO-SUB%20id%3D%22lingo-sub-352065%22%20slang%3D%22en-US%22%3ECan%20I%20set%20up%20a%20workbook%20that%20multiple%20users%20update%20simultaneously%20without%20over%20typing%20each%20others%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352065%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20a%20workbook%20that%20multiple%20people%20can%20use%20at%20the%20same%20time%20and%20update%20where%20every%20entry%20is%20saved%20to%20the%20next%20available%20row%20and%20no%20data%20is%20over%20typed.%26nbsp%3B%20I%20have%20seen%20this%20before%20and%20believe%20some%20macros%20may%20be%20involved%20but%20I%20have%20no%20idea%20how%20to%20go%20about%20it%20myself.%26nbsp%3B%20Any%20suggestions%20welcome.%26nbsp%3B%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-352065%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352220%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20set%20up%20a%20workbook%20that%20multiple%20users%20update%20simultaneously%20without%20over%20typing%20each%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352220%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20easiest%20way%20to%20do%20this%20is%20with%20Microsoft%20Forms%20in%20an%20Office%20365%20business%20environment.%20You%20set%20up%20the%20form%20to%20ask%20the%20questions%20as%20to%20what%20goes%20in%20each%20field.%20Multiple%20users%20can%20fill%20out%20the%20form%20simultaneously%20and%20it%20will%20populate%20your%20Excel%20file%20one%20record%20at%20a%20time%20and%20prevent%20any%20overlap.%20The%20users%20won't%20edit%20or%20open%20the%20file%20in%20Excel.%20Just%20you%20would%20to%20get%20the%20data%20out%2C%20or%20you%20could%20connect%20to%20it%20from%20another%20Excel%20or%20Power%20BI%20file%20via%20Power%20Query.%20Just%20point%20it%20to%20that%20table%20in%20that%20file.%20In%20that%20event%2C%20no%20one%20opens%20the%20file%20in%20Excel.%20It%20is%20just%20a%20database.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352124%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20set%20up%20a%20workbook%20that%20multiple%20users%20update%20simultaneously%20without%20over%20typing%20each%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352124%22%20slang%3D%22en-US%22%3EHello%20SKington!%20With%20local%20storage%20you%20can%20write%20a%20vba%20code%20to%20being%20free%20to%20be%20edited%20former%20entries%20and%20after%20that%20being%20locked%20and%20stored%20again.%20This%20seems%20to%20be%20edited%20by%20multiple%20accounts%20but%20in%20fact%20it%20works%20stepwise.%20A%20real%20teamwork%20and%20a%20good%20versioning%20history%20is%20created%20with%20OneDrive%20and%20excel%202016%2C%20best%20is%20with%20set%20up%20a%20Flow%20on%20ms%20flow%20within%20office%20365.%20That%20is%20real%20teamwork%20and%20you%20get%20control%20of%20every%20entry.%20But%20vba%20won%E2%80%99t%20work%20with%20OneDrive%20stored%20files.%20Greets%2C%20Eva%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-849165%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20set%20up%20a%20workbook%20that%20multiple%20users%20update%20simultaneously%20without%20over%20typing%20each%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-849165%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20go%20about%20doing%20this%20within%20sharepoint%20online%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F236847%22%20target%3D%22_blank%22%3E%40Ed%20Hansberry%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853424%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20set%20up%20a%20workbook%20that%20multiple%20users%20update%20simultaneously%20without%20over%20typing%20each%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F407362%22%20target%3D%22_blank%22%3E%40silina%3C%2FA%3E%26nbsp%3BUse%20the%20Forms%20app%20in%20your%20Office%20365%20subscription.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fforms.office.com%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
SKington
Occasional Visitor

I want a workbook that multiple people can use at the same time and update where every entry is saved to the next available row and no data is over typed.  I have seen this before and believe some macros may be involved but I have no idea how to go about it myself.  Any suggestions welcome.  Thanks

4 Replies
Hello SKington! With local storage you can write a vba code to being free to be edited former entries and after that being locked and stored again. This seems to be edited by multiple accounts but in fact it works stepwise. A real teamwork and a good versioning history is created with OneDrive and excel 2016, best is with set up a Flow on ms flow within office 365. That is real teamwork and you get control of every entry. But vba won’t work with OneDrive stored files. Greets, Eva

The easiest way to do this is with Microsoft Forms in an Office 365 business environment. You set up the form to ask the questions as to what goes in each field. Multiple users can fill out the form simultaneously and it will populate your Excel file one record at a time and prevent any overlap. The users won't edit or open the file in Excel. Just you would to get the data out, or you could connect to it from another Excel or Power BI file via Power Query. Just point it to that table in that file. In that event, no one opens the file in Excel. It is just a database.

How can I go about doing this within sharepoint online @Ed Hansberry 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies