How can I make a hyperlink from Google Spreadsheet cell to an Excel file? For example the hyperlink is in Google Spreadsheet and opens the Excel file. The Excel file is on the hard disk not on Google Drive.
It looks to me that this isn't possible to do directly on a Google Sheets cell I tried to use the the file:// URL protocol but it isn't automatically converted to a link and the Ctrl+k and HYPERLINK built-in function don't work.
I tried on Windows 10 64bit, Chrome 69 and Internet Explorer 11.
One alternative could be to use Google Apps Script to create a custom dialog or sidebar. For details please checkout https://developers.google.com/apps-script/guides/dialogs
NOTE: I think that only Internet Explorer will be able to open an Excel file directly on Excel from a
From the answer to How to specify a local file within html using the file: scheme?
URL. So you would need
file:///home/User/2ndFile.html(on most Unixes),
file:///Users/User/2ndFile.html(on Mac OS X), or