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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 790154 Comments
Status Closed 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 Microsoft 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.