You might try to force an absolute recalculation of the spreadsheet by
simultaneously pressing CTRL-ALT-F9.

In the latest version of Excel you can rebuild the entire recalculation
tree press CTRL-ALT-SHIFT-F9. This should be necessary only once (if
you save the rebuilt sheet).

That might get you past the non-responsive issue. Good luck with it!