Solved

Multiple users to an Excel Spreadsheet File

Posted on 2015-01-16
3
91 Views
Last Modified: 2015-02-15
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.
0
Comment
Question by:mbelletty
3 Comments
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 167 total points
ID: 40553677
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
 
LVL 41

Accepted Solution

by:
pcelba earned 167 total points
ID: 40553711
"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
 
LVL 69

Assisted Solution

by:Qlemo
Qlemo earned 166 total points
ID: 40553883
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

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question