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...
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
- Did you separate the access database into a front end and a backend set of databases or did you have everything in a single file?
- Everything was in the Same File