• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Changing Pivot table source from Access to excel (2007 Version)

K

kar.chiranjib

New Member
Hi,


I have the excel 2007 tool that has a pivot table linked to access table. i now want to change the source of pivot table to another sheet in the same excel file.


is there a way to do it? I would preferably like to use VBA to accomplish this.
 
NON VBA:

Select the PivotTable in Excel and in the Contextual PivotTable Ribbons that should now be visible, you should see an option for Change Source Data. this will allow you to select whichever sheet and cell range contains the data that you want your pivot table based off of.
 
Well, it doesn't allow you to select the excel file. one can certainly choose another connection using this. but get the data from different sheet of the same file is not possible with this.
 
You must log in or register to reply here.
Back
Top