I have an Excel document that is used by two users. Each inputs different data to the same document (two open instances of the same document).
Can I update the data via VBA if I press a button? So the two open instances of the document are synced.
This file is stored on a SharedPoint server.
You can set an Excel workbook to be shared without needing any VBA or other tools.
- Go to the
- In the
Allow changes by more than one user at the same time. This also allows workbook merging. Choose any
Advancedoptions that apply to your situation.
- Upon clicking
Okyou should be prompted to save the document. Other users can now make amendments simultaneously, and any conflict issues will prompt the user for action.
More information on this can be found here.
Note that if you are using SharePoint, you can use the web app to collaborate also.