Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Sophie7

macrumors newbie
Original poster
Jan 15, 2011
2
0
I really hope someone can help me, I have been to several forums and nobody seems to have this problem...

I have been using very large (52,000 rows, 30 columns) excel files as part of my MSc thesis (hence, due to the type of data I can't make them any smaller). Today Microsoft word crashed and lost a whole load of work which I had previously saved - I have resided with the fact that I will probably have to re-write this as it was my own fault for not backing up...
However, since this happened, I have not been able to open these large excel files. Plus, they only appear on the 'recently opened' tab, and I cannot find them where I originally saved them, even if I use spotlight etc.
All that happens when I try to open is the 'opening' bar, and then a blank excel window, with no cells and just a message at the bottom saying 'calculating cells 0%' and a never-ending beachball... At this point if I click on excel in the dock it is no longer responding.

I have tried:
Restarting
Updating both my mac and microsoft office
Moving the plist file to the desktop

PLEASE help as these files are vital to my thesis which is due next month! (and if anyone could help with my Word problem also, that would be fab!)
 
Upgrade to 2011 maybe????

I was running Excel 2008 under Snow Leopard and it crashed fairly regularly. A few months ago I upgraded to Excel 2011 and it is much sturdier, it hasn't crashed once (yet!!!).

Is there anyone you can send your file to that uses 2011 to see if it works?
 
Plus, they only appear on the 'recently opened' tab, and I cannot find them where I originally saved them, even if I use spotlight etc.

I think this your problem. Your computer things the files are GONE.

Do you have a backup of this important data?

You might try repairing the disk using disk utlity, then disk warrior, then some kind of data recover program
 
Under 'disk usage' it says I have 41.28 GB.

Unfortunately no back up - silly I know!

I don't know anyone with office 2011, and seeing as I cannot locate the file aywhere else but on the recent files menu, I cannot send it anywhere.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.