By setting it to something non-existent, it will force hyperlink to be absolute link at all times.
I.E. will always have full file path.
Ex: \\Servername\folder\file.xlsx instead of somthing like .\folder\file.xlsx. Which is relative link. Based on workbook location.

Correct, by using absolute link either by above method or using Hyperlink function, Excel will always use network drive location and will not adjust link path to your local folder.