+ Reply to Thread
Results 1 to 3 of 3

Specify range in Pivot Table getting external data

  1. #1
    Registered User
    Join Date
    07-04-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    24

    Specify range in Pivot Table getting external data

    Is there a way to specify the range that the Pivot Table references when getting external data from an Excel spreadsheet? I have my Pivot Table working, but I just need this last part to make it more efficient.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Specify range in Pivot Table getting external data

    Not sure if I understand you correctly, but try this

    In the external file
    - create a named range for the source of your data

    In the file containing your pivot table
    - click on Change Data Source
    - amend the source so that it refers to the named range in the other file

    .

    PivotSource.jpg

    If you have both files open when amending the data source, Excel should correctly insert file path to the external file (when that file is closed)
    Last edited by kev_; 04-11-2018 at 02:24 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    07-04-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    24

    Re: Specify range in Pivot Table getting external data

    Thanks! This was what I was looking for. It seems to have worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Pivot table doesn't update from external csv while data table does
    By Nick_Berlin in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 11-30-2014, 06:50 PM
  2. Pivot Table Data Source - External to Internal
    By littlemy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-13-2014, 09:03 AM
  3. Can't Refresh Pivot Table When Using External Data Source
    By yenping.fu in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-02-2014, 06:24 AM
  4. #DIV/0! Error in Pivot table using external data source
    By bboard in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-26-2013, 02:19 PM
  5. Replies: 0
    Last Post: 05-25-2010, 05:47 PM
  6. Pivot table via external data sourse (cvs)
    By JoannaP. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-17-2008, 01:53 PM
  7. [SOLVED] Pivot table using External data
    By nc in forum Excel General
    Replies: 3
    Last Post: 04-26-2005, 08:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1