The Essbase Options dialog box contains controls that determine the behavior of worksheets, spreadsheet styles, and actions in your Essbase session. It includes these tabs:
To save the option settings in a worksheet, you must explicitly go to the Essbase Options dialog box and set the options before saving the worksheet. Otherwise, when you open the same worksheet in another Spreadsheet Add-in session, the options settings for the current session override previous worksheet settings. Ensure that the worksheet for which you saved option settings is not a protected worksheet. Essbase cannot save option settings for a protected worksheet.