Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

Unable to veiw stardard excel pivot drag feature.

Screenshot.pdf  While creating pivot table in excel, I do not see ‘Drop page fields here’; ‘Drop row fields here’; ‘Drop column fields here’ & ‘Drop data items here’ in the spreadsheet. I only see ‘To build a report, choose fields from the Pivot Table Field List’, this also does not allow me to drag items from Pivot Table Field List directly on to the spreadsheet.

This is happening only in a specific sheet and not in all the excel sheets. Any idea what could be causing this?
0
cpatuto
Asked:
cpatuto
  • 4
2 Solutions
 
redmondbCommented:
Hi, cpatuto.

On the Ribbon's Menu Bar, select "Options" (under "PivotTable Tools") and then click on the "Options" frop-down on the Ribbon. Click on the "Display" tab and slect the checkbox for "Classic Pivottable layout (enables dragging of fields in the grid)". Click on "OK".

Regards,
Brian.
0
 
Rory ArchibaldCommented:
Right click the pivot, choose Pivot Table Options, then on the Display tab, check the 'Classic pivot table layout' option.
0
 
redmondbCommented:
... and the picture....
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
cpatutoAuthor Commented:
Thank you, this was helpful. Any idea why would excel automatically uncheck 'Classic pivot table layout' option in some of the excel files but not all?
0
 
redmondbCommented:
cpatuto,

I just assumed that this was a template, a macro or a spirit of adventure by a user! Are you sure this wasn't the situation?

Edit: Supposedly, if you set the default save format to 97-2003 then pivot tables are created with "Classic View" by default. Is that a possibility?

Regards,
Brian.
0
 
redmondbCommented:
Thanks, cpatuto. Did you ever get to the bottom of what caused this?

Edit: I just noticed that you gave the answers a B Grade, indicating that they were deficient in some way. It's normal to explain a Grade other than A in other to help improve future answers, so your feedback would be appreciated.

Thanks,
Brian.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now