Multiple users to an Excel Spreadsheet File

I am wondering if there is a way for multiple users on a local area network can read and edit the same Excel Spreadsheet that is saved on one of the computers and shared to others.

i know this has never been able to be done previously, but thought there maybe a way now of allowing this somehow.

if anyone has any experience with this I would really appreciate your feedback.
mbellettyAsked:
Who is Participating?
 
pcelbaConnect With a Mentor Commented:
"i know this has never been able to be done previously" ... No, this feature is in Excel for years already.

But be aware of the massive sharing. Newer operating systems are trying to optimize the file access by implementing Oplocks and SMB2 technologies which in turn can cause shared file damage. Switching SMB2 off is highly recommended to users of shared FoxPro databases (DBF files). Shared MS Access database has similar problems.

Excel workbooks is safer to share on the Sharepoint server.

You may read more on Oplocks and SMB here: http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html
0
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
You can share the workbook - see Review - Changes - Share Workbook.

there are some things to bear in mind - see https://support.office.com/en-nz/article/Use-a-shared-workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61 for more information.
0
 
QlemoConnect With a Mentor DeveloperCommented:
Sharing an Excel file is prone to data loss and file corruption, and not recommended at all - that is something you will get told by many of the Experts here.
I've used it, with only two other people looking into the same file occassionally, and had regular corruption, data duplication, missing changes, ...
If possible, I would refrain from doing so. If someone needs to look into an already opened workbook, let them do write-protected.
0
All Courses

From novice to tech pro — start learning today.