Manual calculation in Excel 2013 PowerPivot RRS feed

  • Question

  • In Excel 2013 PowerPivot, I want to rename a number of DAX formulas that are dependent on each other. Each time I rename or change a formula, Excel becomes unresponsive for at least 10 seconds, displaying "Calculating" and "Reading data" messages. At http://office.microsoft.com/en-us/excel-help/recalculate-formulas-in-power-pivot-HA102836864.aspx the doc says I can turn off calculation by setting DesignCalculationsCalculation OptionsManual Calculation Mode in the PowerPivot window. I've done that and calculation still occurs. What does this setting control? How do I turn off calculation so I can rename my measures without the excessive delays each time I press enter?

    Monday, September 29, 2014 1:46 PM