Microsoft Office Tutorials and References
In Depth Information
reference the cells in the PivotTable directly, you risk needing to update formulas as the source
data is updated. It would be much better if you find a way to ix the PivotTable so that it cannot
dynamically change its size.
Luckily, an option in Excel helps you convert the dynamic PivotTable in a set of static formulas
that show the same data but without the dynamic nature of the PivotTable. You lose the
ability to navigate your data, but you gain the immobility of cells.
On the Options tab, a button named OLAP Tools contains a number of features, one of which
is Convert To Formulas, as you can see in Figure 8-21.
FIguRE 8-21 The Convert To Formulas option.
If you choose this option, the PivotTable is deleted and returns to being a standard Excel
worksheet that contains a formula for each of the original cells, as you can see in Figure 8-22.
FIguRE 8-22 The worksheet that contains PivotTable, after Convert To Formulas has been applied.