HYPERLINK issues

[John Harrison]

How come when I format cells to hyperlink I have to cut and past the link
into
the top field ³link to² when you right click.

Additionally I save the document and then close it then reopen and all the
hyperlinks
do not work because the top field link to is now blank. This never happened
in Office 2004?

 

[Steve Maser]

How come when I format cells to hyperlink I have to cut and past the link
into
the top field ³link to² when you right click.

Additionally I save the document and then close it then reopen and all the
hyperlinks
do not work because the top field link to is now blank. This never happened
in Office 2004?

The only workaround for this (currently) is to save the spreadsheet in
the .xlsx format.

Saving as .xls blows out the hyperlinks.

Hopefully, they'll be releasing a 12.0.2 updater sometime soon to
address this.

- Steve

 

[John Harrison]

My document is a XLSX format and this is still occurring?

 

[Steve Maser]

My document is a XLSX format and this is still occurring?

Not sure. I'm not seeing that here (somebody pointed out the problem
saving as .xls to me earlier this week, so I tried a blank file and
saved something as .xlsx and that stuck for me.)

But a blank file saved as .xls didn't stick (and there's an error when
you open that file indicating that.)

- Steve

 

[milou]

I do have the same problem. I've saved my file as a XLSX, and it still doesn't save my hyperlinks...

What can I do about it??

 

[Bob Greenblatt]

I do have the same problem. I've saved my file as a XLSX, and it still doesn't
save my hyperlinks...

What can I do about it??

The best thing is to keep checking Mactopia, and make sure autoupdate is set
to update automatically.

 

[milou]

thanks!

and I already found the answer!
You shouln't use 'space' in the names of your wanted links. Use underscores or nothing, keep it one word, otherwise it won't be recognised!

 

[Phillip Jones]

Yes despite Windows and Unix proponents saying that they can resolve
Space like the Mac can neither does. If you need to create links that
would work fine on a Mac but are creating html pages and links for UNIX
and Windows Folks to use use underscores.

thanks!

and I already found the answer!
You shouln't use 'space' in the names of your wanted links. Use underscores or nothing, keep it one word, otherwise it won't be recognised!

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>