Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Message: Updating Pivot Tables, and Excel stops responding, when summarizing payroll data in Excel

 When summarizing your payroll data in Microsoft Excel, a dialog appears stating "Updating Pivot Tables" but never goes away.

Why this is happening

  • The current payroll tax tables are damaged
  • The current installation of QuickBooks Desktop is damaged
How to fix it

Solution 1:  You will need to download the entire payroll update and repair the QuickBooks installation.

  1. Re-download the payroll update:
    1. From the Employees menu, select Get Payroll Updates.
    2. Place a bullet in Download entire payroll update.
    3. Click the Update button.
  2. Repair the QuickBooks Desktop installation.

Solution 2:  Uninstall and reinstall QuickBooks Desktop and its installation files (clean install).

KB ID# SLN41148
4/28/2017 2:50:12 PM
QYPPRDQBKSWS08 9138 Pro 2017 0560d9