Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a .xlsx file on a network drive and using the Share Workbook feature without any problem.

But when I try to use this feature with a file stored on SharePoint, it doesn't work. When [User A] opens the document, [User B] can only open it with Read-Only.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

I'd consider that a blessing. Sharing Excel workbooks only leads to trouble, because it's a question of when not if the shared file becomes corrupt and unusable.

If you require simultaneous multi-user write access to a data set, Excel is never the best solution. Consider a database like SQL or Access. You have SharePoint, so you already have SQL. Make the best of it and create an Excel user interface to read/write the data into a SQL database.

Simultaneous file editing is currently supported for Word and PowerPoint and is on the cards for Excel Web Apps, but not yet a reality. Watch Office 2013 and the respective web apps. While still on 2010, stick to the tried and trusted. Avoid shared workbooks.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.