Excel files more than 30MB and device hangs

Boopathi Subramaniam 3,196 Reputation points


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.




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

    Hi @Boopathi Subramaniam

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



    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.