G
Guest
Want to create formulas outside of a pivot table yet still reference the data
within the pivot table. I can manually write the cell name such as
=E7+E9....but want to create the formula by clicking in the cell without
automatically getting the getpivottable funtion. Is it possible to disable
this function? I use the get pivot table function quite frequently and
successfuly but in this instance don't want it.
within the pivot table. I can manually write the cell name such as
=E7+E9....but want to create the formula by clicking in the cell without
automatically getting the getpivottable funtion. Is it possible to disable
this function? I use the get pivot table function quite frequently and
successfuly but in this instance don't want it.