empty worksheet cell causes GETPIVOTDATA() error

Question

Question on a Worksheet that references a Pivot table in the same workbook (in a separate tab).

The Worksheet is used as a log in which the user enters numbers as the days go on.  Some cells at the bottom of this Worksheet (I'll call them Progress cells) reference the Pivot table.  The numbers in these Progress cells change as the days go on.  

The Progress cells use the GETPIVOTDATA() to reference the Pivot table.  (I have entered this function by entering = in a Progess cell, then going to the target cell in the Pivot table, clicking in it,

and pressing Enter.)

This all has been working wonderfully well.  The problem occurs when the user opens a new Timesheet workbook in which there are no entries yet (And in which the Pivot table is already set up).  Now the Progress cells show the #REF! error.  

Is there any way to block the Progress cells from displaying the error until the user starts entering data in the Worksheet?

Many thanks for any help at all,

-Lynne

Answer 1

How about something like this:

=IFERROR(GETPIVOTDATA("Your Stuff Here"),"")

That will leave the cell blank if there is nothing in the pivot table yet.

HTH,

Eric