Colum widths in IBP Excel Planning Views

[Former Member]

Hi,

while creating custom Excel Planning Views for our IBP S&OP based on the provided standard SAP Excel Templates, I noticed the following problem:

The chart in the top half of the screen can only perfectly align with the corresponding data underneath, when the column widht of each column in the area undernath the chart is identical. However, this is not the case in our planning view. When I manually adjust the column widhts, the change gets overwritten whenever I refresh the data.

Is there any way to manually fixate the column widhts, so the chart will always be aligned with the data?

Regards

Holger

[Alecsandra · Accepted solution]

Hi Emilia,

You can try and un-check Autofit from Advanced -> Sheet Options -> Formatting -> Auto fit column width. EPM autofit applies only to the columns that belong to the planning sheet.

Regards

Alecsandra

[Former Member · Accepted solution]

Exactly what I was looking for. Thanks Alecsandra!