Herbert

Sorry for the extended delay in a reply -- thanks for this excellent
solution! I was running into problems using a reference for the data field
in my getpivotdata formula and using the TEXT function took care of it.
--
Scott S


"Herbert Seidenberg" wrote:

Excel 2007
For Data Field in GetPivotData() Use TEXT(MyRef,"@")
Other text operations like LEFT(MyRef,5) work too.
Other arguments in GetPivotData() don't have that problem.
See my formulas in Table4 he
http://www.mediafire.com/file/zb3nmywgtjz/01_23_09.xlsm