I am using Excel 2013 to create a function called Interpolate. This function is located in a module associated with the xlsm file I am using. The function is working well however, when I close the workbook and open it again the function has the wrong location prepended to the function name. For example:
Before closing:
"=interpolate(stuff)"
After closing and opening:
"'C:\Program Files\Microsoft Office 15\Root\Office15\LIBRARY\Analysis\FUNCRES.XLAM'!interpolate(stuff)"
I know that FUNCRES.XLAM is associated with the analysis tool pack, (which I have used but since removed) but I have no idea why it is being added to my function name. That's not where the function is located. Please help! I didnt think that you needed to add the functions location in the formula if it was local. Thanks.
Bookmarks