If spreadsheet cell has a hyperlink to another spreadsheet, clicking the link will not open the spreadsheet. I just get the spinning(?) blue circle. If the referenced spreadsheet is already open, clicking the link brings it to the front. This has been verified on a MacMini and an MBP both running the latest version of Yosemite. If I change Windows default programs to use Mac Excel 2011, clicking the link will open the spreadsheet in the host OS. The issue is not present on a W8.1 laptop using Excel 2013. The problem doesn't occur if I use Mac Excel 2011 only. Maybe a trust issue on W8.1? I haven't found a way to resolve the problem. Anyone have any ideas about how to fix.
