It’s Internal Control Procedure time again and you have all your procedures in Word, trying to hyperlink to excel files. All is well, you Insert \ Hyperlink (or right-click \ Hyperlink), select the destination file and you’re done. BUT, it doesn’t really open where you want it. To make sure it opens at the right cell, add the following to your file path: #’SheetName’!CellAddress, as in #Sheet1!A.
You can of course, update the text to display so it doesn’t show the whole path. Check out screenshot below.
Thanks Benjamin for this suggestion,
Try it, you might like it.