Results 1 to 10 of 10

Thread: Pivot Table Data Source Issue
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular FinancialAnalystKid's Avatar
    Join Date
    Oct 2004
    Location
    Glendale, CA
    Posts
    779
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot Table Data Source Issue

    This has never happened to me. For years! And suddenly this is happening.

    For years I've copied workbooks and renamed them or used "SAVE AS" to create another version.

    v1, v2... etc.

    Pivot Tables and the Source stay within that workbook. But now- the source points to original file!

    So if I save v1 as v2 the pivots on workbook v2 are pointing to data in v1!

    I have to change data source on ALL the pivot tables and I can't figure out why this is happening!

    Any help would be appreciated!
    "Losers blame others for their failures. Leaders overcome failures to become Winners."
    My DadWithAPen blog
    Please Like My Facebook Page

  2. #2
    Board Regular chicagocomputerclasses's Avatar
    Join Date
    Mar 2015
    Location
    Chicago, IL
    Posts
    645
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Data Source Issue

    Which version of excel is this?

    When you right click on Pivot Table-> Pivot Table Options->Data->Save Source Data With File is it checked?

  3. #3
    Board Regular FinancialAnalystKid's Avatar
    Join Date
    Oct 2004
    Location
    Glendale, CA
    Posts
    779
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Data Source Issue

    Excel 2013
    Yes it is checked!
    "Losers blame others for their failures. Leaders overcome failures to become Winners."
    My DadWithAPen blog
    Please Like My Facebook Page

  4. #4
    Board Regular chicagocomputerclasses's Avatar
    Join Date
    Mar 2015
    Location
    Chicago, IL
    Posts
    645
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Data Source Issue

    In your original file, under Analyze->Change Data Source, what's the data source?

  5. #5
    Board Regular FinancialAnalystKid's Avatar
    Join Date
    Oct 2004
    Location
    Glendale, CA
    Posts
    779
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Data Source Issue

    Original file: CVI Program.xlsx
    Source: Encounters!$A$3:$BB$4373


    New File: CVI Program (v2).xlsx
    Soucre: '[CVI Program.xlsx]Encounters'!$A$3:$BB$4373

    Still points to original source.
    "Losers blame others for their failures. Leaders overcome failures to become Winners."
    My DadWithAPen blog
    Please Like My Facebook Page

  6. #6
    Board Regular chicagocomputerclasses's Avatar
    Join Date
    Mar 2015
    Location
    Chicago, IL
    Posts
    645
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Data Source Issue

    edit: sorry, misread
    Last edited by chicagocomputerclasses; Apr 27th, 2017 at 04:27 PM.

  7. #7
    Board Regular FinancialAnalystKid's Avatar
    Join Date
    Oct 2004
    Location
    Glendale, CA
    Posts
    779
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Data Source Issue

    LOL I was thinking WHAT? LOL
    "Losers blame others for their failures. Leaders overcome failures to become Winners."
    My DadWithAPen blog
    Please Like My Facebook Page

  8. #8
    Board Regular chicagocomputerclasses's Avatar
    Join Date
    Mar 2015
    Location
    Chicago, IL
    Posts
    645
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Data Source Issue

    I can't replicate your problem. Anybody else who can replicate this problem?

  9. #9
    Board Regular chicagocomputerclasses's Avatar
    Join Date
    Mar 2015
    Location
    Chicago, IL
    Posts
    645
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Data Source Issue

    When you right click on Pivot Table-> Pivot Table Options->Data->Save Source Data With File.

    Uncheck and try again. Let me know.






  10. #10
    Board Regular FinancialAnalystKid's Avatar
    Join Date
    Oct 2004
    Location
    Glendale, CA
    Posts
    779
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Data Source Issue

    Tried that. Same result.
    "Losers blame others for their failures. Leaders overcome failures to become Winners."
    My DadWithAPen blog
    Please Like My Facebook Page

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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