View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default YEAR function name not found

I'm having a problem with a function on a colleague's computer. The
following formula...
=YEAR(H6)
works find on my computer but returns a Name Not Found error on her
computer (Excel 2002, SP3). She states that she receives a message
when opening the file asking if she wants to update links. There are
no links in the workbook!

She does have the Analysis ToolPak add-in installed and the formula
=WEEKNUM(H6) works fine.

What's up? Isn't YEAR a standard function?

Thanks for the help.

- John