0

I currently have a spreadsheet call it master.xls thats contains hyperlinks to worksheets in other spreadsheets for example worksheet called 'LHA' in spreadsheet child23.xls

Now, say I click hyperlink in A2 cell in master.xls for this sheet. It should open child23.xls and worksheet 'LHA'. But, instead it opens the last saved worksheet in child23.xls.

Hyperlink example:

child23.xls#'LHA'!A1

I have tried office repair but weirdly cannot fix this issue. Would anyone have any idea how I can solve this?

enter image description here

4
  • How are the hyperlinks created? See link.
    – harrymc
    Sep 30, 2021 at 13:46
  • You can provide a screenshot about the hyperlink in Sheet.
    – Lee
    Oct 1, 2021 at 6:07
  • Harrymc - via right click and insert link. Oct 1, 2021 at 14:19
  • Lee - will do now Oct 1, 2021 at 14:19

0

You must log in to answer this question.

Browse other questions tagged .