Forum Discussion
Help with an Excel problem. Link files automatically
Hello I have an excel document that is several thousand rows long. Each row has a unique name. That name corresponds with a file located in a share drive. I want to know if its possible to automatically create a hyperlink to said files based on the cell values. The user will enter into a cell, a name. That name will than ideally display a hyperlink to the word document. For example if the user enters the letter A, it should open document A , stored on the shared drive. I am a complete newbie so please dumb it down for me. Thank you. Currently my professor told me to manually create the hyperlink. I have done roughly 400 but there has to be a better way. Thank you.
Make sure that the resulting path+filename is correct. I assumed that column A will contain the document name without the extension .docx, so the formula adds it.
If column A already contains the extension, remove &".docx" from the formula.
4 Replies
I'd use two columns: one with the file names and another with the hyperlinks:
- Never-mind it worked perfectly. I just had to restart excel. Thank you again.
- Thank you! You saved me probably a semester worth of manually linking. The links were all created but the word document does not open like the manual one do. Do you know why that may be?
Make sure that the resulting path+filename is correct. I assumed that column A will contain the document name without the extension .docx, so the formula adds it.
If column A already contains the extension, remove &".docx" from the formula.
