EPMFormatting Disabled.

[Former Member]

Hi Experts,

how can i disabled the EPMFormatting? i wanted to format my reports manually, especially the color of data fields.

i disabled the formatting into sheet options and edit reports.

please see the attachment.

Thanks and Best Regards,

Marlon

[Shrikant_Jadhav]

Hi Marlon,

You did it correctly ...That's only way ...

Whats the issue now ?

Shrikant

[former_member186338]

The topic author thinks we are able to see his reports

[Former Member]

i want to apply the formatting manually, not by using copyrange, but every time i change my current view, the data fields are clearing all the format i used.

[Shrikant_Jadhav]

Hi Marlon,

As suggested by Vadim, Use static report approach - then manual formatting will work

OR there is workaround ... (may SP issue ...)

You can try this ...

Go to Options -> Refresh - > check "Keep Formulas Static that references Report Cells".

Shrikant

[former_member186338]

"Keep Formulas Static that references Report Cells" - will work if data range rectangle width and height will not change. And with this restriction it's better to use static report...

Vadim

[Shrikant_Jadhav]

Hi Vadim,

Completely agree ...

And it has other impact on template but fortunately or unfortunately it's working...

Shrikant