Analysis Toolpack add-in gets disabled

[Bogdan]

I'm wondering why every now and then the Analysis Toolpack add-in gets
disabled.
I'm using the =weeknum() function which then returns #NAME.When I manually
uncheck & recheck the add-in from the menu is does work again. That's the
axactly the point, I don't want to this manually over and over again.

BTW, I do not open the workbook using automation.

Does anyone know how the fix this symption?

Thanks,
Bogdan

 

[David Biddulph]

It's a known bug, but I don't know of an explanation, nor of a way of
avoiding it.