asked on Excel Hangs / Not enough Memory
A user has exported a report from EPOS software to excel, the spreadsheet is around 10,000 rows and 30 columns in size. The aim is to delete columns, and then filter the results in a pivot table. However, when trying to do this, an error occurs saying there is not enough memory. The laptop has 8GB RAM and 4 is being used at most whilst using excel, Office 2016 32-bit is installed. No other user programs were running. How can I get around this?
Microsoft ExcelMicrosoft OfficeMicrosoft ApplicationsMicrosoft 365Office Productivity
Last Comment
Glenn Ray
Upgrade Office to 64 bit (uninstall 32, reinstall 64) and see if that helps. If Excel needs more RAM, it needs to use 64 bit as 32 bit is limited.
Are there any macros or other VBA code involved?
I had a client this week getting an "not enough memory" error with an Excel spreadsheet that wasn't large at all. After seeing the error message, the spreadsheet would come up. I re-saved the spreadsheet under another name and the issue was resolved in the copy. You may want to give that a try.
ASKER
I've tried installing 64-bit today, no error messages this time it just hangs.
No macros or VBA, only excel filters.
User demonstrated to me that when she used a filter to delete 5000 of the 10000 rows it just hangs.
No macros or VBA, only excel filters.
User demonstrated to me that when she used a filter to delete 5000 of the 10000 rows it just hangs.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.