Excel not recognizing Add-In Function names... sometimes

Hey guys,

I'm testing an add-in I created and I ran into this weird problem: While developing the add-in, I had the work-in-progress VBA code stored in a particular excel file. Now that I verified that all the code works, and made it all into and Add-In, I wanted to test it on the same "test" file I was using before.
So with the add-in properly installed, I go into the "test" file, remove its existing VBA module (with the rough draft code), and attempt to call the new Add-In functions from the worksheet. Most of them work as expected, but a few others return the #NAME? error when called. I was confused by this inconsistency, so I decided to test all the functions in a blank workbook... and they all worked perfectly. I test further by calling the functions from a different "test" sheet (after deleting its existing VBA module), and none of the functions work on that one.

WTH is going on??

Thanks BradC,

I played around with it, and there is no rhyme or reason as to why and to what extent this occurs. You workaround works fine, so problem solved I guess..