Sheet Options
The sheet options apply to the current worksheet.
Note The two following options apply to all the
worksheets in the workbook:
Refresh Data in the Whole
File when Opening it and
Clear Data on the Whole
File when Saving it.
To apply all the options to any new sheet added to the workbook, click the Save as Default button.
The sheet options apply by default to any report on
the sheet.
Note The report options are accessible in the
Options tab
of the
Report
Editor.
The sheet options persist for the sheet when the workbook is saved.
If you copy a worksheet, then the sheet options will also be copied to the new sheet.
To access the
Sheet Options
dialog box, select
EPM 
Options Sheet Options 
.
EPM Options Sheet Options .
Note All the sheet options are stored in the
<DefaultSheetOptions> section of the EPMClientPreference.xml file located
in \Users\[ID]\AppData\Local\EPMOfficeClient. You can change the default values
of any option directly in the file.