tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
To find the data source for a PV, I click into the PV, go to the ribbon and click Analyse, then Change Data Source.
That reveals the data source.
However what I see on this occasion is simply Table1.
I go to the Formulas tab and choose Name Manager but can't see Table1.
FYI the data can be found here:
Click on the downloads tab, unzip the file and the Excel workbook I am referring to is Chapter 3's Slicers.
Also, right clicking on the PV and choosing Refresh displays an error message:
Thanks
That reveals the data source.
However what I see on this occasion is simply Table1.
I go to the Formulas tab and choose Name Manager but can't see Table1.
FYI the data can be found here:
Code:
https://www.dummies.com/store/product/Excel-Power-Pivot-Power-Query-For-Dummies.productCd-111921064X,navId-322474,descCd-DOWNLOAD.html
Click on the downloads tab, unzip the file and the Excel workbook I am referring to is Chapter 3's Slicers.
Also, right clicking on the PV and choosing Refresh displays an error message:
Code:
Reference isn't valid
Thanks