Hyperlinks & Web Publishing

[cwhaley]

I really like that way that Microsoft is building more and more
interactivity with the web into desktop Excel. My main complaint in
previous posts is that the MS Excel Mac team isn't moving fast enough
in that direction compared to the Windows Excel team. Web Queries are
my biggest gripe there.

This time my question is a little more mundane, but the solution is
evading me at the moment.

I have a spreadsheet where some of the columns contain hyperlinks to
various web pages. Rather than using those links from my desktop file,
though, I'm using Save as Web Page and uploading the resulting file to
my internet server where I can access it from other pages at my web
site. So far, so good.

Once installed, I want clicks on links to open new windows (or tabs).
What's happening now is that the current window is replaced by the
linked window.

I know this is beginning to sound more like a general HTML question
than an Excel one, but I'd like to modify my hyperlinks within Excel
so that they'll do the "new page" trick once the sheet is saved as a
web page and FTP'd to my server.

Within my WYSIWYG web design software, I just click a check box to get
that option. I never actually see the code.


....Charles

 

[JE McGimpsey]

Once installed, I want clicks on links to open new windows (or tabs).
What's happening now is that the current window is replaced by the
linked window.

Surely that should be up to the user, shouldn't it? I *HATE* having
designers decide that I should have a new window open when I'd rather
use the current window or open a new tab in the current window.

Choosing between those options is just a matter of the user's
preferences or using a modifier key when selecting the hyperlink...

FWIW, the "target" attribute for links is deprecated in HTML4 Strict and
XHTML. Not that XL's output validates...