[deprecated]Excel summary as values
The advanced options window allows the user to select whether the summary is created using values or formulas. Selecting ‘values’ can reduce the time taken to initially create the summary, and also reduces the time that Excel takes to recalculate the data if it is changed. For a dynamic summary that changes to reflect the user’s input, this option should be left as default.
Click on the options menu and select ‘Advanced options’ to get started.