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?