Pivot Table Data Source Issue


Well-known Member
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!


Well-known Member
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.


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

Uncheck and try again. Let me know.​


Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...