Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to create a template in Word to be used on a SharePoint site. Using Word 2003, is there a way to enable protection on a document that has an Excel Spreadsheet (97-2003) object on it but allow the spreadsheet object to be edited?

When I add the object as an exception, Word behaves as if the object were a picture. I understand why, but in un-protected mode, when the user double clicks on the object, it becomes a full blown, editable spreadsheet again.

Is it possible to allow the same functionality in protected mode?

share|improve this question

migrated from May 1 '11 at 10:33

This question came from our site for professional and enthusiast programmers.

up vote 0 down vote accepted

I have run some tests and confirmed that you can add the Excel object as an exception and have it work the way you want it to.

Ensure that when you paste the cells into the Word document, you select one of the options that "...Links to Excel". After you've completed that, protect the document and add the entire table as an exception that everyone can edit.

share|improve this answer

I have an easier way:

Insert a continuous break before and after the inserted table.

Then, in Restrict Editing, part 2, Editing Restrictions; select Filling in Forms. Once the Select sections link is visible; click it and deselect the section that contains your table.

share|improve this answer

Your Answer


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.