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

A: I would not recommend a macro approach to solving this problem. Instead, you should enable automatic link updates in Excel 2013 by selecting File, Options, Trust Center, Trust Center Settings, ...