Hyperlink pivot pagefield control

[Onetrack]

Does anyone have a working example of using a rollover hyperlink to set 2 pagefield controls?

I am trying to use the code below as a basis, but without success, posted by JS411

http://www.mrexcel.com/forum/excel-...ging-pivot-table-filters-data-validation.html

thank you.

 

[Andrew Poulsom]

Welcome to MrExcel.

What did you try? Maybe you can adapt the example here:

Interactive Dashboard in Excel using Hyperlinks | Chandoo.org - Learn Microsoft Excel Online

 

[Onetrack]

Hello Andrew, thank you for your reply. I have created an example file showing the problem

https://www.box.com/s/vzvapkts0k9f63unp38n

I hope you can access it. The hyperlink changes either C1 or C2, depending upon the location of the mouse. However, the pivot pagefields only ever get set to "ALL". So the worksheet change event is partially controlling the pivot, but not completely. Can you see the problem?

 

[Andrew Poulsom]

Try as I may I can't get it to work. The order of the pagefields is different from the order of your ranges, but it still won't work for me when I correct for that.

 

[Onetrack]

OK Andrew, thanks for trying. This could be really useful for controlling pivots if someone managed to get it to work!

 

[Onetrack]

I'm going to ask for help at VBA Express. I have tried another route https://www.box.com/s/dg0atnuidb4zjxsf9vgz, but without success.

Thanks again
Hyperlink pivot pagefield control - not working - VBA Express Forum