How to activate all links in excel?

How do I activate a mass amount of links at once in microsoft excel (2007 version) anyone know?

 

I didn't face this type of problem ever.
I think whenever you open a file with external links it gives options in the beginning.

 

due to the browser memory limit i think its not possible to do that

 

No i don't mean open every link. I mean when you copy and paste a link into excel, it's not a "link" yet. itsjust a buncha words. you gotta activate it for it to become a link =/

 

Well, in word also its not a link all the time. Then I press ENTER after pasting the link and it becomes active.
Try it out.

- Mr.President -

 

yep, but pressing enter each time for 500 links is a pain. I was wondering if anyone knew how to do it all at once

 

I also face the same problem,
I just drag the mouse over the link and it gets alive,
but if there is a method to alive them all at once then that would be great.

 

Place all the URLs without links in Column A.

Type in Column B1, this forumula :

=Hyperlink(A1)

Hit enter.

You can see the link activated URL in column B1
Copy B1 and drag it till end.

You will get the results as per your request!