View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Get Pivot Function

Hi Mark

There are differences in the way in which GetPivotData works in XL2002
upward compared with earlier versions.
Take a look at Debra Dalgleish's site for more info.

http://www.contextures.com/xlPivot06.html


--
Regards

Roger Govier


"Mark" wrote in message
...
Hi,
I wonder if somebody could help please?
I use Excel 2003 in which I use the =GetPivot Function. Colleagues of
mine
who use my data have Excel 2000. All is fine until they change a
Pivot
Field, at which time they lose all calculations. Does Excel 2000 have
the
=GetPivot Function?
--
Thanks, Mark