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. Anonymous
    2014-05-03T14:08:03+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.

    Thanks for checking.  This seems like an issue that Microsoft may want to correct in future versions of Excel.

    0 comments