Combobox linked cell and pivot table filter

Hi,


Currently I am using cell text to filter a pivot table which works fine. The cell is I1 and has a named range of "SiteNameFilterRange"

However, the users now tell me they dont want to have to type in the name as they are too long and would like some sort of Auto complete.

As such, I thought of a combobox and using the "SiteNameFilterRange" as the linked cell.

Unfortunately, this does not work!

Can anyone offer a solution for this?

Please find attached a demo worksheet.


Many thanks

http://www.datapigtechnologies.com/f...s/pivot10.html

The answer!