+ Reply to Thread
Results 1 to 4 of 4

Importing new data into Pivot Table

  1. #1
    Registered User
    Join Date
    04-25-2015
    Location
    Ontario, Canada
    MS-Off Ver
    2010
    Posts
    29

    Importing new data into Pivot Table

    Hi everyone,

    I would like to have a pivot table which references a table on another tab which is basically a data dump. However, I must make sure I delete all old data before I paste the new data into the data tab table. When I delete the data, my table deletes as well, and the pivot table won't refresh (Ref isn't valid).

    Is there a way to wipe out all the data on my table without deleting my table as well? Or is there a better way to do this?

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    2,945

    Re: Importing new data into Pivot Table

    Hi

    If you use an Excel table (with headers), when you delete the body but maintain the headers the pivot table retain the definition.

  3. #3
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    Excel 2016
    Posts
    229

    Re: Importing new data into Pivot Table

    Are you highlighting all records then right-clicking and choosing “Delete” from the pop-up menu? If so, you’re deleting your table. Try highlighting your records then hitting the “Delete” button on your keyboard; that should wipe the data without deleting your table.

  4. #4
    Registered User
    Join Date
    04-25-2015
    Location
    Ontario, Canada
    MS-Off Ver
    2010
    Posts
    29

    Re: Importing new data into Pivot Table

    Damn, something so simple. I realized I was selecting a header and hitting control+a. If you select a cell in the actual data, it doesn't copy the headers. Thanks guys.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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