Custom function is not recognized until I click my add-on's dropdown

[Tuan Do]

I am encountering a weird problem. Whenever I open a new file, the custom function of my Google Sheet add-on is not recognized (it shows #NAME?; Unknown function)

In my add-on I have some code which creates add-on dropdown menu on open. From the menu, the users can choose to show the sidebar, refresh all sheets, view documentation, etc.... When they click any option in the menu bar, the custom function is instantly recognized and runs normally without error.

I think Google Sheets only recognize my custom functions when the users start my add-on (by clicking anything in my add-on's dropdown menu). Is there any way to make Google Sheets recognize my custom function on open, without having to click anything

from the menu bar.

Appreciate any help

[Shubh Singla]

I'm having he same problem. Can you please share the solution if you got one?

Thank You.

[Santiago de Urquiza]

Same issue. Although not even showing after I click on the add on menu. It used to work like this, but I added a few new functions and they are not working now.