Problem:
-Excel document as a hard link to a particular location of add in file C:\Program Files\Microsoft Office\Office14\XLSTART
-Calculations calling the function in the addin produce an error #Name unknown text (basically cannot find the file)
What's been tried:
-Creating the XLSTART location and adding xla file there
-creating an mklink from C:\Program Files\Microsoft Office\Office14\XLSTART to C:\Program Files (x86)\Microsoft Office\Office14\XLSTART
-adding C:\Program Files (x86)\Microsoft Office\Office14\ to path
What does work:
Updating the document link to point to C:\Program Files (x86)\Microsoft Office\Office14\XLSTART
Unfortunately not an option due to not all machines running 64bit yet