Hello,
I created an add-in (.xlam) in Excel 2007 which has a number of user-defined functions. The add-in was deployed to a shared network folder as read-only so: (a) it could be referenced by multiple users at the same time and (b) we could easily deploy changes.
The individual functions within the add-in have worked properly and have thrown no errors.
The problem we are encountering is the functions often are proceeded by the folder where the add-in is located. So, users enter =GetFinancialValue(A1) -- where GetFinancialValue is a function we created. It initially works fine. Then, when the user closes and reopens the spreadsheet -- or sends it to someone else, the function is proceeded by: '\\servername.net\files\Software\ExcelAddIn\CompAddin.xlam'!GetFinancialValue(a1). The folder name is correct and may be referenced by all users. Why do this folder name occur? This causes the udf to not run and return #VALUE!.
We can resolve this by going into 'Data' --> 'Edit Links' and clicking 'Open Source' -- then everything calcs properly and the folder name is dropped from the udfs. But, the next time we open the file the same issue occurs again. Don't want users to have to do this every time they open a spreadsheet. When we click on 'Check Status' from the same 'Edit Links' dialog it displays 'Source is Open'
Thanks so much for any help you can offer. This is driving us nuts.
Thanks,
Dan
I created an add-in (.xlam) in Excel 2007 which has a number of user-defined functions. The add-in was deployed to a shared network folder as read-only so: (a) it could be referenced by multiple users at the same time and (b) we could easily deploy changes.
The individual functions within the add-in have worked properly and have thrown no errors.
The problem we are encountering is the functions often are proceeded by the folder where the add-in is located. So, users enter =GetFinancialValue(A1) -- where GetFinancialValue is a function we created. It initially works fine. Then, when the user closes and reopens the spreadsheet -- or sends it to someone else, the function is proceeded by: '\\servername.net\files\Software\ExcelAddIn\CompAddin.xlam'!GetFinancialValue(a1). The folder name is correct and may be referenced by all users. Why do this folder name occur? This causes the udf to not run and return #VALUE!.
We can resolve this by going into 'Data' --> 'Edit Links' and clicking 'Open Source' -- then everything calcs properly and the folder name is dropped from the udfs. But, the next time we open the file the same issue occurs again. Don't want users to have to do this every time they open a spreadsheet. When we click on 'Check Status' from the same 'Edit Links' dialog it displays 'Source is Open'
Thanks so much for any help you can offer. This is driving us nuts.
Thanks,
Dan
