Increasing data to PivotTables without re-doing them

A

Adele-NZ/UK

I have a large data set which has been placed into a series of pivot tables.
However, I am currently adding to that data set and wanting to expand the
pivot tables to encompass this data.

Is there any means by which I can include this data without having to
construct the pivot tables over again.

When I tried selecting a different source for the data using the wizard I
recieved an error message saying that the field name wasn't valid.

Any ideas?

Adele
 

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

Changing pivot table ADO recordset 0
Refreshing some Pivots Tables makes Excel stop or crash 0
Refreshing some Pivot Tables makes Excel stop or crash 0
Please help! Cannot open pivotTable source file.... 2
Upadte PivotTable Data range 2
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Connection files and pivot tables 0
The PivotTable field name is not valid (error) 1

Top