Hi All,

I have a spreadsheet saved as a web page. The hyperlinks I have on this are opening in the same window. If this were a web application, I could go into HTML view and change the hyperlinks to target=0 and they would open in a new window when clicked, right?
However, Excel formats the webpage using xml, I believe (which I know little about) and I cannot change the hyperlink behavior. I tried importing into a different application, GoLive shows the xml data, and I dont want to mess it up. FrontPage shows the webpage like if it were created in fronpage, but it messes up the formatting.
So I can find no way to change the hyperlink value to set it to open in a new window.. The page is embedded in another page so when the links open, they show in a "frame" rather than whole...

Any suggestions?

Steve

This is what I tried and it worked for me.
Add target="_new" to the end of the link in source view of the html
<a href="http://www.utteraccess.com/forums/index.php?Cat=" target="_new" >Utter Access Discussion Forums - Access Help Center Index</a>

HTH

I cant seem to access the source in excel. Are you in excel when you access that source?

Here's a quick test I did to replicate ... this is some of the source Excel generates...
I can view source with Notepad after the webpage is saved.

</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t75"
href="http://www.dell.com/" style='position:absolute;margin-left:0;
margin-top:0;width:150pt;height:50.25pt;z-index:1' o:button="t">
<v:fill o:detectmouseclick="t"/>
<v:imagedata src="webpage_files/image001.png" o:title="OEMLOGO"/>
<x:ClientData ObjectType="Pict">
<x:SizeWithCells/>
<x:CF>Bitmap</x:CF>
<x:AutoPict/>
</x:ClientData>
</v:shape><![endif]--><![if !vml]><span style='mso-ignore:vglayout'>
<table cellpadding=0 cellspacing=0>
<tr>
<td width=0 height=0></td>
</tr>
<tr>
<td></td>

I am not sure where I would tell it to open a new window. I see the hyperlink, but the <a> tag is not here... I'm just not experienced enough to tackle this code.
(the hyperlink is on a picture not text, would that be why this code looks different to me?)

Steve

Try this:

</v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t75"
href="http://www.dell.com/" target="_new" style='position:absolute;margin-left:0;
margin-top:0;width:150pt;height:50.25pt;z-index:1' o:button="t">

It seems to be located here when dealing with an image(shape).

HTH

Edited by: Grove on 06.23.04.
I did the changes in Notepad.

I will try it this evening. Thanks a lot. I'll let you know how it goes...

Steve