HYPERLINK formula link to local file unreliable
Bug: The hyperlink formula linking to a local file seems unreliable. there are two issues
1. Even with "Confirm before opening other applications" preference disabled, clicking on a hyperlink cell seems to always ask for user confirmation with a warning.
2. Sometimes Excel will "get in a mess" and after the warning has been accepted give a very generic error message of failure. Once this error has occurred, closing and re-opening spreadsheet or any other spreadsheet will suffer same problems and you need to exit Excel and re-run for t to start working again.
n.b. Always used to work fine in Excel (for Mac) 2008 (the previous version I used) - on same spreadsheet