View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ellis Horowitz Ellis Horowitz is offline
external usenet poster
 
Posts: 4
Default Getting protected cell error message when calculating (F9)

Hi All,

I am running into a strange problem and I was hoping that I could
impose upon your collective brain power to solve it (just a bit of
flattery to loosen you all up).

I have a workbook with several protected worksheets. Within each of
the prtotected worksheets, most (but not all) of the cells are locked.
When I press F9 to calculate, I get an error message "The cell or
chart you are trying to change is protected and therefore read only."
I am a bit confused by this: Should the protection inhibit updating
the display value of a cell by the calculation process, or is the
inhibition only limited to manual changes by the users?

I have tried to prototype this down to a simple case with a formula on
a protected worksheet and changing component values on an unprotected
worksheet, but it worked without any problems. I also added a chart
and circular references to the prototype, but I was still unable to
recreate the problem. Yet it persists on the more complex
spreadsheet.

Has anyone seen this before? Any help would be greatly appreciated.

Thanks,

Ellis