I am building a dashboard in Excel 2013 by connecting to cells in a large number of pivot tables. Normally all I have to do is put =
in a cell and then click on a cell in the pivot table and it will automatically create the formula:
=GETPIVOTDATA("Max Baseline",'Template Pivots'!$K$4,"Category","Apples","Measure","Combined").
But today I when I started working Excel now treats the pivot tables like they are range values. Instead of GETPIVOTDATA
it produces ='Template Pivots'!P5
.
Has anyone had this happen to them before? Did I accidentally disable the automatic GETPIVOTDATA
function? I started building the table in Excel 2010 but upgraded to Excel 2013, could that have thrown things off?
There are two places to change the setting (which is global).
Options
menu.Options->Formulas