Preserving Excel Formulas in Ad Hoc Operations

You can associate Excel formulas and comments with members and data cells in ad hoc grids and set cell styles to identify such cells. By default, formulas are preserved when you perform ad hoc operations with the exception of Pivot.

To specify whether to preserve formulas and comments in ad hoc operations:

1. From the Smart View ribbon, in the General section, click Options.

2. Select the Member tab, then scroll down to Comments and Formula, and then do one of the following:

   • To preserve formulas and comments in ad hoc grids, select the Preserve Formulas and Comments in Ad Hoc check box.

   • To disable preservation of formulas and comments, clear the Preserve Formulas and Comments in Ad Hoc check box. Do this only if you do not need to preserve formulas and comments, and you want faster execution of queries.

   • To preserve comments and unknown members in ad hoc grids, select the Preserve Formulas and Comments in Ad Hoc and Preserve Comments and Unknown Members check boxes. The Preserve Formulas and Comments in Ad Hoc check box must be selected first to enable the Preserve Comments and Unknown Members check box

   • To disable preservation of comments and unknown members, clear Preserve Comments and Unknown Members. Do this only if you do not need to preserve comments and unknown members, and you want faster execution of queries.

   The selection you make applies to formulas in both member and data cells.