Rollback Office

There was a breaking change introduced in the latest update of Microsoft Office which prevents Tally from generating Pivot tables. The only way to get it to work again is to rollback your version of Office to the last version working with the Tally plugin which is 16.0.18623.20208 from April 17, 2025. We are working on a update to Tally to be released in June 2025.

If a recent Office update causes issues with features such as Excel pivot tables, you can roll back to a previous version of Office and temporarily disable future updates. Follow these steps:

1. Open Command Prompt as Administrator

1. Navigate to Office's Update Tool Directory

cd "C:\Program Files\Common Files\Microsoft Shared\ClickToRun"

1. Run the Rollback Command

officec2rclient.exe /update user updatetoversion=16.0.18623.20208

This will take several minutes. Let it complete.

You may also need to disable Auto-Updates to Prevent Office from Updating Again. to do this:

1. Open PowerShell

1. Run the following command

Set-ItemProperty -Path "HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration" -Name UpdatesEnabled -Value "False"

1. Later, you can reanable the auto-update by running this command

Set-ItemProperty -Path "HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration" -Name UpdatesEnabled -Value "True"