 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / April 2008HYPERLINK issues
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? > How come when I format cells to hyperlink I have to cut and past the link > into [quoted text clipped - 4 lines] > 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 My document is a XLSX format and this is still occurring? On 4/10/08 3:33 PM, in article 100420081533161038%maser@umich.edu, "Steve Maser" <maser@umich.edu> wrote: >> > How come when I format cells to hyperlink I have to cut and past the link >> > into [quoted text clipped - 15 lines] > > - Steve > 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 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?? On 4/29/08 6:52 AM, in article ee9818a.3@webcrossing.caR9absDaxw, "milou" <amsterdam@experimentadesign.nl> wrote: > 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.  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom 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! 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! Signature------------------------------------------------------------------------ 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 |pjones@kimbanet.com, ICQ11269732, AIM pjonescet ------------------------------------------------------------------------ If it's "fixed", don't "break it"! mailto:pjones@kimbanet.com <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> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.