Internal Hyperlinks in Pivot Tables a 2017 Thread

[prometeusz]

Hi

I know it is possible to do: see the first file attached. 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 - see "zero test 2" file.

The vba code involved is as follows:

Please Login or Register  to view this content.

What difference makes it impossible in zero test 2 file to achieve the same result? It is not because the source and the pivot table are separate. I would hope to complete the task by Christmas, but anything later than that will still be great because the file will be developed on a continuous basis.

Many thanks
T

[davesexcel]

You have an if error line, so you would not be able to see what the error would be,

Please Login or Register  to view this content.

This line fails because, the sheet does not exist.