1

Much like this question but I want to be able to insert a Hyperlink into one sheet that opens another sheet in a new window.

P.S. Using Excel 2007

Community
  • 1
OldCurmudgeon
  • 307

1 Answers1

1

Found it!

First you must do what is said in the question I linked to to make normal sheets open in separate windows. Then you can use:

=HYPERLINK("excel /e '\\Path\File.xlsx'","Open the file")
OldCurmudgeon
  • 307