How to update a pivot table, without refreshinh the whole thing?

G

Guest

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
 
T

Tom Ogilvy

no.

Regards,
Tom Ogilvy

Brian said:
Hi all,

I have a pivot table which holds about 100.000 rows, extracted from a
Click to expand...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to build / refresh pivot table without ODBC?? 1
OO4O and Pivot Table 3
Query then pivot table 6
Pivot table drill down sort 0
refresh multiple pivot tables in workbook 2
Help list box to update pivot table 1
Passing Criteria to a Pivot Table from combo boxes 3
How to modify the sql statement on a pivot table using VBA- XL2000 1

Top