I have a multi-tab Excel sheet where I use several tables, pivot tables with single data source and 4 pivot tables that use three data sources and these three are the only sources that show under the Active tab on the field list. Under the All tab on the field list there is a table listed that I no longer use and have deleted from the workbook. When I do a Refresh All I get this attached error. This table/data source has been deleted. How do I get rid of this error?
