Forum Discussion
athalekar
May 23, 2022Copper Contributor
Pivot table missing sheet errors
I have prepared dashboard using a data source. While doing so i prepared few pivot tables from different data sheets where appropriate data was store. Now due to continuous improvement of the dashboa...
- May 24, 2022Please go to Data>Queries and Connections and check there are no connections to external files that are no longer needed. Additionally, ensure there are no hidden sheets containing pivot tables which are still pointing at the deleted data source.
It would help if you could upload the file or perhaps add some screenshots to show more context.
athalekar
May 24, 2022Copper Contributor
flexyourdata This doesn't work. I have analyzed all my data sources from which I prepared either pivot charts or pivot tables. When I refresh all, it still shows error of a sheet which I deleted long back.
flexyourdata
May 24, 2022Iron Contributor
Please go to Data>Queries and Connections and check there are no connections to external files that are no longer needed. Additionally, ensure there are no hidden sheets containing pivot tables which are still pointing at the deleted data source.
It would help if you could upload the file or perhaps add some screenshots to show more context.
It would help if you could upload the file or perhaps add some screenshots to show more context.
- athalekarMay 24, 2022Copper Contributor
flexyourdata Nice. this pointer helped me to track the cached data sheet which i had deleted. I deleted the data connection and XLS is now showing no errors !
Thanks for the pointer !