getpivotdata error
 

In Excel 2002 - I am using the following formula;
=GETPIVOTDATA(SUMMARY!I7,"Jane Brown"); however, if her name is not showing
up in the pivot table that day I am getting a #REF! error. How can I
change/formulate that to be 0 or blank?

getpivotdata error
 

I figured it out - i just need to needed to show items with no data in the
pivot table.

"dchristo" wrote:

In Excel 2002 - I am using the following formula;
=GETPIVOTDATA(SUMMARY!I7,"Jane Brown"); however, if her name is not showing
up in the pivot table that day I am getting a #REF! error. How can I
change/formulate that to be 0 or blank?

getpivotdata error
 

Another option is to use ISERROR in the formula, e.g.:

=IF(ISERROR(GETPIVOTDATA(SUMMARY!I7,"Jane Brown")),"",
GETPIVOTDATA(SUMMARY!I7,"Jane Brown"))


dchristo wrote:
I figured it out - i just need to needed to show items with no data in the
pivot table.

"dchristo" wrote:


In Excel 2002 - I am using the following formula;
=GETPIVOTDATA(SUMMARY!I7,"Jane Brown"); however, if her name is not showing
up in the pivot table that day I am getting a #REF! error. How can I
change/formulate that to be 0 or blank?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html