So Excel lets you create hyperlinks from cell text (right-click, hyperlink), ok. What if you have several thousand files somewhere on your intranet? (e.g. \\servername\sharename\file500.xls, file501.xls, etc) and you want one file list in a spreadsheet to hyperlink to all of them. (e.g. FILE500 as a hyperlink) You don't wanna manualy create hyperlinks for 1000 cells! Is there a more automated way of doing this?