Need formula help for inserting multiple hyperlinks

I am trying to to insert multiple hyperlinks into a spreadsheet and keep getting the message cannot open the specified file. Formula: =HYPERLINK("C:\<Users\Maria\Documents\Custom Office Templates...

excel

Formulas and Functions

IngeborgHawighorst
May 27, 2020
JKangas5 Try stepping through the formula with the Formula Evaluation tool. Does the concatenation of the cells result in the correct path? Are you maybe missing a "\" before the file name? Does the file exist in the location?

The HYPERLINK() function uses two parameters: The first one is the link, the second one is the friendly text that the user clicks on. Your formula doesn't seem to have two parameters.

What's in cell A1?

Try

HYPERLINK("C:\Users\Maria\Documents\Custom Office Templates\Documents\Certificate of Liability Insurance\1901 Inc.pdf","click here for file")

IF that doesn't help, please post a screenshot with more details.

IngeborgHawighorst

MVP

May 27, 2020

JKangas5 Try stepping through the formula with the Formula Evaluation tool. Does the concatenation of the cells result in the correct path? Are you maybe missing a "\" before the file name? Does the file exist in the location?

The HYPERLINK() function uses two parameters: The first one is the link, the second one is the friendly text that the user clicks on. Your formula doesn't seem to have two parameters.

What's in cell A1?

Try

HYPERLINK("C:\Users\Maria\Documents\Custom Office Templates\Documents\Certificate of Liability Insurance\1901 Inc.pdf","click here for file")

IF that doesn't help, please post a screenshot with more details.