Disable automatic GETPIVOT

  • Thread starter news.microsoft.com
  • Start date
N

news.microsoft.com

Whenever I reference to a field in a pivot table I get the
"GETPIVOTDATA....." worksheet function. This would normally be OK but
this is an Absolute reference and I can't figure out how to get it to
make it a relative reference.

The only way I can do it is by taking out the formula and manually
entering the cell reference - ie "A1". Is there any way the GETPIVOT
function can be turned off??


Thanks

Nick
 

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