How to change MS Excell format template SAPBEXinputData

[Former Member]

Hi,

we sue BI IP BEX analyser and would like to change the template of the planqueryes (the one with the blue background). Problem we have with this template is that it is not very clear which lines are ready for input and which are not (only difference is a blue border, both lines are white). I'm not an excell expert, does anyone knows how one can ensure all not plannable lines have a different color for example.

regards

D

[Former Member · Accepted solution]

For example:

click on the Input cell, then go to Format - Style,

click on Modify button.

go to pattern choose the colour (e.g: green).

It will apply the green colour for your input entry.

If you want the back ground display in different colour. you can do the same steps as above.

You must set this setting as workbook for user; otherwise when you run from query, it will back to default.

/Jamie

[Former Member · Accepted solution]

Hi Jamie,

it seems to work. What do you mean with

You must set this setting as workbook for user; otherwise when you run from query, it will back to default.

thnx

D

[Former Member]

I means, after you applied the changes (changing the input colour), save your query as a workbook.