Skip to Content

How to disable EPM Dynamic Formatting Via Macro Automatically

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

untitled.png (47.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 08, 2017 at 03:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 09, 2017 at 07:16 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded