Forum Discussion
How Do I Stop Pivot Tables from Sharing the Same Cache?
Hello all, I want to create multiple pivot tables/graphs on the same sheet (in both Excel service and the desktop). As I am sure you all know, when you create a second pivot table and change the ...
If data source is in the same file you may add data to data model and create PivotTables based on it. Instead of cached PivotTable.
If external data source, refresh doesn't work in Excel for web, at least so far. Functionality is expected by the end of this year, but who knows.