I have the unfortunate task of creating a time entry system in Microsoft Excel. I have a master workbook that contains the list of employees and templates for the various time sheets. The master workbook has VBA code which creates a new workbook and and adds copies a template for each user before importing data from another system. The template worksheets include cells containing formulas which call custom UDFs that I currently have stored in an Excel Add-In. The purpose for the Add-In is to encapsulate the VBA code in a digitally signed Add-In so the users are not constantly having to "Enable Macros".
Everything works so far, except the UDF references on the templates. Those work fine until the template is copied to the output workbook. Once there, they somehow get converted to links and when the output workbook is opened, Excel is unable to update those links.
Sorry to be verbose. The short question is why does this:
=CustomFunction()
keep turning into this
='C:\Path To Excel Add-In.xla'!CustomFunction
()
and how can I prevent it? The link is unnecessary as the AddIn is available to the output workbook. If I manually go in and remove the file reference, the formulas work again.