Recently we have announced a new public update to Excel 2013 that includes major stability and usability improvements in Self Service BI scenarios, especially when Power Query, Power Pivot & Power View are involved. For this release we eliminated over 120 bugs, crashes and hangs, and introduced two new important usability improvements that aim to make the analysts’ work smoother.
If you are ready to get the update straight away, skip to the How to Download and Install the Update section below.
Deferred Data Model Update
In Excel 2013, any change to the Data Model caused Excel to immediately update every PivotTable, PivotChart, and Query Table in the workbook.
The users were forced to wait every time that they make a change to the Data Model, such as creation of a new measure or a calculated column. Sometimes, depending on the workbook and Data Model complexity, the waiting period could be pretty long.
To address this problem we have introduced the following changes:
- When the user is within the Power Pivot add-in, we accumulate the changes performed by the user in the Data Model without the Excel workbook being updated.
- When the user moves the focus away from the Power Pivot window and in case the Data Model was changed, then the Excel workbook will be updated automatically.
This change significantly enhanced the experience of the user doing modelling in Excel, so don’t miss on installing this update and experience it for yourself.
Running out of memory in Excel 2013, in scenarios when the Data Model was involved, caused a computer freeze or Excel crash. In this release we targeted these scenarios and introduced a better and friendlier customer experience.
Specifically, in the scenario when 64-bit version of Excel 2013 is running low on physical memory, or if the user is running a 32-bit version of Excel 2013 and getting close to the 2GB virtual memory limit, Excel will detect this, will stop all allocations and will show the “Out of Memory” error message to the user.
For this release we fixed over 120 bugs, crashes and hangs in different scenarios. We improved the stability of slice and dice operations, refresh, Data Model upgrade, connection editing and many more.
We really encourage you to download the latest Excel update and try it yourself.
How to Download and Install the Update
If you have automatic updates enabled for your Office 365 subscription, you should receive the latest Excel update soon. If you don’t have automatic updates enabled in Excel, go to File > Account > Update Options > Update Now.
If you are running a perpetual Office edition then you will need to install the following updates through Windows Update or Microsoft Download Center – KB2910929, KB2899498, KB2899505 and KB2920734.