hyperlinks path changes without notice in a excel workbook

[eXtremer]

Hello,

We have an excel workbook with data that contains hyperlinks (path to a shared network path). Only one person has write access that adds new data and hyperlinks. I don't know why but from time to time the hyperlinks broke down, the path is changing. The person who works with this excel workbook doesn't understand why it happens and what she is doing wrong, me neither so I could help her. She is opening the excel file from a network path, makes changes and saves it, that's it.

Here is and example of the correct path: \\192.168.1.60\db\files\scan\incoming\2022\04\1297.pdf
And here is the path it changes too (wrong one): C:\Users\Reception\AppData\Roaming\Microsoft\Excel\scan\incoming\2022\04\1297.pdf

Could you tell me please why does this happen? and what to do so it never happens.

Thank you.

 

[jkpieterse]

One fix will require some rework (depending on how many links there are). If you put the location and filenames as text in a regular (column of) cell(s), you can use the HYPERLINK function to create the hyperlinks dynamically. Those hyperlinks will not break, as the file location and names are stored as plain text.

 

[eXtremer]

One fix will require some rework (depending on how many links there are). If you put the location and filenames as text in a regular (column of) cell(s), you can use the HYPERLINK function to create the hyperlinks dynamically. Those hyperlinks will not break, as the file location and names are stored as plain text.

Can you show me an example please? Thank you.

 

[jkpieterse]

With the full path and file name in cell A1, this formula gives you a hyperlink which displayes "Link text" in the cell:

=HYPERLINK("file:"&A1,"Link text")