Pivot Table help

A

ashishprem

Hi,
I want some help in pivot table. I have an workbook which contains a
pivot table. I want to edit existing the pivot table.I want to change
the datasource of the pivot table to some other workbook. I don't know
how to do? Shall i edit it or make a new pivot table?
please tell me how to proceed?

Regards,
Ashish
 
V

VBA Noob

Very quick to create so I would do a new one.

If you do want to try it then right click the pivot and select wizard.
Next select back and change the range to new workbook range

VBA Noob
 
D

Debra Dalgleish

Open both workbooks
Right-click a cell in the pivot table, and choose PivotTable Wizard
Click the Back button
On the Window menu, choose the new source workbook
Select the range you want to use for the pivot table, and click Finish
Close the source workbook.
 

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

pivot table data 2
Pivot table 5
Pivot table filter list - listing irrelevant subcategorys 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Easy way to change Pivot table source files? 5
Pivot tables - memory issues - please help 2
Issue with pivot table 1
Pivot Table Data Source 1

Top