UDF category is not updating in Function List

[verckensr]

Hi there,

My company has created an Excel Add-In (.xla file) with vba code in order to create our own functions.
Each function is placed in a category so it can be selected from the Function List.

My colleague has made a mistake in the category name for one function, so now we're faced with 1 function that stands out of the rest...

When I update the Category attribute of Application.MacroOptions, to align with the rest of the functions, it still doesn't group with the others.

Here's a piece of the code...

Public Sub FunctionsHelp()
Application.MacroOptions Macro:="DESCR_G", Description:="Return the General account description." & vbCrLf & "Parameters : General_Account = The General account (Number or Abbreviation)", Category:="EASI Financials - Base"
Application.MacroOptions Macro:="DESCR_A1", Description:="Return the Analytical account description." & vbCrLf & "Parameters : A1 = The Analytical account (Number or Abbreviation)", Category:="EASI Financials - Base"
...


So basically both functions "DESCR_G" and "DESCR_A1" should show up in the category "EASI Financials - Base"...
Unfortunately, the first one still shows up in the old category "EASI Financials - Basics" (which is not visible here).

Is there anyway to auto-refresh the Functions List in MS Excel so function categories are automatically updated?

- Xla can be used in MS Excel 2010 and 2013 (same problem)
- I've already de-activated the Add-In then re-activating it

Thanks in advance for your assistance.
Regards.
VerckensR