+ Reply to Thread
Results 1 to 2 of 2

Pivot Table pulls in old data (worksheet was copied from an old worksheet)

  1. #1
    Registered User
    Join Date
    08-18-2020
    Location
    Houston, TX
    MS-Off Ver
    MS365
    Posts
    1

    Pivot Table pulls in old data (worksheet was copied from an old worksheet)

    So I'm new to the Pivot Table concept (all I knew about Excel I forgot a long time ago). I have a worksheet that keeps pulling in old data from the worksheet that is the master (made 2 years ago). Is there a way I can find the data that it keeps pulling in and delete it?

    *crossing fingers, eyes, toes*

    Thanks for any help.

    Due to the nature of the data I cannot show print screens etc.

    Jennifer

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Pivot Table pulls in old data (worksheet was copied from an old worksheet)

    Perhaps the reference (source) data link in your PT is still looking at the old file?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Data (Drop Down) Value in 1 Worksheet / Copied-Updated to Another Worksheet
    By SMurtagh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2016, 01:28 PM
  2. [SOLVED] Need to Build Macro that Pulls Data from one Worksheet into a Second Worksheet
    By coa747400 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2014, 03:59 PM
  3. Copy data from a copied worksheet to another worksheet based on cell reference
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2013, 02:18 PM
  4. Replies: 0
    Last Post: 07-01-2013, 10:19 AM
  5. [SOLVED] Editing worksheet which pulls data from another worksheet
    By src16 in forum Excel General
    Replies: 18
    Last Post: 02-01-2013, 06:12 PM
  6. info/data transferred/copied from worksheet to worksheet in same workbook!
    By joe dech in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-17-2012, 02:53 PM
  7. Replies: 2
    Last Post: 07-06-2011, 05:43 PM

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