WEEKNUM gone...

[George]

Yesterday I spent a lot of time modifying a workbook. Everything worked
fine until after rebooting from a windows update. Now every cell with
the function WEEKNUM in it shows the error #NAME. Where did it go and
how can I get it back?

Thanks for the help,
GeoK

 

[George]

Yesterday I spent a lot of time modifying a workbook. Everything worked
fine until after rebooting from a windows update. Now every cell with
the function WEEKNUM in it shows the error #NAME. Where did it go and
how can I get it back?

Thanks for the help,
GeoK

Reinstalled ATP and took care of problem. Anyone like to take a gander
on what happened?

Thanks for the help even though it is purely optional now.
GeoK

 

[Peo Sjoblom]

WEEKNUM is part of the Analysis ToolPak, tools>options>add-ins and if it is
selected clear it, close and restart Excel and select it. If it is not
selected just select it


--


Regards,


Peo Sjoblom

 

[George]

WEEKNUM is part of the Analysis ToolPak, tools>options>add-ins and if it is
selected clear it, close and restart Excel and select it. If it is not
selected just select it

It just happened again. ATP was selected, so I deselected then
reselected it and all is good for now. I have used this formula in
worksheets for several years, why all of sudden is it getting stubborn?

By the way: Excel 2000 SP-3

Thanks for the help,
GeoK