This project has moved. For the latest updates, please go here.

How to Share a spreadsheet?

Oct 28, 2012 at 11:09 PM

Excel 2010 features a cool little thing where you can share an excel workbook on a network location, so that several users can edit it simultaneously.

I believe sharing also protects the document with a password. I read that OpenXML didn't support protected files, so I'm thinking this may not be possible with ClosedXML either...

Is it possible to trigger this feature using ClosedXML?

Thanks!

Coordinator
Oct 29, 2012 at 12:39 AM

How do you do this in Excel?

Oct 29, 2012 at 12:37 PM
  1. Load a workbook
  2. Click the "Review" ribbon
  3. In the "Changes" section, click "Protect and Share Workbook"
  4. Click "Enable Track Change to Share the workbook"
  5. Set a password (optional)
  6. Click OK: It will save the workbook and enable "Shared".

At this point, any number of users can open and edit the excel file simultaneously.

Oct 30, 2012 at 11:06 AM

You might want to follow this discussion: http://social.msdn.microsoft.com/Forums/en-US/oxmlsdk/thread/2a88c835-4788-494a-97da-a2e0c6aa985b/

Nov 1, 2012 at 1:18 PM

Someone figured it out on my question on StackExchange. I didn't try it yet!

http://stackoverflow.com/questions/13101693/how-can-i-enable-the-sharing-options-on-excel-workbooks/13173839#13173839 

Jun 4, 2013 at 1:58 PM
The above link tells how to share a workbook using OpenXML.

Is this feature available with ClosedXML. If yes, can any one share the sample code.