MS Excel- how big is safe?

Factual Questions
1

I have an MS Excel spreadsheet that I have been working on for several years. It isn’t really that big-740K-but it is all numbers and links. Recently opening in Excel X on the Mac causes Excel to crash. restarting Excel allows me to open the file without problems. My question is: are there any guidelines/rules for determining when an Excel sprdsht is getting dangerously big?

thanks

2

I am a business systems analyst/developer and I regularly use Excel spreadsheets that are over 100mb and they generally work just fine. However, Excel is a very powerful tool but it still has more bugs and kinks than any major piece of software that I know of. I have found numerous true bugs myself over the years and we have very important spreadsheets go corrupt on a regular basis and the best minds can’t figure it out. We had a 100mb spreadsheet get corrupted yesterday as a matter of fact and I got a call to consult on it. I found no reason yet again so we restored from our ample backups.

Your spreadsheet is very small in size so that isn’t the problem but keep backups in case something goes wrong.

3

/sidetrack
i wonder if it’s possible to crash google spreadsheets the same way, or would it just take forever to load?

4

Anecdotally:

I work with fairly large spreadsheets (on a PC, not a Mac), although not as large as Shagnasty does. Spreadsheets that had a lot of calculations caused Excel to slow, and sometimes crash.

One of the symptoms was what (I think) rbroome is seeing: I could open the file by first starting Excel, and then opening the file, but I couldn’t start the file in Excel in one go.

The solution was getting more system memory–I doubled the memory size, and the problems went away. Everything opened fine, and recalcs that formerly took minutes now took less than a second.

5

Thanks all.
I figured the raw size of the file wouldn’t be an issue but didn’t know for sure. I certainly do keep multiple backups. About the only thing that the spreadsheet does that is unusual for me is that it has a long list of variable names (100s). A holdover from when I first created it. It seemed like a good idea at the time.
But I will continue to rely on backups and when Excel crashes, restart the app.