rubthebuddha
New Member
- Joined
- Nov 18, 2009
- Messages
- 32
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
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