If excel thinks there are links, I bet there are.

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

If it's not an existing name causing the trouble, then maybe there's a user
defined function with that name.

I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager to search for any hidden names.

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp



John Michl wrote:

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

--

Dave Peterson