A
Ajay Bisht
I am using the GetPivotData function in one of the sheet,
which is having the pivot table. This file contains the
parameter used in 2002. I tried modify it according to
2000 required format, getting expected result but once i
close my workbook and open it again giving me GPF
"memory could not be read"
Following are the two syntax, one used earlier in 2002 and
another one modifed by me and using in 2000(giving GPF).
2002 Syntax -
= GETPIVOTDATA("Days",$B$21,"Dev
Assigned",H13,"Phase","Coding")
2000 Syntax
=GETPIVOTDATA($B$21,"Dev Assigned " & H13 & " Phase
Coding")
I am using 2000 syntax, giving me expected result but once
i am reopening it then giving me GPF
Regards
Ajay
which is having the pivot table. This file contains the
parameter used in 2002. I tried modify it according to
2000 required format, getting expected result but once i
close my workbook and open it again giving me GPF
"memory could not be read"
Following are the two syntax, one used earlier in 2002 and
another one modifed by me and using in 2000(giving GPF).
2002 Syntax -
= GETPIVOTDATA("Days",$B$21,"Dev
Assigned",H13,"Phase","Coding")
2000 Syntax
=GETPIVOTDATA($B$21,"Dev Assigned " & H13 & " Phase
Coding")
I am using 2000 syntax, giving me expected result but once
i am reopening it then giving me GPF
Regards
Ajay