Forum Discussion
Solved
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 automatica...
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.
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.