Hi Francois
Take a look at Debra Dalgleish's site for more help on this
http://www.contextures.com/xlPivot06.html
--
Regards
Roger Govier
"Francois" wrote in message
...
This is very irritating when entering formulas that reference pivotted
data
in Excel. Can one turn this off?