I have coded this hyperlink formula into a workbook cell.
It works, with the XLSX being opened with the cell on the stated worksheet being selected.
I tested that by saving it with a different cell in that sheet & a different sheet being the active one, then reopening it to verify it wasn't focused on the sheet & cell in the hyperlink before testing the HYPERLINK as coded.
Problem I have is that if the workbook quoted in the hyperlink is already open I get the error message "Cannot open the specified file" and I have to manually Alt-Tab to go to the workbook.
Not exactly arduous, but surely it doesn't need to complain?!?
What change/s to an option / setting, or the formula do I need to make to have Excel go to that workbook/sheet & cell even if it is open?
Excel Formula:
=HYPERLINK( "[C:\Users\User\Documents\Utilities\Calcs.xlsx]'Detailed costs by month'!B5", "click to open more details" )
It works, with the XLSX being opened with the cell on the stated worksheet being selected.
I tested that by saving it with a different cell in that sheet & a different sheet being the active one, then reopening it to verify it wasn't focused on the sheet & cell in the hyperlink before testing the HYPERLINK as coded.
Problem I have is that if the workbook quoted in the hyperlink is already open I get the error message "Cannot open the specified file" and I have to manually Alt-Tab to go to the workbook.
Not exactly arduous, but surely it doesn't need to complain?!?
What change/s to an option / setting, or the formula do I need to make to have Excel go to that workbook/sheet & cell even if it is open?
Attachments
Last edited: