Creating an Open XML Protected Spreadsheet with Locked and Unlocked Cells

Today, in response to a question at, I put together a 7 minute screen-cast that shows how to create a protected spreadsheet with locked and unlocked cells.  Similar to the screen-cast that I presented in How to Research Open XML Markup, this screen-cast also is a good example of the approach that I take to research Open XML markup.

Explores the markup necessary to create a protected spreadsheet with locked and unlocked cells.



  1. Otaku said,

    April 15, 2011 @ 6:33 pm

    Eric, sorry for asking here as it is not related to this post, but I had a question on one of the posts from your previous blog. The one. Is there a place where I can ask about that?

  2. Eric White said,

    April 16, 2011 @ 4:48 am

    Hi Otaku,

    You can ask the question on that post directly. You can leave comments, and I can respond to them there. That will be best because it will keep the conversation with that specific content.


  3. Otaku said,

    April 17, 2011 @ 8:25 pm

    Turns out that comments are turned off there, so I can’t comment. I believe I figured out part of the problem however, which would be nice to share with you (re: DrawingML/PresentationML inheritance).

  4. Eric White said,

    April 18, 2011 @ 4:28 am

    You can certainly ask here, or email me directly at eric a t

  5. Bob Homes said,

    May 24, 2011 @ 6:31 pm

    Ah, so THAT’S how that works. Thanks for the post!

  6. Eric White said,

    May 25, 2011 @ 9:58 pm

    Glad you like it! -Eric

  7. Raj said,

    April 26, 2015 @ 4:59 pm


    Can someone please help me out in exporting chart, Html table and gridview data in Excel 2007 using OpenXML.

    Please treat this as urgent.



RSS feed for comments on this post · TrackBack URI

Leave a Comment