If Excel stops responding when switching between worksheets, follow the suggestions in this post to resolve the problem without losing data.

Auto Recover saves unsaved Excel files when the system shuts down. If Excel Excel Auto Recover is not working, take these steps to fix the issue.