Pivot Table help

  • Thread starter Thread starter ashishprem
  • Start date Start date
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
 
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
 
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 5
pivot table data 2
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table Data Source 1
Easy way to change Pivot table source files? 5
Pivot tables - memory issues - please help 2
Cannot Open Pivot Table Source File 0
Question on the occupied field of the pivot table in excel spreadsheet 0

Back
Top