Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to update a pivot table, without refreshinh the whole thing?
Hi all
I have a pivot table which holds about 100.000 rows, extracted from a database via query. How do I refresh this pivot table, without having to extract all the rows from database again and again? The thing is, that I want it to be cummulative, and therefore only need new data - can this be done /Brian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to update a pivot table, without refreshinh the whole thing?
no.
Regards, Tom Ogilvy "Brian" wrote in message ... Hi all, I have a pivot table which holds about 100.000 rows, extracted from a database via query. How do I refresh this pivot table, without having to extract all the rows from database again and again? The thing is, that I want it to be cummulative, and therefore only need new data - can this be done? /Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Update | Excel Discussion (Misc queries) | |||
Pivot Table update | Excel Discussion (Misc queries) | |||
Pivot Table Update | Excel Discussion (Misc queries) | |||
Pivot Table Data did not update | Excel Worksheet Functions | |||
Pivot Table update | Excel Discussion (Misc queries) |