keyongtech


  keyongtech > excel.* > excel.worksheet.functions > 10/2007

 #1  
10-22-07, 05:49 AM
lonv155
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!??
 #2  
10-22-07, 10:46 AM
Gary''s Student
Fixing the font of entered hyperlinks is easy:

Format > Style > Hyperlink > whatever

Are your hyperlinks Inserted hyperlinks or =HYPERLINK() functions??
 #3  
10-22-07, 10:35 PM
lonv155
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:
[..]
 #4  
10-25-07, 05:47 AM
lonv155
hyperlinks are inserted. thx for the font answer!

"Gary''s Student" wrote:
[..]
 #5  
10-25-07, 05:51 AM
lonv155
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:
[..]
Similar Threads
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up !

Email hyperlinks pop up as I try to access each cell. I've tried turning off hyperlinks (TOOLS: AUTOCORRECT: AUTOFORMAT AS YOU TYPE. Under REPLACE AS YOU TYPE, I have...

Hyperlinks in Excel 2000

Using Excel 2000 I have a workbook with 15 sheets. On each sheet there is a hyperlink to the same location on the intranet. If I open the book on sheet 1 and click on the...

Excel Hyperlinks- cell content v. hyperlinks

I have a column containing company names. Each company name has the hyperlink address to the company website. This is shown in the ScreenTip when the mouse is hovered over...

hyperlinks & email - Excel 2000

Hi, I'm trying to fill out an email automatically, but can't get past the 'To: " part. Clicking an email hyperlink opens Outlook Express & a compose mail with the "To:"...

Excel 2000 Hyperlinks

Probably a silly question, but how do you turn off hyperlinks? I know how to remove them, but I want the entire feature turned off so that when I type an email address it...


All times are GMT. The time now is 07:09 AM. | Privacy Policy