+ Reply to Thread
Results 1 to 2 of 2

Editing a pivot table

  1. #1
    Registered User
    Join Date
    08-08-2005
    Posts
    8

    Editing a pivot table

    I've made a pivot table that shows me the number of duplicate entries on an address list. Now I want to delete the duplicates. When I drill down, it puts the list onto a new sheet, and deleting the rows I don't want does not effect my original data source. Is there an easy way to make changes to the results of the pivot table that will show up on the data source?

  2. #2
    Debra Dalgleish
    Guest

    Re: Editing a pivot table

    Changing the pivot table, or the output from a drilldown, won't affect
    the source data. If the pivot table is based on an Excel table, you can
    use the techniques on Chip Pearson's site, to mark and delete the
    duplicates in the source data:

    http://www.cpearson.com/excel/duplicat.htm

    jennerifw wrote:
    > I've made a pivot table that shows me the number of duplicate entries on
    > an address list. Now I want to delete the duplicates. When I drill
    > down, it puts the list onto a new sheet, and deleting the rows I don't
    > want does not effect my original data source. Is there an easy way to
    > make changes to the results of the pivot table that will show up on the
    > data source?
    >
    >



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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