Hi
Take a look at the GetPivotData function.
You'll find help for this on Debra Dalgleish's site
http://www.contextures.com/xlPivot06.html

--
Regards

Roger Govier


"Rgmacdee" wrote in message
...
I create a pivot table and then add a couple of columns for formula
based
cells. Since upgrading to Excel 2003, the formulas do not copy with
relative
cell references as I have done in previous versions. Can anyone help
me on
this? Thanks
--
Rgmacdee