I'm trying to make a Pivot Table more dynamic in Excel by filtering not on checked values from a list (as is the default method) but to filter on a value contained in a cell reference. Is this possible and if so, how?

The pivot table supplies data to a model somewhere else in my workbook, so being able to update a value and have the pivot table automatically refresh would be ideal.

## Best Answer

YES it's very much possible that you can use a Cell Reference to Filter records while using the Pivot Table.let me discuss one simple example. Suppose you have database in

Range A2 to D20. Contains Headers for exampleDate, City, Name & Sales. Now to work with Cell reference to filter, steps shown below should be followed.`E`

.`=and(D2<=1000,D2>=5000)`

, pressEnter.`Report Filter`

OR to`Slicer`

(if you have Excel 2010 or higher version).`True/False`

from the Filter.Refresh.You find Excel has included the New Field's effect and as per it shows the result.

NB:Remember in Place of TRUE you can use FALSE option also, you can use any possible method (Formula is better way) which can help Excel to Filter record.Hope this help you. In case my solution differs, just put a comment that where you need correction.Adjust cell references in the formula as needed.