Create bulk relative hyperlinks

I'm not sure I understand correctly, or more accurately I'm probably not explaining clearly. I'll break down the process I've undertaken thus far and hopefully will give a clear indication of my goal.

I'm using software to scan PDF files which are invoices, then producing spreadsheets which capture relevant information from those invoices (invoice number, date, total, tax etc), at the end of this process I will have a master spread sheet which lists all 3000 odd invoices with this information. This software also allows the archival of the original PDF document and it creates a corresponding entry in the spread sheet with the path to where this document is stored on the local computer. In this instance the path in the cell (K2 to be exact) is "M:/Client/SmartSoft/Archives/9134444.pdf".

I'm trying to create a hyperlink for these files that ignores the "M:/Client/Smartsoft" part of the path and simply looks for a folder "Archives" in the same root directory that the spread sheet resides. I can accomplish this using "right click, hyperlink" option for the cells containing the path (k2, k3 etc) one at a time then editing the hyperlink and removing the first part of the path. However doing that one at a time would take many days/weeks, in addition I can't edit hyperlinks in the same fashion that are created using a formula unlike those created with the 'right click' method which can be edited.

I confess I don't understand how to use oeldere's suggested "d4=CELL("filename"), when I use this formula (without the d4) it simply populates the cell with the path and name to the spread sheet.

Your suggestion vlady does indeed produce a working hyperlink which behaves the same as "=hyperlink(k2)" that I'm currently using, so I'm obviously not understanding the process here. However as I didn't have the CELL formula anywhere my use was =hyperlink("File:////"&$k$2,"click").

I'm sorry I'm obviously missing something here, my understanding of this stuff is fairly basic