Hi,
I have two sheets . In one sheet("Data Pivots") pivot tables are there. In the another sheet("Dashboard") are there.
I need to hyperlink the dashboard data so that if anyone click on dashboard data he will go to the correct Pivot table related data and can double click and extract the data.
I linked through GetPivotdata to show the data from pivot table.
I made hyperlink and connect to pivot table data .
But the problem is hyperlink to pivot table data is fixed and if cell reference changes then Getpivotdata changes correctly , however hyperlink to pivot table showing incorrect and cell references not changing.
Please Help! and Thanks in Advance !
Bookmarks