• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sharing Workbook Allowing Simultaneous Editing

Hi everyone,

I have created a file that I would like to share on Sharepoint 2007. I have selected the Share Workbook option within the excel file, but every time I try and have multiple users open the file, the excel file opens as Read-Only ("This workbook was opened from a server in read-only mode.")

If I choose Edit Workbook, excel displays a message saying the file is locked for editing by another user.

Does anyone know of a way to accomplish this? The following article is discouraging, but I have to believe this can be done.

Thanks!
 
Good day Jeffrey

I have used SharePoint and I may be wrong but I think you have to allow permissions for share in SharePoint its self!
 
Does anyone know how this can be accomplished?

When I use "Save and Send" in Excel and save a shared workbook to Sharepoint, I get the following error message:

Code:
Unable to Load Workbook
 
The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:
 
Workbook sharing
 
Contact the workbook author.
 
Good day Jeffery

I think that you do not save as a shared workbook, all shares and permissions are done in SharePoint its self
 
Back
Top