View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default =weeknum() - installed the add-in

Go into Toolsaddins and check that the ATP is checked. If not then check
it, if it is uncheck it the check it again to force a re-install.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Marcotte A" wrote in message
...
I've installed the Analysis Toolpack addin and have used the =weeknum()
function in the past. However, this morning when I openned up the
spreadsheet I use it on, I get the #NAME error in that field. This has
happened to me once before, but I forget exactly what I did that solved

the
problem. I've tried saving the spreadsheet and re-openning it, as well as
using the function in a brand new workbook.

I have Windows XP Pro w/ SP2 and Excel 2003.