Pivot Tables -changing datasource for exsting Pivot Table

K

kfschaefer

Looking for the best way to change the datasource for an existing Pivot
tables, without having to recreate the pivot table.

I tried using the wizard and backstepping however, this method does not
allow me to see the new datasource, unless I want to create a new Pivot table.

Any suggestions is greatly appreciated.
 

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

Connection files and pivot tables 0
excel pivot tables 1
add mergefields to exsting word 2013 2
Expand the fields used in a Datasource for a Pivot Table 0
SUM & OFFSET & PIVOT TABLE?? 0
Changing pivot table ADO recordset 0
Pivot Table with MS Access as DataSource 1
Change report firlds in pivot tables and charts with one selection 0

Top