Excel files more than 30MB and device hangs

Boopathi Subramaniam 3,196 Reputation points
2024-03-08T14:42:22.01+00:00

Hello,

There are users use the excel file with formulas which has maximum of 30MB size.

They are trying to copy and paste empty cells and rows to different place. It started to hang.

Below is the installed version and it is 64 bit. Operating system also 64 Bit.

User's image

 User's image

Users need to kill excel in task manager to bring the device to normal state. 

All the drivers and Windows updates are up to date.

 

Please help to solve the issue.

 

 

 

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,430 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua-MFST 4,360 Reputation points Microsoft Vendor
    2024-03-11T03:17:09.2466667+00:00

    Hi @Boopathi Subramaniam

    I suggest you refer to following threads to optimize Excel performance:

    https://answers.microsoft.com/en-us/msoffice/forum/all/excel-issue-running-large-files/cc498806-e500-4671-86ff-2e9ee115595e

    https://answers.microsoft.com/en-us/msoffice/forum/all/excel-file-too-big-over-40mb-and-running-really/744a5b9f-bfd9-4b96-8344-d63911ded554


    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.