Start a new topic

EPM Add-In: How to retain formatting when expanding a report and not using dynamic formatting

Symptom:

When not using dynamic formatting, the Excel formatting is lost when the report is refreshed.How to retain formatting when expanding a report.


Resolution:

To retain formatting when expanding, do the following:

In Excel, with the EPM tab selected, click Options | Sheet Options.

SheetOptions.png



Click the General tab.  For the Totals Placement option, select the radio buttons for Top and Left and click OK.


TotalsPlacement.png

 
Login or Signup to post a comment