You can associate Excel formulas with member cells in ad hoc grids and set a cell style (see Cell Styles) to identify such cells.
By default, formulas are preserved when you perform ad hoc operations, except for Pivot. To achieve faster execution of queries, you can disable the preservation of formulas and comments. However, if you select this option, formulas are overwritten when you perform ad hoc operations.
To specify preservation of formulas in ad hoc grids:
From the Smart View ribbon, click Options, and then Member Options in the left panel.
To preserve formulas in ad hoc grids, select Preserve Formulas and Comments on Ad hoc operations (except pivot).
To disable preservation of formulas, clear Preserve Formulas and Comments on Ad hoc operations (except pivot). Do this only if you do not need to preserve formulas and you want faster execution of queries.