I have enabled XLA Add-in as follows
- Go to Developer->Excel Add-ins
- Browse XLA Add-in, for example C:\data\MyAddin.xla
- It will show a check mark for MyAddin after completion
Now, I perform the following steps
- Launch Excel (Office 365 or MSO 2016)
- Use UDF available in my XLA Add-in, for example =UDFDemo(A1,A2)
- UDF gets evaluated
- Save and close the Excel Workbook
- Reopen the same Excel Workbook
- UDF shows #NAME! as the cell value with formula as ='\storage1\data\MyAddin.xla'!UDFDemo(A1,A2)
Next, I performed the following steps:
- Click on Data->Edit Links
- The dialog shows the location \storage1\data\MyAddin.xla for the source MyAddin
- Click on 'Change Source' and browse C:\data\MyAddin.xla
- The UDF gets reevaluated in the background, but the dialog still shows the location \storage1\data\MyAddin.xla for the source MyAddin
- Click on 'Close'
- As the UDF is reevaluated, save and close the Excel Workbook
- Reopen the same Excel Workbook
- UDF shows #NAME! as the cell value with formula as ='\storage1\data\MyAddin.xla'!UDFDemo(A1,A2)
I am unable to understand why Excel is looking for '\storage1\data\MyAddin.xla' when I had enabled 'C:\data\MyAddin.xla' from Developer->Excel Add-in
I am also unable to understand why Excel is not changing the location of the source when I use "Change Source' in Data->Edit links
If I perform the above steps on a different machine, the UDF is getting evaluated without any #NAME! error.