First, you have to try to find out why it's freezing.
Easiest first: Close excel and clean up your windows temp folder.
If that doesn't help:
Does it happen with all your workbooks or just one?
If it happens with all of your workbooks, one of the usual culprits is a
corrupted .xlb file (that's where excel stores customized toolbar settings).
close excel
windows start button|find/search for *.xlb
rename them to *.xlbOLD
and try it normally again. If it worked ok, then dump those *.xlbOLD files
and recreate your toolbars at your leisure.
If it didn't help, rename them back to *.xlb and see if there's something else
that's causing the trouble.
If xl freezes with just that one file, you can try starting excel in Safe mode:
close excel
windows start button|run
excel /safe
Then try opening your workbook. (Safe mode stops excel from doing lots of
stuff--including running macros.
If you workbook opens ok in safe mode, maybe it's a misbehaving macro. I'd ask
the developer to take a look.
Here's a link that points at Chip Pearson's notes to help diagnose startup
problems:
http://www.cpearson.com/excel/StartupErrors.htm
Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)
Then one by one, you'll add one back and restart excel to see if that caused the
problem.
