Forum Discussion

Vipul_Jain's avatar
Vipul_Jain
Copper Contributor
Apr 01, 2024

Grouping of date in Pivot Table freezes the excel for 5-7 minutes

Can someone please help as to suddenly from last few days, I am facing a weird challenge using excel of Microsoft 365 Enterprise version.

 

Wherein, whenever I plot a pivot and try to drag a date, it freezes the excel if disable auto grouping of date is unchecked from options>Data or even if disable auto grouping of date is checked from options>Data, then date would be dragged but the moment, i try to group it, it freezes.

 

I have reinstalled Office manually as well as using assistant tool of microsoft but nothing worked. Can someone please help.

Excel
office 365
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Apr 02, 2024

    Vipul_Jain 

    Here are some troubleshooting steps and suggestions to address the issue:

    1. Check for Updates: Ensure that your Microsoft 365 installation is up to date. Sometimes, performance issues can be resolved by installing the latest updates, which may include bug fixes and performance improvements.
    2. Disable Hardware Graphics Acceleration: In Excel, hardware graphics acceleration can sometimes cause issues with performance. You can try disabling it to see if it improves the situation. Here's how:
      • Go to File > Options > Advanced.
      • Under the "Display" section, check the box that says "Disable hardware graphics acceleration."
      • Click OK to apply the changes and restart Excel.
    3. Reduce Workbook Size: Large workbooks with extensive data and formulas can contribute to Excel's slowdown. Try to minimize the size of your workbook by removing unnecessary data, reducing the number of calculations, and optimizing formulas where possible.
    4. Check for Corrupted Data or Formulas: Sometimes, corrupted data or formulas can cause Excel to freeze. Check your workbook for any errors, such as circular references, and fix them. You can also try copying your data into a new workbook to see if the issue persists.
    5. Optimize PivotTables: If you're working with large datasets in PivotTables, consider optimizing them for performance:
      • Limit the number of rows and columns included in your PivotTable.
      • Avoid using calculated fields or items that require complex calculations.
      • Use manual refresh instead of automatic refresh for PivotTables, especially if you have multiple PivotTables in your workbook.
    6. Repair Office Installation: If you've already tried reinstalling Office but the issue persists, you can try repairing the Office installation. Here's how:
      • Go to Control Panel > Programs > Programs and Features.
      • Find Microsoft 365 in the list of installed programs, right-click it, and select "Change."
      • Choose "Repair" and follow the on-screen instructions to repair the installation.
    7. Check System Resources: Make sure your computer meets the system requirements for running Excel smoothly. Insufficient memory or processing power can lead to performance issues. The text was created with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.

Resources