ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Update 2000 Excel hyperlinks to 2003 hyperlinks (https://www.excelbanter.com/excel-worksheet-functions/162980-update-2000-excel-hyperlinks-2003-hyperlinks.html)

lonv155

Update 2000 Excel hyperlinks to 2003 hyperlinks
 
I have a spreadsheet with 20,000 hyperlinks to music files. I formed them
with 2000 Office, but have now upgraded to 2003 Office and find the old
hyperlinks do not work. I would rather not perform 20,000 hyperlinks again.
Also, any hyperlink I enter is in Ariel, and I prefer something else. Help!??

Gary''s Student

Update 2000 Excel hyperlinks to 2003 hyperlinks
 
Fixing the font of entered hyperlinks is easy:

Format Style Hyperlink whatever

Are your hyperlinks Inserted hyperlinks or =HYPERLINK() functions??
--
Gary''s Student - gsnu200750


"lonv155" wrote:

I have a spreadsheet with 20,000 hyperlinks to music files. I formed them
with 2000 Office, but have now upgraded to 2003 Office and find the old
hyperlinks do not work. I would rather not perform 20,000 hyperlinks again.
Also, any hyperlink I enter is in Ariel, and I prefer something else. Help!??


lonv155

Update 2000 Excel hyperlinks to 2003 hyperlinks
 
Hi Gary's Student
Thanks for the font answer. Is now easy for me!
All hyperlinks were inserted. Unfortunately more than 20,000 of them.
Really appreciate your help.
lonv155

"Gary''s Student" wrote:

Fixing the font of entered hyperlinks is easy:

Format Style Hyperlink whatever

Are your hyperlinks Inserted hyperlinks or =HYPERLINK() functions??
--
Gary''s Student - gsnu200750


"lonv155" wrote:

I have a spreadsheet with 20,000 hyperlinks to music files. I formed them
with 2000 Office, but have now upgraded to 2003 Office and find the old
hyperlinks do not work. I would rather not perform 20,000 hyperlinks again.
Also, any hyperlink I enter is in Ariel, and I prefer something else. Help!??


lonv155

Update 2000 Excel hyperlinks to 2003 hyperlinks
 
hyperlinks are inserted. thx for the font answer!

"Gary''s Student" wrote:

Fixing the font of entered hyperlinks is easy:

Format Style Hyperlink whatever

Are your hyperlinks Inserted hyperlinks or =HYPERLINK() functions??
--
Gary''s Student - gsnu200750


"lonv155" wrote:

I have a spreadsheet with 20,000 hyperlinks to music files. I formed them
with 2000 Office, but have now upgraded to 2003 Office and find the old
hyperlinks do not work. I would rather not perform 20,000 hyperlinks again.
Also, any hyperlink I enter is in Ariel, and I prefer something else. Help!??


lonv155

Update 2000 Excel hyperlinks to 2003 hyperlinks
 
I am new at this, so maybe I have already sent this.
Hyperlinks are inserted.
Thanks for the info on fonts!
lonv155

"Gary''s Student" wrote:

Fixing the font of entered hyperlinks is easy:

Format Style Hyperlink whatever

Are your hyperlinks Inserted hyperlinks or =HYPERLINK() functions??
--
Gary''s Student - gsnu200750


"lonv155" wrote:

I have a spreadsheet with 20,000 hyperlinks to music files. I formed them
with 2000 Office, but have now upgraded to 2003 Office and find the old
hyperlinks do not work. I would rather not perform 20,000 hyperlinks again.
Also, any hyperlink I enter is in Ariel, and I prefer something else. Help!??



All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com