Observe these rules when retrieving data into a formatted worksheet:
Rule 1—The worksheet cannot contain numeric cells before the first Essbase data cell. These cells cannot contain formulas that resolve to numeric values.
For example, if the first Essbase data cell is B6, no cell in rows 1 through 5 nor in cell A6 can contain numeric values, nor can these cells contain formulas that resolve to numeric values.
Rule 2—A cell that lies within a row or column of Essbase data cannot contain text or numeric values. These cells can contain formulas, however, if the Formula Preservation options in the Essbase Options dialog box are selected.
Rule 3—Pivot is not available when the Formula Preservation options in the Essbase Options dialog box are selected.
Rule 4—Use of the Pivot command removes all cells that contain text information other than database member names.