Forum Discussion

EfRomero's avatar
EfRomero
New Member
2 years ago
Solved

Drill Through Capability in Excel Pivot Table Lost

After upgrading Excel to version 2403 from 2402 the ability to drill through in pivot tables has been lost. When attempting to drill through the message "RETURN clause cannot be used with DRILLTHROUG...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi EfRomero ,

    Based on the details you have provided, it appears that this issue may be related to changes or updates in Excel version 2403 that may affect the drill-down functionality in pivot tables. Below are steps to help you resolve the issue:

    1. Sometimes, new updates reset or change settings. Double-check your Excel options, especially those related to data and pivot tables, to ensure that nothing has been changed that could affect drill-down.
    2. If the problem persists and seriously affects your work, consider rolling back to a previous version (2402) as a temporary measure. A guide on how to revert to an earlier version is available:
      Latest updates for versions of Office that use Windows Installer (MSI) - Office release notes | Microsoft Learn
    3. Since this issue affects multiple users, it may be helpful to check if it is a known issue in the Microsoft community or technical community. Sharing your experience there may also alert the Excel team to potential bugs introduced in the latest update.

    Best Regards,

    Ada Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Ally_wu's avatar
Ally_wu
New Member
2 years ago

Hi,

Does the solution work. the RETURN clause is being added to drill through query when trying to drill through in Excel Pivot table connected with Power BI. Does any newer version of Excel handle the drillthrough differently?

  • EfRomero's avatar
    EfRomero
    New Member
    2 years ago

    The solution did work for me because I am an administrator on my machine. The solution will not work for those individuals that are not able to rollback the Excel version because they are not admins on their machine or their employer has a policy of not allowing version rollbacks. 

    I am looking at other solutions that do not involve version rollbacks. I will continue this thread if I have positive results.

    • dnspk's avatar
      dnspk
      Frequent Visitor
      2 years ago

      Hi,

       

      Were you able to find another solution for this issue that does not involve version rollbacks? A lot of folks in our organization are not admins on their laptops and version rollback is not a viable option.

       

      Regards,

      • cathryn13's avatar
        cathryn13
        Frequent Visitor
        2 years ago

        We had to roll back to a previous version.  We could not find a solution that worked without doing so.  Fortunately, we caught it with only one person and 2 developers that had the auto update install the latest version.  We turned off auto updates for the company to prevent this version from being applied to anyone else