megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
Our budget has many pivot tables. When I click Refresh All, I get an error saying "We couldn't get the data from 'Table8' in the workbook 'M:\2019 Budget.xlsm'.
Table8 doesn't exist (per Name Manager), as you may have guessed. The thing is that there also ISN'T a Pivot Table that references Table8! I'm certain of it. I've run a macro to show all Pivots in the workbook - nothing that references a Table8. I've even gone one by one through all the Pivots, individually refreshed every single one and clicked "Change Data Source" - no errors, none reference Table8. Where is this phantom Pivot Table?? It's driving me batty.![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Table8 doesn't exist (per Name Manager), as you may have guessed. The thing is that there also ISN'T a Pivot Table that references Table8! I'm certain of it. I've run a macro to show all Pivots in the workbook - nothing that references a Table8. I've even gone one by one through all the Pivots, individually refreshed every single one and clicked "Change Data Source" - no errors, none reference Table8. Where is this phantom Pivot Table?? It's driving me batty.