Excel links to wrong network location

Hi,

This is my first post on these boards and i generally search for any answers before making a post but this problem has me stumped.

I have a couple of functions in a excel addin file which is located on a network, i have been having this issue on a few spread sheets now and decided to test it on a completely new blank sheet.
The function i am using to test is called "extent" and it is called fine when loaded on one machine, loads fine on another machine, saved it. Load it up on another and the link is completely wrong. It is completely random between machines.

The link it loaded is an old one i have used before that is not in use, but it was not associated with this spreadsheet file in anyway. Is there anyway to force excel not to update these links automatically as the manual option is greyed out.
I can not fathom out why excel puts in this network location.

I have attached some screenshots, the correct network location is \\POD\Drop Boxes\POD_Admin\Addins
hope someone can give me some insight into this problem
Many thanks

Craig
excel-link1.png
excel-link.JPG