1
Here's what I want to do. I have a Pivot Table that contains data from more segments. Let's name them A, B, C and D. I want to have an hyperlink that will open my pivot table directly showing just the data of segment A or B or C... Is this possible? If I want the hyperlink to a sheet with the selection on a specific cell it's easy... I do something like file.xls#sheet!cell but now I want to link it to the file and the sheet where the pivot table is and also to show just some data from that pivot (by default it shows all the data combined for A, B, C and D).
I don't think you can without VBA – momobo – 2011-09-17T19:25:36.210