Forum Discussion
alfi04
Oct 18, 2021Copper Contributor
Using a Excel spreadsheet on multiple PCs at the same time
I designed a spreadsheet where phone calls are being logged. now i want that multiple users can edit the file at the same time. the file uses macros and they should also work on multiple PCs at the same time.
When the file is open on one pc the next pc displays an error and says that no changes can be saved
7 Replies
Sort By
- JKPieterseSilver ContributorIf you place the sheet on SharePoint or in OneDrive and all your users are on Office 365 this should not be a problem.
- alfi04Copper Contributor
JKPietersethe sheet is saved on a file server. in the office we use MS Office Pro Plus 2016. We do not use Office 365
- JKPieterseSilver ContributorIn that case I suggest not to use Excel at all. Only Excel 365 is reliably capable of having multiple users edit the same file, provided you store the workbook in SharePoint or OneDrive. Perhaps a small MSAccess application would work? This should be fairly easy to set up