1
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
Christa
Posted 2016-08-25T09:07:38.233
Reputation: 11
1Do hyperlinks to other files / locations work? Does the file open correctly if you open it from its folder? – Máté Juhász – 2016-08-25T09:12:32.183
1What error do you get? – Raystafarian – 2016-08-25T10:51:23.523
Yes an hyperlink direct to the second excel spreadsheet works (the same spreadsheet the shortcut refers to): Excel opens the spreadsheet fine. Also I made tests using the C: drive to avoid any UNC / path related problems, so the issue occurs with all files in the C: drive. There is no error when I try the hyperlink to the shorcut, just Excel is not responsive for some time (like if it was busy), then you can edit the original spreadsheet, but after some time Excel just hangs .. like if the hyperlink opening was still processing in the background and never completing. – Christa – 2016-08-25T14:36:22.097
Indeed in our environment, I tested with all Excel 2010, 2013, 2016 and got the same result for all three – Christa – 2016-08-25T15:03:50.593
Try opening both spreadsheets first and then verify link works without issue. IF it works, then may need to go into security center and enable external links – bvaughn – 2016-08-25T22:22:00.540