Hello Everyone
I am trying to find the data source for a pivot table. And when I click on "change data source" tab, it directs me to a single cell. And I can make new pivot table by using that single cell ("a1") as data source.
Can anyone explain to me how this works?
PS: there is no Macro inside, no hidden worksheets
Thanks a million
![]()
Bookmarks