Why are graphs locked in shared document, but users can still enter new data?

Question

In my Excel spreadsheet, I can enter new data, but I cannot insert a new graph or edit old graphs. In fact, I cannot "insert" anything. I am still able to enter text though. Why is this happening? I recently "shared" this workbook. Does this have anything to do with it? Is there a setting you have to change?

Answer 1

Does this happen with one file or all the Excel files?

Check the links below and see if it helps.

http://office.microsoft.com/en-us/excel-help/unlock-specific-areas-of-a-protected-worksheet-HA010342979.aspx

http://social.technet.microsoft.com/Forums/en-US/excel/thread/e4955199-430e-45a1-a95d-20f6a4c1f5f4/