340mb Binary File. Over 4GB RAM being used by Excel to open, then crashes

[colman12]

Hi,

Any ideas would be appreciated.

I have a file I am trying to cut down in size but now struggling to open.

Previous versions (which were slightly bigger) can be opened. Feels like later versions are being corrupted on save.

When I try and open it, RAM is utilised up to being opened then excel crashes.

Sometimes it will open and when it does all formulas are turned into #NA

I assume this is excel saying it doesn't have enough resources to calculate the formulas, although I don't get the "there isnt enough resources" message.

Would it be better to open this on my local drive to make it easier?

I don't really understand why i can open an earlier bigger version but not the latest one.

Thanks,
Colin

 

[Smitty]

Welcome to the Board!

I'd take a serious look at why you even have a file that big, because there has to be a better way to manage whatever you're trying to do. I can't think of too many systems where that wouldn't have a large degree of instability anyway. I'd definitely try to open it locally though.

What version of Excel are you using?

What's the difference between this one and the older versions that would open?

 

[colman12]

Thanks for the reply.

Totally agree, it's inherently unstable. Tough to explain but I have 5 years of historic and 5 years of forecast data by week in 96 pyramids, so the data becomes huge.

Because of what I am doing I can't see how it can be achieved through access or even a statistical analysis system (sas). It's more than just crunching data.

Can't think there is anything significantly different about the two files. I'll try and open it up on the local drive and see what happens.

Really I need to compromise and lose accruacy to claw back stability