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:
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.