I'm running into issues including formulas/links into an Excel file stored on SharePoint. As soon as I download the Excel file locally to my desktop SharePoint adjusts the formulas to use the server relative path of the worksheet. For Example:
=BLP($B25,G$46) will change to this: ='https://.com/blp\API\dde\Blp.xla'!BLP($B52,G$46)
Any ideas how to prevent this from happening? I'm running this on SharePoint Foundation 2010 and have access to the server if need be. Any help would be appreciated.