Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to make-Data Can't be Chagd-cell look disabled/protected IP BExAnalyzer

Hi All,

We have an IP application that need to be built in BEx Analyzer as a workbook.

In the input ready query there are certain rows and columns / certain cells that are configured for 'Data Cannot be Changed' in the 'Planning' tab properties.

The query when executed in web, it does show the cells greyed out and disabled so that the user is immediately aware that he should not and cannot enter data in those cells.

The same thing when executed in BEx analyzer does not give the same feature. How to achieve the same thing or similar thing in BEx Analyzer application for cells that are configured for 'Data cannot be changed'?

In workbooks for IP queries, I see a different color border and also the data does not stay when written in the 'Data cnnot be changed' cells and saved. But is there a better way to do this and we have to use BEx workbooks only and we cannot go to web due to some policies of the company.

Thanks in advance,

- Shashi

Former Member
Not what you were looking for? View more on this topic or Ask a question