+ Reply to Thread
Results 1 to 2 of 2

Missing Pivot Data

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    26

    Question Missing Pivot Data

    Hi,

    I was wondering if anyone know's of a way that you can avoid getting a #REF! error when there is no data in a pivot.

    For example I have a table that references a pivot. Some days when I refresh the data-set there will be matching figures against all of the dates.

    Is there any way that I can show nothing if there is no data.

    I tried this but there are too many arguments.

    =ISERROR(GETPIVOTDATA("# of Bookings",'V OUT PY'!$A$5,"Entry Date",$C70,"Bucket 60 Min",$BL$2),"")

    Thanks,
    Paul

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Missing Pivot Data

    Shouldn't that be IFERROR rather than ISERROR
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Compare two columns on separate sheet, if missing, insert missing data
    By lilvictorians in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-03-2019, 11:44 PM
  2. Occasional pivot data missing
    By JNEWMAN in forum Excel General
    Replies: 2
    Last Post: 11-05-2015, 12:58 PM
  3. [SOLVED] creating a pivot table, missing data
    By JEA_123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2015, 06:55 AM
  4. Missing Cell Data in Pivot
    By o4008 in forum Excel General
    Replies: 2
    Last Post: 10-18-2011, 11:09 AM
  5. [SOLVED] Excel 2007 (BETA) Missing data when doing pivot table
    By ademoore in forum Excel General
    Replies: 1
    Last Post: 07-08-2006, 07:10 AM
  6. Pivot Tables - Missing Data after refresh
    By Gr8Day in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-07-2006, 10:00 AM
  7. pivot table - two colums of data are missing
    By JJ in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1