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

• Moved by Fei XueMicrosoft contingent staff 5 hours 44 minutes ago

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

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...

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.

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