Question Re: How to disable EPM Dynamic Formatting Via Macro Automatically in Financial Management Q&A

How to disable EPM Dynamic Formatting Via Macro Automatically

slnkpsl — Tue, 08 Aug 2017 11:16:06 GMT

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

Re: How to disable EPM Dynamic Formatting Via Macro Automatically

former_member186338 — Tue, 08 Aug 2017 15:12:18 GMT

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

For each sh in ThisWorkbook.Worksheets

epm.SetSheetOption sh, 109, False

"109" - Apply Dynamic Formatting

Re: How to disable EPM Dynamic Formatting Via Macro Automatically

gunesbt — Tue, 08 Aug 2017 19:15:13 GMT

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?

Re: How to disable EPM Dynamic Formatting Via Macro Automatically

former_member186338 — Wed, 09 Aug 2017 07:16:13 GMT

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.

Re: How to disable EPM Dynamic Formatting Via Macro Automatically

former_member186338 — Wed, 09 Aug 2017 18:58:09 GMT

Please close the question accepting the correct answer.