1,066 questions
Excel Add-in #NAME error, it appends FUNCRES.XLAM'! in start of custom function names in formulas
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 40%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kashif Bashir Bhatti
36
Reputation points
have an excel add-in containing custom functions built using JavaScript. Sometimes when user opens a sheet containing these custom functions, excel does not correctly show formulas. It appends "FUNCRES.XLAM'!xldudf" or "='C:\Program Files (x86)\Microsoft Office\root\Office16\LIBRARY\Analysis\FUNCRES.XLAM'!xldudf" in start of custom function, resulting in #NAME error. If I have a custom function named "Test", then all existing formula are shown as "=FUNCRES.XLAM'!_xldudf_Test" or sometimes as "='C:\Program Files (x86)\Microsoft Office\root\Office16\LIBRARY\Analysis\FUNCRES.XLAM'!_xldudf_Test".
Also if I add custom function to a new cell, it is recognized as correct formula and returns correct result. But if I save this sheet and re-open it then newly added formula is also shown as "#NAME" Error as described above.
Sometimes this error is resolved by restarting excel or computer, but I want to know the reason for this error and how to avoid this.
Microsoft 365 and Office Development Office JavaScript API
Microsoft 365 and Office Development Other
4,375 questions
Microsoft 365 and Office Excel For business Windows
3,888 questions
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 68%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWJ%3C/text%3E%3C/svg%3E)
Wade James 21 Reputation points2023-08-21T19:30:35.4766667+00:00 We have the same problem. If a business user has Solver or Analysis Pack add-ins enabled and opens an excel file already using our custom excel add-in our cell functions get corrupted in the same manner (when saved). The excel file has no dependency on the solver or analysis add-in.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 86%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
David Chesnut 166 Reputation points Microsoft Employee2023-08-22T15:47:25.63+00:00 Thanks Kashif and Wade for reporting this issue. Is there a simple set of steps to reproduce this behavior? I tried enabling the Analysis Pack add-in, but didn't see this behavior. Thanks!
-
Kashif Bashir Bhatti 36 Reputation points
2023-08-22T16:12:14.45+00:00 David, it happens when we open a saved file containing custom functions (not always, but sometimes). if Analysis ToolPak is disabled, "='C:\Program Files (x86)\Microsoft Office\root\Office16\LIBRARY\Analysis\FUNCRES.XLAM'!*xldudf" is appended at start of function name and when Analysis ToolPak is enabled, only "='FUNCRES.XLAM'!*xldudf" appended.
Also note that workbook/add-in does not use Analysis Pack add-in, and does not depend on it or require it to work.
-
Wade James 21 Reputation points
2023-08-22T16:31:55.9266667+00:00 Our user experience is we have excel files with custom functions that get updated with a parameter on a daily basis. They were created without solver or analysis pack add-in (there is no link). If a user has either solver or analysis pack enabled, opens the sheet, recalculates, and then saves the file it will append the reference to the SOLVER.XLAM or FUNCRES.XLAM with "!xldudf_" to our custom function name. To reproduce the problem I enable the addin and save the file with the custom functions, which creates the link. If I break the excel link the cell functions are removed and the user has to redo the cells.
Sign in to comment
Sign in to answer