Forum Discussion
SKington
Feb 16, 2019Copper Contributor
Can I set up a workbook that multiple users update simultaneously without over typing each others?
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 ma...
Eva Vogel
Feb 17, 2019Iron Contributor
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