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

If hyperlinks are not opening or working properly in Microsoft Excel, ensure that the target file is not changed and follow these fixes.