# =FUNCRES.XLAM!\_xldudf\_EVEONLINE\_ / xldudf\_EVEONLINE\_ Errors and maybe a fix **URL:** \ **Category:** EVE x Microsoft Excel Add-in\ **Created:** [December 19, 2023, 9:58am UTC](https://forums.eveonline.com/t/funcres-xlam-xldudf-eveonline-xldudf-eveonline-errors-and-maybe-a-fix/433082 "2023-12-19T09:58:06Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [December 19, 2023, 9:58am UTC](https://forums.eveonline.com/t/funcres-xlam-xldudf-eveonline-xldudf-eveonline-errors-and-maybe-a-fix/433082/1 "2023-12-19T09:58:06Z")
If you get the functions replaced by xldudf\_EVEONLINE\_ on desktop we figured out a way to help with it. If a mac user with a similar issue can test it out too that’d be great. Basically go to Options → Addins ![image](https://global.discourse-cdn.com/eveonline/original/4X/2/6/5/265e601087f86ccf151890f4148072d508ca9619.png) Disable the Analysis Toolpak and the Solve add-in (or all of them) The eve addin does not use any of these that appear in that section, as evident by my own settings. It’s likely a restart of excel is required to unbind the save logic, and potentially a fresh workbook. Please tell us if this helps, so we can add it to the official FAQ. 🙂 ---
**Author:** ![Metastable](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/metastable/32/401992_2.png) [@Metastable](https://forums.eveonline.com/u/Metastable)\ **Post date:** [December 21, 2023, 3:40am UTC](https://forums.eveonline.com/t/funcres-xlam-xldudf-eveonline-xldudf-eveonline-errors-and-maybe-a-fix/433082/2 "2023-12-21T03:40:57Z")
Hello, I have been plagued by funcres lately. When I remove all of the Solver/Analysis Excel Add-ins the formulas will change from the `FUNCRES.XLAM!_` or `=EVEONLINE.functionname` into `'C:\Program Files\Microsoft Office\Root\Office16\LIBRARY\Analysis\FUNCRES.XLAM'!_xldudf_EVEONLINE_functionname` . The only work around I have found so far is removing then reinstalling the add-in each time I reopen my workbook that is affected by this. If I disable the Solver and Analysis add-ins and attempt the same uninstall/reinstall for the add-in there is no change. To test, I built a new workbook and if I open it and disable the ‘Analysis ToolPak’ the add-in functions will append the `'C:\Program Files\Microsoft Office\Root\Office16\LIBRARY\Analysis\FUNCRES.XLAM'!_xldudf_'` to the start of them, even if they were working formulas before. If anyone knows of a workaround to fix this I am desperate for one! Thank you. ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [December 21, 2023, 8:32am UTC](https://forums.eveonline.com/t/funcres-xlam-xldudf-eveonline-xldudf-eveonline-errors-and-maybe-a-fix/433082/3 "2023-12-21T08:32:25Z")
I’ve found the issues in the office-js github and the latest news is that there is a patch late december that might solve this. (It’s been an issue since 2021. Here is the thread for anyone interested in the details, the gist is that the VBA or older addins conflict with the registration of custom functions. > > > Our customers are having trouble when using our Knoema Data Finder add-in with a…nother add-in from Excel, f. e. ‘Euro Currency tools’. > > \## Your Environment > PC, Excel, Microsoft 365 Version 2107(Build 14228.20250) 64 bit, Windows 10 > > \## Steps to reproduce > 1. Create the new file. > 2. Install Knoema Data Finder add-in > 3. Insert custom function KNOEMA.VERSION() > 4. Go to Insert -\> My Add-ins -\> Manage Other Add-ins -\> Add-ins -\> Go -\> Select Euro Currency tools > > After the above steps, we have the error message “One or more add-ins failed to install custom functions” and our Add-in becomes unloaded and custom functions of our add-in in the file have a strange naming: instead of “KNOEMA.VERSION()” we see “\_xldudf\_KNOEMA\_VERSION()”. And when we execute the functions we have “#NAME?” error in a cell. > Note not all Excel add-ins from the list cause error, Also our customers use theirs own same add-ins some of them also cause an error. And after reopen the file all works fine. > !\[image\](https://user-images.githubusercontent.com/51117293/129545005-62bca604-600e-4dfe-b67a-86e1f5c84cf5.png) > !\[image\](https://user-images.githubusercontent.com/51117293/129545030-7885ff4a-bd0b-48ac-9454-f092486194a3.png) > !\[image\](https://user-images.githubusercontent.com/51117293/129545060-d7e06d7c-a354-46b7-a7eb-42725ea0e756.png) > > > \## Useful logs > \[OfficeAddins.log.txt\](https://github.com/OfficeDev/office-js/files/6991348/OfficeAddins.log.txt) It’s possible that doing “Reload” might fix any formulas in the sheet that are corrupted like this. (You have to hover around that top spot and hit the arrow on the sidebar, it’s an “i” button in mac) ![image](https://global.discourse-cdn.com/eveonline/original/4X/6/6/5/6654c77b95b49553b3a008c4bfc91234b5c32e99.png) ---
**Author:** ![OldGuyMonty](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/oldguymonty/32/428927_2.png) [@OldGuyMonty](https://forums.eveonline.com/u/OldGuyMonty)\ **Post date:** [December 28, 2023, 12:29am UTC](https://forums.eveonline.com/t/funcres-xlam-xldudf-eveonline-xldudf-eveonline-errors-and-maybe-a-fix/433082/4 "2023-12-28T00:29:40Z")
> [@Metastable](#): > > `'C:\Program Files\Microsoft Office\Root\Office16\LIBRARY\Analysis\FUNCRES.XLAM'!_xldudf_EVEONLINE_` My workaround was to do a mass find replace of `C:\Program Files\Microsoft Office\Root\Office16\LIBRARY\Analysis\FUNCRES.XLAM'!_xldudf_EVEONLINE_` with `EVEONLINE.` I even resorted to a small macro that I could run on the tab to just do it automatically. I haven’t seen the issue since disabling the Analysis Toolpack and Solver Addins though. ---
**Author:** ![Metastable](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/metastable/32/401992_2.png) [@Metastable](https://forums.eveonline.com/u/Metastable)\ **Post date:** [January 2, 2024, 3:43pm UTC](https://forums.eveonline.com/t/funcres-xlam-xldudf-eveonline-xldudf-eveonline-errors-and-maybe-a-fix/433082/5 "2024-01-02T15:43:45Z")
Hi y’all, hope your holidays went well. I ended up stumbling upon a similar approach to what OldGuyMonty has suggested and it has worked for me so far. I first disabled all of the unnecessary addins from excel then went through and removed all of the broken appended text to the fomulas. Once everything was in `EVEONLINE.` format, I saved a copy of the workbook and was able to close & reopen it without and further issues. Thanks for the help! ---
**Author:** ![evilphoenix](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/evilphoenix/32/439989_2.png) [@evilphoenix](https://forums.eveonline.com/u/evilphoenix)\ **Post date:** [January 4, 2024, 1:44am UTC](https://forums.eveonline.com/t/funcres-xlam-xldudf-eveonline-xldudf-eveonline-errors-and-maybe-a-fix/433082/6 "2024-01-04T01:44:33Z")
I didn’t have the other addons enabled. Tried a blank workbook as well. Still broken. ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [January 6, 2024, 3:55pm UTC](https://forums.eveonline.com/t/funcres-xlam-xldudf-eveonline-xldudf-eveonline-errors-and-maybe-a-fix/433082/7 "2024-01-06T15:55:40Z")
Microsoft released a fix for new workbooks in this patch. \>=16.0.17126.20064. Anyone encountering it can try to update and see if it happens. > “The fix already released to CC(preview) version, please check if you are on Insider and Office version \>=16.0.17126.20064.”