I have a pivot table with two levels in Row Labels.
We change the filters often in that pivot table. Every time we change some of the entries are expanded. That's annoying. I don't want the pivot table to expand rows unless I manually expand them.
Is that possible?
Also, is it possible to do COLLAPSE ENTIRE FIELD to ALL the pivot tables in the excel?
Thanks
If you go to pivot table options, in the layout and format tab, atthe bottom you can uncheck, "Autofit column widths on update."
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
That's unchecked already and I don't think it's related..
Sorry I thought you were talking about the expanding columns, not rows. A pivot table is going to show all of the rows that are related to your search. I guess you could filter to show only the top 10 items, then the number of rows would stay static.
I think you can group the data.
Can you upload a sample sheet?
Uploading a sample won't help, since I think that this happens when the EXTERNAL DATA is being refreshed and a new data is coming to the pivot table.
Not sure what you mean by grouping the data..
Last edited by whatever61; 06-29-2015 at 04:32 PM.
Bump! Any idea?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks