Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 10 of 10

Thread: Reorder Drag Pivot Table Items

  1. #1
    Join Date
    17th July 2004
    Location
    Texas, USA
    Posts
    1,939

    Reorder Drag Pivot Table Items

    I have a Pivot Table on which I am unable to drag the row items (Salesperson Names) to a different position. What am I doing wrong?

    Attached Sample
    Last edited by Bill Rockenbach; May 5th, 2009 at 10:12.
    Bill
    Tip: To avoid chasing code always use Option Explicit.

  2. #2
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,954

    Re: Reorder Pivot Table items

    Where do you want them to go? I can move them to the column and page fields, just dragged the label as normal.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,715

    Re: Reorder Pivot Table items

    Bill Remove or move the page field. Then add a column at Column A. Now hover over any name item until the right pointing arrow shows, click then move the mouse until you get the 4-way pointing arrow and drag.

  4. #4
    Join Date
    17th July 2004
    Location
    Texas, USA
    Posts
    1,939

    Re: Reorder Drag Pivot Table Items

    Thanks for the replies

    Stephen,
    I just want to reorder the position of the salespersons

    Dave,

    Then add a column at Column A.
    Add a column to the sheet outside the Pivot Table or a column within the Pivot Table?
    Bill
    Tip: To avoid chasing code always use Option Explicit.

  5. #5
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,954

    Re: Reorder Drag Pivot Table Items

    Bill: as soon as I click on any of the names and move the mouse until the cursor changes to the 4-way arrow, I can then move them anywhere on the list.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    17th July 2004
    Location
    Texas, USA
    Posts
    1,939

    Re: Reorder Drag Pivot Table Items

    On the vary file I posted, when I hover over a salesperson name in a cell in the Pivot Table I get no response. I’m using xl2000, but never had this problem before.
    Bill
    Tip: To avoid chasing code always use Option Explicit.

  7. #7
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,954

    Re: Reorder Drag Pivot Table Items

    I have to click on the cell rather than hover over it but not sure if that's abnormal.

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    17th July 2004
    Location
    Texas, USA
    Posts
    1,939

    Re: Reorder Drag Pivot Table Items

    Wrong choice of words. I do click on the cell and hold the mouse button down, but nothing happens.
    Bill
    Tip: To avoid chasing code always use Option Explicit.

  9. #9
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,954

    Re: Reorder Drag Pivot Table Items

    Apologies if this smacks of grandmothers and egg-sucking but rather than hold down mouse, hover until 4-way arrow appears and then drag?

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    17th July 2004
    Location
    Texas, USA
    Posts
    1,939

    Re: Reorder Drag Pivot Table Items

    I've tried it every way possible, no response.
    Auto Merged Post Until 24 Hrs Passes;

    Sorry for the false alarm. I found the problem. I recently moved my Excel over to my wife’s computer. She has a funky curser setup and the curser does not change to the standard four-way arrow cursor. (The standard curser is an animated mouse and the hourglass is an animated dragon) It doesn’t change at all. But I got it to work by holding the funky animated mouse curser on the cell border and dragging.
    Last edited by Bill Rockenbach; April 1st, 2008 at 17:12. Reason: Auto Merged Doublepost
    Bill
    Tip: To avoid chasing code always use Option Explicit.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Hide Specific Items In Pivot Table
    By palstrup in forum EXCEL HELP
    Replies: 3
    Last Post: August 6th, 2008, 03:17
  2. Pivot Table Page Field Hidden Pivot Items
    By Dwayno in forum EXCEL HELP
    Replies: 7
    Last Post: March 17th, 2006, 01:47
  3. Pivot Table - Showing items with no value
    By ksmith0099 in forum EXCEL HELP
    Replies: 1
    Last Post: November 5th, 2005, 01:44
  4. Looping though a Pivot table page items
    By DROM in forum EXCEL HELP
    Replies: 2
    Last Post: July 10th, 2005, 04:02

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