Analysis Toolpack add-in gets disabled
 

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

Analysis Toolpack add-in gets disabled
 

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

"Bogdan" wrote in message
...
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