Skip to Content
author's profile photo Former Member
Former Member

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2005 at 09:38 PM


    to my knowledge,

    Users are required to enter only keys for characteristics & that the texts are automatically derived from characteristic master data key.

    so, texts are not ready for input for the reason, you get this error.

    there are ways of unprotecting sheet using password "SAP" (defauly password), <B> BUT, IT'S HIGHLY RECOMMENDED NOT TO USE THIS </B>.

    moreover, user entered texts are automatically gets overwritten from the master data.

    workaround for you would be,

    if you don't want the text, remove it from the layout.

    if you still want the text, tell your users that text field need (should) not be entered.

    hope it helps.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.