Find solution
How can I use XMP in Sharepoint metadata?

Can multiple users use the same excel spreadsheet at the same time in Sharepoint?

  • I am trying to set up a excel worksheet that can be used by multiple users. Is it possible to set up an excel worksheet (that is not a shared workbook, just a shared workspace) that multiple people can edit at the same time on a sharepoint server? (I can't use a shared workbook because I need to use VBA code.) When multiple people try to use the same workspace right now, only the first person can write back. How do I fix it so that multiple people can write at the same time? Note: Due to work restrictions, we have completely removed the messenger service from all of our computers.

  • Answer:

    You can not modify one file from several users, forget it. Instead, you can tell any one to create one file, and from the main file, you can call the changes those serveral users did. Either using Data > Consolidate or You can do it using functions. contact me for more info Read my profile, I am XLMan

Dont A at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

This is the same situation in my Dept. We share a drive and save things on it. Sometimes we create an excel template, that when you click on it twice it opens a copy that you can work on, modify, and save... without ruining the template... which will stay there If you are saving a worksheet, i dont believe two people can use the same one cuz one will be able to open it, the other will be on read only mode, and thus cannot modify or change anything in it!

SAM

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.