• 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.

Search results

  1. K

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

    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.
  2. K

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

    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.
Back
Top