December 9, 2014 update for Office 2013 (KB2899498)

Note To enable the following changes, you have to install all four of these public updates:

Deferred Data Model Update

In Excel 2013, any change to the Data Model causes Excel to immediately update every PivotTable, PivotChart, and Query Table in the workbook.

This caused users to wait every time that they make a change to the Data Model, such as creating a new measure or a calculated column. Sometimes, depending on the workbook and Data Model complexity, the waiting period can be fairly 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.

Out-of-Memory improvements

Users of Excel 2013 frequently run out of memory in scenarios where the Data Model is involved. This results in computer freezes or Excel crashes. We targeted and improved the following scenarios: 

1. 64-bit version of Excel 2013 is running low on physical memory
   When Excel 2013 detects that user is running low on physical memory, it will stop all allocations and throw an "Out of Memory" error.
2. 32-bit version of Excel 2013 is close to using up its 2GB virtual memory
   When Excel 2013 detects that user is running low on virtual memory, it will stop all allocations and throw an "Out of Memory" error.

Fixes the following bugs

• Fixes the bugs that cause Power Pivot, Power View or Excel to crash or freeze during modeling or slice and dice operations.
• Fixes the bug that causes Excel.exe to run in background after the user exits the application.
• Fixes the bugs that cause Excel to crash upon refresh operation.
• Fixes the bugs that cause Excel workbook to become corrupted after the data connection is edited inside Power Pivot add-in.
• Fixes the bug that causes PivotTable to display incorrect results when it is executed against the embedded Data Model.
• Fixes the bug that causes unexpected behavior when the embedded Data Model is being upgraded.

How to determine whether my Office installation is Click-to-Run or MSI-based:

1. Start an Office 2013 application, such as Microsoft Excel 2013.
2. On the File menu, click Account.
3. For Office 2013 Click-to-Run installations, an Update Options item is displayed. For MSI-based installations, the Update Options item is not displayed.

The Office System TechCenter contains the latest administrative updates and strategic deployment resources for all Versions of Office.