PowerPivot - Field list keeps expanding - by Ken Puls, CMA, MS MVP (Excel)

Status : 


Sign in
to vote
ID 790154 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 6/13/2013 9:06:48 PM
Access Restriction Public


I’m building measures right now.  They’re a little complicated, so I’m doing them one at a time to make sure they work, rather than building a massive batch of them.  Every time I have to add/remove or move a measure on my pivot, I go to my field well, collapse two tables down (Calendar and Customers) to get the fields out of the way so that I can add the measures stored in the Transactions table.  I then go to modify my measure.  Click OK and all the “collapsing” I’ve done in the field well has cleared.  I have to re-collapse to get to my measures.

Yes, it’s  a small thing, but it’s irritating.  I have to do this every single time I modify a measure.  I can understand (maybe) expanding the table if it holds a measure I’ve added, but expanding the tables each time the measure list is calculated is overkill.

I know it’s still early in the PowerPivot life cycle, and I completely understand why these things are the way they are (bigger fish to fry and all.)  The reason I bring it up though, is that building with PowerPivot is an extremely slow process today.  Little things like this just feel like they add insult to injury as you have to keep re-applying them, slowing you down even more.  It certainly doesn’t affect my ability to do anything or create a solution, it just makes it a more frustrating experience.
Sign in to post a comment.
Posted by Kasper [MSFT] on 6/14/2013 at 10:04 AM
Hi Ken,

Thanks for the feedback. I will pass this on to the Excel team as this part of the code is owned by them.