Pivot Table "Reference is not valid" Error

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? 


Answer
Answer

Hi,

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

Regards,

Ashish Mathur
www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated February 29, 2024 Views 7,245 Applies to: