Copying Formats into Multiple Worksheets

When creating multiple worksheets with the Cascade command, you can copy the formatting of the source worksheet (that is, styles you set using the Style page of the Essbase Options dialog box), without having to manually apply the formatting to each worksheet.

To copy the format of the source worksheet to multiple worksheets:

Select Essbase, and then Cascade.
From Essbase Cascade Options, select Format Options.
Under Sheet to Sheet Replication, select Copy Formatting.
Copy Formatting does not copy formulas, column formatting, worksheet formatting, or graphs. It does copy styles you set using Essbase and cell formatting you set using the worksheet.