Hyperlinks in Excel and elsewhere

[yours2share]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I'm just starting to switch from PC to mac. In general fine, except a string of problems relating to hyperlinks. I use hyperlinks extensively in Word, Excel, emails. In generall I mean hyperlinks that are (say) name of website, with complicated hyperlink behind. I have several key spreadsheets that are virtually all hyperlinks to web sites I need to run my business.

So I immediately hit a problem when I loaded it into the mac and all the links had gone. Is there a way of bringing these in without losing the hyperlinks?

Then I thought I'll try to add them in for the most critical spreadsheet. I found the first web page using Firefox and went to cut and paste the url into the insert hyperlink. But I don't seem to be able to do this. The only way I can do this is to write it in manually which is mad.

I looked around several forums and found little help - most people seem to want to remove hyperlinks! One suggested using Safari instead of Firefox, but this also didn't work. I also tried inserting hyperlinks into Word, but couldn't cut and paste into here either. How do I cut and paste a url into a hyperlink in Excel or Word?

I was also wondering whether to use Entourage or iCal, Mail, Address Book etc. Am I right in thinking that I can't write html emails in Mail? Does this mean that people using Mail can't see hyperlinks that I'm sending. I've used them for so many years it never occurred to me that part of the population wouldn't be able to see them.

Are there any other weird aspects of hyperlinks that I haven't found yet?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I'm just starting to switch from PC to mac. In general fine, except a string
of problems relating to hyperlinks. I use hyperlinks extensively in Word,
Excel, emails. In generall I mean hyperlinks that are (say) name of website,
with complicated hyperlink behind. I have several key spreadsheets that are
virtually all hyperlinks to web sites I need to run my business.

So I immediately hit a problem when I loaded it into the mac and all the links
had gone. Is there a way of bringing these in without losing the hyperlinks?

Then I thought I'll try to add them in for the most critical spreadsheet. I
found the first web page using Firefox and went to cut and paste the url into
the insert hyperlink. But I don't seem to be able to do this. The only way I
can do this is to write it in manually which is mad.

I looked around several forums and found little help - most people seem to
want to remove hyperlinks! One suggested using Safari instead of Firefox, but
this also didn't work. I also tried inserting hyperlinks into Word, but
couldn't cut and paste into here either. How do I cut and paste a url into a
hyperlink in Excel or Word?

I was also wondering whether to use Entourage or iCal, Mail, Address Book etc.
Am I right in thinking that I can't write html emails in Mail? Does this mean
that people using Mail can't see hyperlinks that I'm sending. I've used them
for so many years it never occurred to me that part of the population wouldn't
be able to see them.

Are there any other weird aspects of hyperlinks that I haven't found yet?

You have run into a bug with Excel 2008. If you save your Excel files as
native format (xlsx) the hyperlinks should remain.

 

[yours2share]

Thanks for the reply.

I've tried to save it as .xlsx on my PC but this extension isn't an option. On PC I'm using Office 2003. Tried renaming but wasn't surprised that this couldn't be opened by the Mac. So I'm still stuck.

Still also haven't a clue how you cut and paste urls into the insert hyperlink dialogue. I must be missing something, no-one types out long urls manually, you're bound to get it wrong. Does no-one else do this?

 

[CyberTaz]

You're correct - Office 2003 files cannot create OOXML files & it isn't just
a matter of changing the extension.

To paste into the Insert Hyperlink dialog use the keyboard command -
Command+V. Depending on which browser you use you may be able to paste
directly into a cell & retain the hyperlink formatting - Firefox yes, Safari
no - without having to use the dialog at all.

HTH |:>)
Bob Jones
[MVP] Office:Mac