Skip to Content
Former Member
Sep 28, 2005 at 04:14 PM

Protected Cells in BPS Excel Planning Layout


Hi all,

we are experiencing a strange phenomenon. A user tries to paste rows into a planning layout and get the error message "The cell or chart you are trying to change is write-protected. Please remove the sheet protection." (approximate error message as translated from German).

The characteristics in the layout are displayed with key and text. Writing into the key cell works, however, pasting over the text fields does not work.

Is it possible to remove the sheet protection (requires unknown password) or is it possible to find a work-around for this problem?

We are using SEM 3.2 with Excel 2003 in a Citrix environment. On my local Installation with Excel 97 (yes it still exists;) the problem does not occur. Unfortunately using Excel 97 on the Citrix Server is not an option due to other restrictions.

Does anyone have an idea?