Link Pivot-Table Filter to Another Cell (Excel 2010)

[acfbobcat]

Hi,

I have an excel model that contains several pivot tables across several worksheets. On the first worksheet of my workbook (called "Summary"), I have a drop down list where the user can select a Text value from several choices. The pivot tables that I've developed in the other worksheets use this same field as a filter and originate from the same data source. I've attemped to simply link all the pivot table filters to this one cell using ='Summary View'!A4

This produces an error that reads: "Cannot Enter a Formula for an item or field name in a PivotTable report"

I believe this can be accomplished through VBA but I don't know anything about using VBA or how it works. Does anyone have a layman's terms solution to drop in VBA code somewhere that can accomplish this?

Thanks in advance,

-Acfbobcat

 

[Jerry Sullivan]

Hi acfbobcat,

Try using Slicers for this. Slicers were added with the release of Excel 2010, and they make syncing PivotTables that share the same data source very simple.

This can also be done with VBA, however; I'd suggest you experiment with Slicers first and only go the VBA route if that doesn't do what you want.