[Wonder84lalala]

Any idea how to edit an hyperlink on Excel to open up in a new window? Thanks.

[JBeaucaire]

More info is needed, I suppose, since Hyperlinks in Excel DO open up a separate program unless they're hyperlinks to spots in the same spreadsheet.

Can you supply:

1. Version of Excel you're using
2. An example of WHAT the Hyperlink is linking to:
   
   • A section of the existing Excel spreadsheet
     
     • Sheet
     • Label
     • Defined Range
   • An email address
   • A web page/site

Everything listed above DOES open in a separate program/window except "section of the existing Excel Spreadsheet". Those hyperlinks jump you to the section.

[mdosh01]

With Excel 2003 and IE 7, links open in new tabs but not new windows. If you want a new window, it looks like you'll have to create a VB script per the following:

Hyperlink in Excel Viewed in Browser

"You will need to create a macro and then link a button to the macro. Try this code for the macro:

Sub Link()
ActiveWorkbook.FollowHyperlink Address:= _
"http://www.google.com/", NewWindow:= _
False, AddHistory:=True
Application.WindowState = xlNormal
End Sub

Then create a button in the spreadsheet and link it to that macro. This should open a new window with the url specified (change Google to your desired url)."

[Wonder84lalala]

I have Excel 2003, and I want to edit the hyperlink target in Excel without using macro.

With HTML I can edit the target:

<a href="filename" target="_blank">

With hyperlink in Excel, can I do the same?

Thank you for your help though :-)

[JBeaucaire]

As previously asked, what "target" are you using? An email address? A web site? A spot in the current document? A separate but existing Excel doc?

[Wonder84lalala]

I'm targeting a separate but existing Excel doc (either save as .xls or .html).

Example:

=HYPERLINK("C:\Test\MyFile.xls","MyFile")

[JBeaucaire]

Ok, this needs to be fixed in your computer settings, not Excel.

1. Close Excel
2. Open My Computer
3. Go to Tools > Folder Options > File Types
4. Scroll down and choose XLS in the list of file types
5. Click on Advanced
6. Uncheck the Browse in same window box
7. In the Actions section, highlight Open
8. Click on Edit
9. Make sure in the Action box it says &Open
10. Make sure in the Application used to perform action it says:
    "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "%1"
11. Check the box next to Use DDE
12. Remove anything that is in DDE Message box and DDE Application Not Running box
13. Make sure the Application box says: Excel
14. In the Topic box it says: System
15. Click on OK > OK > Apply/Close to save your changes.

You've just taught your computer to open every new file in a separate window, a separate instance of Excel.

Now open you file and click on a link to another file. It should open in another window. If you have Excel maximized, that might not be evident at first.

[Wonder84lalala]

Appreciated for your help, JB!

Thanks :D

[mayavi555]

here is my solution:

=HYPERLINK("javascript:window.open('www.google.com ');void(0)", "New Window")