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 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 stackoverflow.com May 1 '11 at 10:33

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

1 Answer 1

up vote 0 down vote accepted
+50

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

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.