Home

Out of Memory error while sorting data

Highlighted
Ashley Holley
Occasional Visitor

I have a laptop from a user in my company showing this error while attempting to sort large data pools in Excel:

 

"There isnt enough memory to complete this action. Try using less data or closing other applications. To increase memory availability consider using a 64-bit version of Microsoft Excel."

 

However, the machine in question already has a 64-bit installation of o365 (fully up to date) and the machine itself has 32gb of ram, an i7 processor, and over 200gb empty hard drive space. 

 

I attempted to run the same operation on my machine as well (a comparable / slightly newer laptop configuration) and encountered the same error. 

 

The data pool in question is roughly 200 rows by 5 columns containing information such as dates, hours, names, clients, etc. 

 

Thoughts, Community? 

1 Reply

So are there any formula in the rest of the workbook referring to that table of data?

 

Also are there signs of corruption in the cell styles window?  There will be hundreds of different styles with odd names in this window

image.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies