disable get pivot table function

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.
 
T

tom

I have the same problem. It worked great in earlier Excel version but now
2003 has this anoying GETPIVOTTABLE function. Did you ever find a way to
disable this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top