Solved

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

Posted on 2012-03-26
2
373 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
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
Advanced tutorial on how to run the esxtop command to capture a batch file in csv format in order to export the file and use it for performance analysis. He demonstrates how to download the file using a vSphere web client (or vSphere client) and exp…

823 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