Share via

Pivot Table "Reference is not valid" Error

Anonymous
2014-05-01T15:09:16+00:00

I am a fairly experienced pivot table user and create complicated models with many pivot tables.  When I "Refresh All", I occasionally get a "Reference is not valid" error (see screenshot below).  I can track this problem down by refreshing each pivot table individually, but this is a time consuming waste of effort when the workbook contains many (50+) pivot tables.  Is there an easier way to find and correct the error? 

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2014-05-02T23:25:56+00:00

    Hi,

    I don't think there is.  I even used the Inquire feature of Excel 2013 but not even that showed any external links.

    2 people found this answer helpful.
    0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2014-05-02T00:07:48+00:00

    Hi,

    Is the base data for the Pivot Table being fetched from some other Program?

    0 comments
  2. Anonymous
    2014-05-02T02:24:34+00:00

    No, the workbook contains numerous pivot tables drawing simply from data from several different ranges/tables in the same workbook.  Calculated fields are used in some of the tables, but these all seem to be working correctly at this point.  I attempted to check all pivot tables individually, but could not locate the error.  I may have missed a few of the pivot tables, though.  There are many.  Any other ideas?  Thanks.

    0 comments
  3. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2014-05-02T02:27:34+00:00

    Hi,

    Upload the workbook to OneDrive and share the link of the workbook here.

    0 comments
  4. Anonymous
    2014-05-02T02:37:22+00:00

    Thanks.  I uploaded the file to the following link.  It's 9.8 MB.

    https://onedrive.live.com/?ppud=4#cid=510F02E64CF4576D&id=510F02E64CF4576D%21124

    0 comments