Avatar of cpatuto
cpatuto
Flag for United States of America asked on

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?
Microsoft Excel

Avatar of undefined
Last Comment
redmondb

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
redmondb

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Rory Archibald

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
redmondb

... and the picture....
cpatuto

ASKER
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?
redmondb

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
redmondb

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.