Louis was wondering if it’s “possible to make a hyperlink in Excel that will always link to the folder in which the file is presently saved”? I had a free minute to give it a whirl and it looks like it’s indeed possible:

To get the location of the folder your spreadsheet is in try this:

=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)

Then just add a basic hyperlink, substituting the location with the previous formula:

=HYPERLINK(MID(CELL("filename"),1,
FIND("[",CELL("filename"))-1),"Current Folder")

Viola! You now have a hyperlink in your worksheet, that when clicked will open the current folder (reminds me of the vba open dialog box).

Note: The second example has a line break in it. If you are copying and pasting, make sure that formula is all on 1 line.