Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 9 of 9

Thread: Unable To Drag PivotTable Fields

  1. #1
    Join Date
    18th November 2004
    Posts
    4

    Unable To Drag PivotTable Fields

    About a year ago, I had a similar problem that spontaneously fixed itself. This time I don't know if I will be so lucky.

    The issue is that for every pivot table in any file running on my machine, I am unable to drag the column or row values to change the sort order - I.e. if the row is Jan/Feb/Mar/etc., I can't drag Jan down to the middle or rearrange them - it will sort by ascending or descending value just fine, but simply won't allow me to rearrange - the 4-way arrow doesn't appear where it should when mousing over the fields. I can drag fields on/off and from/to the column/row/data sum areas, but I simply cannot re-arrange the order of the values (and yes, the Autosort checkbox is set to "manual" in field settings.)

    Has anyone seen this bizarre problem and does anyone have a solution, short of re-installing excel or getting a new machine?

    Thanks!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709

    Re: Sort Pivot Table By Mouse Drag

    Pivoting a PivotTable doesn't sort the PivotTable. Are you sure your worksheet is not protected?

  3. #3
    Join Date
    18th November 2004
    Posts
    4

    Re: Unable To Drag PivotTable Fields

    When you pivot a dataset, it DOES sort rows by default in alphanumeric order - So if you pivot by a field that has "Apples" "Cherries" "Bananas" it will group in order. My pivot tables are grouping fine, and I can change the sort order manually by right-clicking on a cell and selecting order-->Move up/down, etc., but I simply can't do it with the mouse - the 4-way arrow doesn't show up.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709

    Re: Unable To Drag PivotTable Fields

    That's not correct. The way to sort a PivotTable is via the PivotTable Field Advanced Options. When you use Manual (default) you stop automatic sorting or Data source order to return the items to their original order.

    If you cannot drag fields, try unprotecting the Worksheet.

    Are you sure your worksheet is not protected?

  5. #5
    Join Date
    18th November 2004
    Posts
    4

    Re: Unable To Drag PivotTable Fields

    Last time I checked, if you pivot a dataset, the rows will be sorted by alphanumeric order based on their labels; having nothing to do with the values. I am NOT talking about sorting by value, I am simply talking about display order - I often move tables around by adjusting the display order so it can be copied into powerpoint, etc. This basic functionality has mysteriously disappeared - this has NOTHING to do with sorting based on the values that have been dragged to the "Drop Data Items Here" area - just the order that the row fields are in. They alphabetize by default; you change that to ascending or descending in the options, or limit to top 10 / top 50 etc. The default is the "manual" setting in which you are SUPPOSED to be allowed to drag them to change them, however the 4-way arrow that shows up when you hover between two fields within a column does NOT appear - this is the problem I am having.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709

  7. #7
    Join Date
    18th November 2004
    Posts
    4

    Re: Unable To Drag PivotTable Fields

    Likewise.

    I have been using advanced excel functions/capabilities every day for the last 10-15 years, and my worksheets are not protected, and I understand exactly what you are saying, but that is not the issue.

    Look at the attached example.

    The pivot table auto-sorts the column order by alphanumerics - I.e. APAC, EMEA, then US - the data within the dataset obviously not sorted. All I want to do is be able to drag the "US" row around, i.e. put it at the top. I can do this via the PivotTable toolbar --> Order --> Move Up/etc., but my issue is that I can not do it by mouse - the 4-way arrow will not show up when I mouse over between "US" and "1st region"
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709

    Re: Unable To Drag PivotTable Fields

    I have been using advanced excel functions/capabilities every day for the last 10-15 years, and my worksheets are not protected, and I understand exactly what you are saying, but that is not the issue.
    Finally an answer!

    If ALL you want to do is drag the US field to the top, simply select the cell and drag the cell by the RIGHT border! You can ONLY drag by the LEFT border if there is a column to the left.

    NOTE: This is NOT how ones Sorts a PivotTable. That I have explained above.

  9. #9
    Join Date
    18th July 2013
    Posts
    1

    Re: Unable To Drag PivotTable Fields

    I had the same problem and googled for a solution. All search results brought me back to this page . Finally, I figured out the problem after a few hours and thought about sharing it here so it helps other unfortunate folks facing this issue.

    Go to File > Options > Advanced > Enable file handle and cell drag-and-drop > Select the check box.

    I know that I did not go there to unckeck that option in the first place.. Due to some keyboard shortcut, that option might have been unchecked. Just need to select it again ")

    Cheers,

    Amit

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Pivottable Without Data Fields
    By fmacabeo in forum EXCEL HELP
    Replies: 3
    Last Post: April 13th, 2008, 09:49
  2. Unhide All PivotTable Fields
    By Thad in forum EXCEL HELP
    Replies: 2
    Last Post: January 11th, 2008, 11:05
  3. Replies: 2
    Last Post: November 29th, 2006, 00:59
  4. Replies: 10
    Last Post: October 18th, 2006, 03:06

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
  •  
porno