Excel 64 Bit Out of Memory

I'm using Excel to temporary work out logic/rules for some database development.

I dumped a load of data into the workbook to test everything out before I create the stored procedures/ETL packages etc, then stupidly saved it without removing some of the data...

The file is 650Meg, and just will not open, before you say it, I'm using Excel 64Bit, with 64Gig of RAM on a Win2008R2 (Enterprise) Machine with 8CPU's...

Excel starts to open the file, it gets to 100%, then about 5 minutes later it tells me it doesn't have enough resources, despite using 20Gig of ram so far.

I know Excel 64Bit should use everything that's available to the machine, have I missed a setting or something else that's stopping it from using more ram?

Cheers

Christian

June 12th, 2015 12:03pm

Re: 650 MB file

Excel has internal limits on memory use.
650 MB is the largest Excel file size I have ever seen mentioned in the forums.
You are probably going to have to start over.

'---
Jim Cone
Free Windows Admin Tool Kit Click here and download it now
June 12th, 2015 12:48pm

According to Microsoft specs, that's not an issue...

https://support.office.com/en-za/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f

"64-bit environment imposes no hard limits on file size. Workbook size is limited only by available memory and system resources."

Like I said, 8 CPU's, 64Gig of RAM, Excel gets to about 20Gig of ram and then doesn't want to know...

June 12th, 2015 1:16pm

Maybe you can open a new Excel file and do a PowerPivot to the one that won't open.  At least that way you should be able to extract your data. 

I didn't even know excel can grow to 650MB. 

I hope you have a backup.

Free Windows Admin Tool Kit Click here and download it now
June 12th, 2015 4:34pm

Hi Christian,

According to your description, this issue is related to Excel, the Excel IT Pro Discussions forum is a better place for this issue, we will move it there for you.

Regards                      

Starain

June 17th, 2015 9:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics