need a fix for this error in DDE data

Untitled 2.jpg

when i run the workbook, the formula keeps return "='MT4'|BID!USDCAd" instead of "='MT4'|BID!USDCAD" which cause a N/A in the result, i try to corrrect the "d" in the formula to "D", but it keeps getting back to "d",

How to change the UDF names?

Open VBE (Visual Basic Editor) by pressing Alt+F11 you will finfd on the left list of projects - locate one with your workbook name. Expand modules, search them for problematic function names and change them to something new like
all appearences (shall be at lest two - in function declaration and at least once in assigning value to return) USDCAd to USDCAd_UDF (or other name)
Then do search and replace in your workbook and in formulas also do identical replacement.

Glad to hear that, and thanks for marking thread solved and for the reputation