Excel Hyperlinks stop working intermittently -

Currently working with macros in an Excel 2010 spreadsheet, and hyperlinks to other cells / tabs in the same document (a topic Page linking for other sheets).

Hyperlinks work for a short time (maybe a day or two) without any problems, but hyperlinks will not work if the file is reopened. Hovering over a hyperlink cell gives you a file tip that has a file path and file name but it seems that the sheet and cell reference is lost.

Did anyone else have to face it and got any solutions?

Thank you.