Well, thanks to Debra really, but many thanks for the feedback
--
Regards
Roger Govier
"news.microsoft.com" <pinickitty[ at ]hotmail.com> wrote in message
news:usc1fbApGHA.2452[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text] > Many thanks Roger it worked a treat > > Nick > "Roger Govier" <roger[ at ]technologyNOSPAM4u.co.uk> wrote in message > news:OcLfk7RoGHA.1208[ at ]TK2MSFTNGP04.phx.gbl... >> Hi >> >> Take a look at Debra Dalgleish's site for information on the >> GetPivotData function >> http://www.contextures.com/xlPivot06.html>> >> -- >> Regards >> >> Roger Govier >> >> >> "news.microsoft.com" <pinickitty[ at ]hotmail.com> wrote in message >> news:OL9qq5NoGHA.4616[ at ]TK2MSFTNGP05.phx.gbl... >> > 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 >> > >> > >> >> > >
|