Share via

Why does Excel freeze when copying large ranges and how can I fix it?

Roger Novak 0 Reputation points
2024-06-11T20:16:26.86+00:00

When attempting to copy a large range, Excel freezes and gradually consumes all available memory (16 GB) over a ten minute period. This issue occurs even in safe mode and repairing Office 365 has not helped. However, when running Excel as administrator, it behaves normally. Any suggestions on what could be causing this issue and how to resolve it would be appreciated.

Device specifications:

  • Device name: newin11install
  • Processor: AMD Ryzen 9 5900X 12-Core Processor 3.70 GHz
  • Installed RAM: 16.0 GB
  • Device ID: 7820E5E5-1B2C-46F4-B071-3F2293CC2D4F
  • Product ID: 00326-10000-00000-AA691
  • System type: 64-bit operating system, x64-based processor
  • Pen and touch: No pen or touch input is available for this display
  • Edition: Windows 11 Home
  • Version: 23H2
  • Installed on: 10/15/2023
  • OS build: 22631.3593
  • Experience: Windows Feature Experience Pack 1000.22700.1003.0
  • Motherboard: AB350M-Gaming 3
  • Graphics card: NVIDIA GTX 1660 Studio Driver 555.99
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,652 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,780 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
    2024-06-12T08:27:37.7+00:00

    Hi @Roger Novak

    Via online search, some third-party software may cause problems when using Office. It is recommended to try a clean boot.

    Besides, as there is no "Disable Hardware Acceleration" option in Office, I suggest you go to Start> Settings> System> Display> Graphics Settings > Select: Desktop app > Use the Browse button to add Excel.exe > After you’ve added Excel, select: Options > Use the Power Saving GPU: Microsoft Basic Render Driver

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.