Link pivot table filter to Cell without VBA?

[rubthebuddha]

Can one link a pivot table filter to a specific cell's value and not use VBA? I can do it in VBA without problem, but I'm using an Excel-based dashboard creator (Xcelsius) and VBA not an option.

I have thousands of rows of data to summarize. A pivot would be by far fastest for fresh filters/calculations (SUMPRODUCT and such would be far too slow). I'm out of ideas, because I can't think of what kind of event would prompt the pivot to refresh without a programmatic (disabled in Xcesius) or manual refresh of the pivot after changing the filter (inaccessible to end user).

Thanks in advance for any brilliance shared.

david