How do I hide hide #REF! in Excel
 

I have a pivot table that summarize sales by manager.

I am using the "=GETPIVOTDATA" function to capture the data into a table.

The table lists the managers name in column A and the summary data from the
pivot table in column B

One of the managers has not had any sales so far this year, so they do not
show up in the pivot table. This causes the #REF! error in the table.
I would like for it to show "0" or just be blank instead of it showing #REF!.

Is there an easy way to hide this error?

Thanks

--
Perry K

How do I hide hide #REF! in Excel
 

There is an error function called IsRef. So something like this...

=if(isref(getpivotdata(...), 0, getpivotdata(...))

--
HTH...

Jim Thomlinson


"PerryK" wrote:

I have a pivot table that summarize sales by manager.

I am using the "=GETPIVOTDATA" function to capture the data into a table.

The table lists the managers name in column A and the summary data from the
pivot table in column B

One of the managers has not had any sales so far this year, so they do not
show up in the pivot table. This causes the #REF! error in the table.
I would like for it to show "0" or just be blank instead of it showing #REF!.

Is there an easy way to hide this error?

Thanks

--
Perry K

How do I hide hide #REF! in Excel
 

Jim,

thanks --That did it!
--
Perry K


"Jim Thomlinson" wrote:

There is an error function called IsRef. So something like this...

=if(isref(getpivotdata(...), 0, getpivotdata(...))

--
HTH...

Jim Thomlinson


"PerryK" wrote:

I have a pivot table that summarize sales by manager.

I am using the "=GETPIVOTDATA" function to capture the data into a table.

The table lists the managers name in column A and the summary data from the
pivot table in column B

One of the managers has not had any sales so far this year, so they do not
show up in the pivot table. This causes the #REF! error in the table.
I would like for it to show "0" or just be blank instead of it showing #REF!.

Is there an easy way to hide this error?

Thanks

--
Perry K

How do I hide hide #REF! in Excel
 

one way might be:

=IF(ISERROR(GETPIVOTDATA(...)),0,GETPIVOTDATA(...) )




On 27 Lut, 14:59, PerryK wrote:
I have a pivot table that summarize sales by manager.

I am using the "=GETPIVOTDATA" function to capture the data into a table.

The table lists the managers name in column A and the summary data from the
pivot table in column B

One of the managers has not had any sales so far this year, so they do not
show up in the pivot table. This causes the #REF! error in the table.
I would like for it to show "0" or just be blank instead of it showing #REF!.

Is there an easy way to hide this error?

Thanks

--
Perry K