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

If Excel crashes or freezes when running macro, without saving, when opening file from network, copy-pasting, deleting rows, then see this post.