Forum Discussion
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 s...
If you place the sheet on SharePoint or in OneDrive and all your users are on Office 365 this should not be a problem.
JKPietersethe sheet is saved on a file server. in the office we use MS Office Pro Plus 2016. We do not use Office 365
- In 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
- I actually moved from Access to Excel because Access Just keept Getting wierd Errors and lost its Data from time to time. Access realy dosnt want to work
