How to disable EPM Dynamic Formatting Via Macro Automatically

[slnkpsl]

Hi Everyone,

Is there a way to disable EPM Dynamic formatting via excel macro? (not just only for one sheet , for whole workbook) I have attached the screenshot below.

untitled.png

[former_member186338 · Accepted solution]

In VBA iterate all worksheets in workbook and for each set:

For each sh in ThisWorkbook.Worksheets

epm.SetSheetOption sh, 109, False

Next

"109" - Apply Dynamic Formatting

[gunesbt · Accepted solution]

Hi Vadim,

Is there a way to do this per report in the same sheet where the corresponding report does not inherit sheet options. Consider edit report then consider "inherit sheet options" is not clicked.How do I apply the same method to such a report?

[former_member186338 · Accepted solution]

Please close the question accepting the correct answer.

[former_member186338]

There is no VBA API to change individual report options.

For each report you may insert EPM formula like:

= EPMReportOptions("XXX","ApplyDynamicFormatting=false")

where XXX - report ID.