IBP Excel Add in Editable Key Figure greyed out

[Mariia_L]

Hello!

Normally if Key figure is non-editable it will be greyed out in excel planning view, but if it is editable, color of cells will be white. But now I see that for editable Key figures color of cells is grey.

Although if KF is all editable, it's white, but if it is editable in current of future period, it is grey.

I have administrator rights, so it is for sure not question of permissions.

Also after setting check on the Default Format for Editable Cells in the IBP formatting sheets, it is getting white, but I expect it to be whit by default.

Maybe there is something what I should check in order get cells white for editable cells by default?

On the screenshot KF Approve country DP Short is editable and I can change values there, but color of cells is grey.

[Andrei_Lupu · Accepted solution]

The formatting of the Key Figure in IBP Excel is solely managed in the IBP Formatting Sheet.

If your previous setting for "Default Format for Editable Cells" was set to grey, then they will be displayed as grey. You just need to make sure that the setting is correct and the "Apply" tickbox is selected.  

[Mariia_L · Accepted solution]

Thank you