Powerpivot Data Model calculating workbook far to often and uneccessarialy - by masplin

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 803939 Comments
Status Resolved Workarounds
Type Suggestion Repros 0
Opened 9/30/2013 6:40:01 AM
Access Restriction Public


In Excel 2010 you can add new columns to the powerpivot data model, add a title, change the data format, change a title letter to capitals etc without forcing a complete recalcualtion of the whole workbook unless you actually request it.  These changes make no difference to the workbook, but it seems that every tiny change in Excel 2013 trips a full recalcuation.  To get round this you have to hit escape in the workbook for every pivot table, of which I have 20. So in order to add a new calculated column (note "new" so it is not involved in any pivot table) I have to insert a column and hit escape 20 times, next add my  formula and hit escape 20 times, next give it a title and hit escape 20 times and maybe change the date format from dd-mm-yy to dd/mm/yy and hit escape 20 times. It's enough to make you suicidal if you have a lot of building to do.    

This is just bad code as the model should be able to tell if a change has any affect on the workbook. Or just have the abilty to turn it off like the defer layout check box.  I really wish I had never "upgraded"
Sign in to post a comment.