+ Reply to Thread
Results 1 to 2 of 2

HELP! Pivot sorting by data that is no longer there. Trying to clean up the sorting option

  1. #1
    Registered User
    Join Date
    12-16-2015
    Location
    New York, NY
    MS-Off Ver
    2010
    Posts
    1

    HELP! Pivot sorting by data that is no longer there. Trying to clean up the sorting option

    PLEASE HELP! I created a pivot table and now that it is completed. I am trying to sort a particular column that should only have three sorting options. When I click on the drop down to sort it has a ton of old data. Is there a way to delete the sorting options that no longer exist? I have checked the data source and it's my current database. Thank you!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,817

    Re: HELP! Pivot sorting by data that is no longer there. Trying to clean up the sorting op

    Hi

    have a look at http://www.contextures.com/xlPivot04.html

+ 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. New to forum.. Want to do an advanced sorting option keeping row data together.
    By Big_D_in_Va in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-14-2015, 03:17 PM
  2. Sorting Pivot Table Data
    By kbiro in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-23-2015, 04:14 PM
  3. Pivot Data Sorting
    By sammymalta in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-10-2015, 12:55 AM
  4. Macro Clean Up/Errors during sorting
    By glitchless in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2014, 09:51 PM
  5. Replies: 0
    Last Post: 02-24-2014, 11:27 AM
  6. Sorting 2 data ranges by comparing one column in each and sorting to match
    By MDKsmiffy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2013, 03:30 PM
  7. Pivot table no longer sorting correctly (2003)
    By mlk in forum Excel General
    Replies: 0
    Last Post: 02-28-2011, 02:15 PM

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