Excel 2003 Hyperlink

M

McRibIsBack

I have an Excel sheet with a simple hyperlink. It is uploaded to SharePoint,
so when the user opens the sheet it is opened in a web page (IE6).

My problem is that it won't open in a new page, it takes over the existing
page. How can i force a hyperlink in a cell (or anywhere!) to open in a new
page EVERY time? I've looked at =HYPERLINK() function, but it indicates
nothing on this.

I know this seems silly, but this tool is being used by hundres of users and
I appreciate any help!
 
N

Nastech

try this: paste the following inside of a cell; then click on destination
cell; then type: ),"x")

=HYPERLINK("#"&CELL("address",
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink to web does not return to original Excel worksheet 1
Hyperlink to hidden cells 1
Insert hyperlink ini Excel 1
Activating hyperlinks 3
hidden Hyperlink 1
email hyperlink won't change when cell content changes 2
Excel 2007 to pdf - hyperlink from excel does not work 3
hyperlink 2

Top