Hi!
I need some help on how to remove a drop down menu in a pivot table. I attempted to remove it by unclicking the remove caption and drop downs in the display section of the pivot table options but that removed the drop down menus and the text in that cell. I need the text-the column and row titles- to remain in the cell and the drop down menu of each cell to be removed. Does someone know how to remove the drop down menus?
MariJ
I just read, collegea forummembers think you working on homework.
Please show us an excelfile, without confidentional information.
Please also add the desired result.
Then we can see, what we can do for you.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
This is a task sent to me by a possible employer--does that disqualify me from being able to use this forum?
My example is the excel worksheet. My file is titled "help"! Thanks for the help in advance
Try paste special values only all the drop downs will go
I mean highlight and select H8 to L14 (your Pivot Table) copy and then paste special values only
you can use code to achieve that
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Thank you! That worked--the copy and special value paste! I am going to check the code file next. Have a great day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks