Excel Links to Multiple Individual Files Keep Changing Location

I have a blanket workbook for vendors that the City I work for to keep track on all the separate purchase orders, their amounts and remaining balance open. I have the files scanned after the purchases and on stored on server designated to our department ("L" drive)(ex. file:///\\ch-fs01\Public_Works\Purchasing\Blank Invoices\2022\walmart po85040 usb for sewer jet.pdf).

A couple times this year for some reason the links change from the L drive location to "C:\Users\blinhart\AppData\Roaming\Microsoft\Excel" and the name of the linked file remains the same, which of course no longer work since the files are not stored in this folder. (ex. C:\Users\blinhart\AppData\Roaming\Microsoft\Excel\Blanket Invoices\2022\walmart po85040 usb for sewer jet 011822.pdf).

Is there something I am doing incorrectly when I am inserting each link at the time of each purchase? I am currently right clicking on each cell and inserting the hyperlink, but I fear I may be doing this incorrectly maybe? I tried to save a copy of the "Blanket" file on an external drive in case this happen again since it is very time consuming to repair all the broken links, but that file changed also. Any ideas on how to fix or what I am doing wrong would be greatly appreciated. Thanks

Ok, I will do some research on this because not sure how to do a VBA code tag. Thanks for the advice.

I used this instead, it worked
Dim h As Hyperlink
Dim sOld As String
Dim sNew As String

sOld = "C:\Users\lmack\AppData\Roaming\Microsoft"
sNew = "\\newlink"
For Each h In ActiveSheet.Hyperlinks
If InStr(1, h.Address, sOld) Then
h.Address = Replace(h.Address, sOld, sNew)
End If
Next h
End Sub