How to link to a specific cell in a specific worksheet in an XLSX file from another XLSX

[LordenFamily]

I have a XLSX spreadsheet that I want to create a link in to another XLSX workbook so it opens at a specific cell in a specific worksheet.I have the format of HYPERLINK that will do this. However, that uses a http:// reference. If I substitute the local drive reference where the file actually resides, Excel opens the workbook (after the "this is dangerous! - Yes/No" question) but fails to open at the specific worksheet- says "Reference is invalid".The format I am using is -=HYPERLINK( "[C:\Users\User\OneDrive\Documents\Utilities\Calcs.xlsx]Detailed costs by month!B5", "click to open more d

Continue reading...