Pivot Table Issues

Fix Excel PivotTable Drill-Through Error After Version 2403 Update

Kushani Nimanthika Oct 1, 2026 869 views

Question details

Users are experiencing a failure when attempting to drill through data in PivotTables, receiving an error related to a RETURN clause.

How to Fix Excel PivotTable Drill-Through Error After Version 2403 Update

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to use the drill-through (show details) feature on an Excel PivotTable after updating the application to version 2403.
Observed behavior: The drill-through action fails and displays an error message stating that a RETURN clause cannot be used with a DRILLTHROUGH statement when a DetailRows expression is defined.

Before you start

Save your current workbooks and check your exact Microsoft Office version number in the Account settings before initiating any updates or rollbacks.

Solution 1Recommended

Roll Back Excel to Version 2402

Reverting to the previous stable version (2402) is the most reliable workaround until Microsoft releases a permanent fix for this specific bug.

Since the bug was introduced in version 2403 and persists in early builds of 2404, rolling back your Office installation to the last known working version (2402) will restore the drill-through functionality.

Disable Automatic Updates

Open Excel, click on 'File', select 'Account', click the 'Update Options' drop-down menu, and select 'Disable Updates' to prevent Excel from automatically reinstalling the buggy version.

Open Command Prompt

Click the Windows Start menu, type 'cmd', right-click on 'Command Prompt', and select 'Run as administrator'.

Navigate to the ClickToRun Folder

In the Command Prompt window, type 'cd %programfiles%\Common Files\Microsoft Shared\ClickToRun' and press Enter.

Execute the Rollback Command

Type 'officec2rclient.exe /update user updatetoversion=16.0.17328.20184' (or the specific build number for your channel's version 2402) and press Enter. Wait for the Office update dialog to finish downloading and applying the older version.

Monitor for Future Updates: Remember to re-enable your updates once Microsoft confirms a permanent fix in a release following version 2404.

Solution 2

Check for the Latest Office Patch

Microsoft is actively aware of this issue and frequently releases patches. Checking for a newer update might resolve the problem if a fix has been deployed.

Free Microsoft Office alternative

Try WPS Office for Error-Free Data Analysis

If Microsoft Excel bugs are disrupting your workflow and you want to avoid the hassle of version rollbacks, WPS Office provides a lightweight, highly compatible alternative for managing spreadsheets and PivotTables smoothly.

1. Download WPS Office: Visit the official WPS Office website and download the free software suite.
2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx file containing the PivotTable.
3. Analyze Your Data: Double-click on your PivotTable data to seamlessly use the drill-through feature without encountering the RETURN clause error.

100% compatible with Microsoft Excel (.xlsx) and PivotTable formatsLightweight installation with fast loading times and no version-breaking bugsAdvanced PivotTable features for seamless data drill-through and analysisFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

What causes the RETURN clause error in Excel PivotTables?

This error is a known bug introduced in Microsoft Excel version 2403. It occurs when a user tries to drill through a PivotTable that has a DetailRows expression defined, causing a conflict with the background DRILLTHROUGH query statement.

Can I use the drill-through feature without rolling back my Excel version?

Currently, if updating to the latest patch does not resolve the issue, the only proven workaround to restore this specific drill-through functionality is to downgrade your Excel installation to version 2402.

How do I check my current Excel version?

To check your version, open Excel, click on 'File' in the top-left corner, select 'Account', and look under the 'About Excel' section. You will see your current version number and build details.

Excel & Data Problems