Format =Hyperlink from Access to Excel

casey

Registered User.
Local time
Today, 17:40
Joined
Dec 5, 2000
Messages
448
A function imports a row of hyperlinks into an Excel spreadsheet that look like text...
=HYPERLINK("https://webistename.aspx?ID=3&WA=1","A110912")

The problem is that they don't act as a hyperlink until I physically click in each cell and hit F2 or <enter>. After that they are displayed as needed. Is there a formatting option that will allow them to behave as hyperlinks without doing this?

Thanks.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom