Power Pivot Crashes? – An Update

powerpivotlogoToday Avi Singh and I met with Howie Dickerman from Microsoft to discuss the Power Pivot for Excel Add-In.  You can read the background to this meeting at my blog post last month.  Howie is the Program Manager assigned to Power Pivot for Excel and has a wealth of experience with Excel and other products.  I shared all the comments that people added to my blog post from 19th October.  The great news is Howie is already crystal clear about the problems.  We had a great discussion about the plans that Microsoft has for improving stability and performance for the Addin.  And there definitely is a plan.  Like any software project it is impossible to say when we will see something, but I am just excited that there is a plan.

How You Can Help

Microsoft already has a clear understanding of the areas that need some work.  What Microsoft needs more than anything is a set of structured steps that will reproduce an issue – any issue you have.  From experience this is very hard to pin down.  If you know how to reproduce an issue, please send me the steps to reproduce it (you can add to the comments below or send me a message via my home page).

Note:  I realise lots of people have had a bad experience at times.  I am explicitly looking for “reproducible steps” here.  This means that when you follow these steps it will always (or often – eg 1 in 4) cause the issue.  If it is not reproducible then the information cannot help for this next phase.

Comments

  1. I attempted to delete a calculated measure, do a Refresh, then do a Save one click after another without stopping. Should be easy but the system locked up. I suspected Power Pivot was very busy and didn’t like the multiple commands. After waiting 10 or 15 minutes, I did an ALT-CTL-Delete to force Excel to end task.

  2. Working within native formula editor of Power Pivot, when I try to Check Formula sometimes Excel stops responding and eventually crashes. This happens even with the most simplest formulas.

  3. Changing a measure name while that measure is still in a Pivot Table results in the measure name changing in all places other than the Pivot Field List.

    Trying to edit that measure using Right Click Edit in the Pivot Table field list then causes Excel to Crash

    Excel 2016 64 Bit

    Happens currently on 2 different machines in 2 different companies.

  4. Transformed an Excel file in Power query. Loaded it data model. Openned in POWERPIVOT, and then a pivot table. TRied to close and save, but it locked up, so i ctrl alt deleted it

  5. Hi Matt,

    I’m a newcomer to PowerPivot and have recently purchased Rob and Avi’s book.
    While practicing adding / editing the Measures (chapter 6), and trying to edit the measure “Profit Pct” (page40), Excel crashes (repeatedly).
    This is while trying to multiply the Profit Pct measure by 1.1 (increase it by 10%).

    I’ve also emailed the screenshot of when this error occurs.

  6. Created a Date/Calendar table mainly in PowerPivot using 11 calculated fields (plus 1 original date field pulled from a worksheet table). Now can’t switch to Diagram View to view/create relationships – each time I try it crashes Excel. Diagram View was no problem with the 9 other tables already in the Data Model, which were created in Power Query.

  7. Click “Update all” in the Excel power pivot ribbon, then click on Microsoft Outlook. The update process in Excel hangs and the only way out is through task manager End Process.

  8. I experience PowerPivot crashing in Excel 2016 whenever I go to edit a measure and click “check formula.” It will crash every single time I do that. I also experience it crash when I edit the measure name and it does not change the name in the field list. If I then try to change the name in the field list, it crashes.

    The only solution I have found to my first issue is to create a new measure every time I need to make a change to a measure. This is incredibly tedious and becoming a bigger issue as I have measures referencing other measures. Please share if you have found a solution to my problem.

    • This is not normal and there is still no fix. In your case I suggest you write your measures in the Power Pivot window down the bottom of the tables. This is a lot more stable.

Leave a Reply

Your email address will not be published. Required fields are marked *

Ten Things I Wish I Knew When I Started With Power Pivot.   Learn  Without The Pain!

x