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
|