Hi
I know it is possible to do: see the "test 2" (https://www.dropbox.com/s/ljfmphkp4uxu3is/test2.xlsm?dl=0) file. As you click on the pivot table cells, you get directed to the relevant tabs.
Have tried to achieve this in my file, but for some reason, the same trick does not appear to work -...