I have an Excel spreadsheet that contains a hyperlink to a (file-)shortcut to another Excel spreadsheet. The shortcut is meant to easily change the target spreadsheet (roll over new versions for example). When I click on the hyperlink Excel seems to be broken, it displays the hourglass, doesn't open the second spreadsheet, works partially then finishes by failing. I use Excel 2016 from Office 365. Is this a known bug ? Thanks
I just had this problem and happened to stumble on the solution. Shortcut files have a hidden file extension, ".lnk" which you'll need to include at the end of the target filename. That's it!