Solved

Best practices for opening a single document on sharepoint by multiple people

Posted on 2012-03-26
2
376 Views
Last Modified: 2012-04-25
I have a shared document (excel) on our sharepoint portal.  I have this excel web access part on several pages ans want the ability to have people edit it simultaneously.

Is this even possible? Or can only one person check out or edit the file at a time?  Is there any other suggestion that you can think of to allow access to a file from different people at the same time or is that simply not possible?
0
Comment
Question by:jhuntin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 19

Expert Comment

by:Montoya
ID: 37767666
The only solution I can think of is to simply enable version control. However, if they are hitting that file at exactly the same time, and that is precisely what needs to happen, then even version control will not keep that from happening. All you can do is track changes from one doc to another, but the real way of safeguarding the integrity of a file is to lock it (which is why 'checking out a document' exists.

Is this for financial purposes? Meaning, is Excel the best medium for this? When multi-user access is required, I usually have to start thinking mySQL or similar solution, so transactional data and differences are 'built-in'.
0
 
LVL 6

Accepted Solution

by:
martusha earned 500 total points
ID: 37770861
multiple users can edit word documents in sharepoint 2010 with office word 2010.
Excel documents does not support this feature... If one is editing - other can only read (read-only mode) or save file as copy.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

632 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