software

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.

- JohnIt would appear that the quot;datequot; in H6 might be the result of a Named Range
that does not exist.........perhaps a type-O?

Vaya con Dios,
Chuck, CABGx3quot;John Michlquot; wrote:

gt; I'm having a problem with a function on a colleague's computer. The
gt; following formula...
gt; =YEAR(H6)
gt; works find on my computer but returns a Name Not Found error on her
gt; computer (Excel 2002, SP3). She states that she receives a message
gt; when opening the file asking if she wants to update links. There are
gt; no links in the workbook!
gt;
gt; She does have the Analysis ToolPak add-in installed and the formula
gt; =WEEKNUM(H6) works fine.
gt;
gt; What's up? Isn't YEAR a standard function?
gt;
gt; Thanks for the help.
gt;
gt; - John
gt;
gt;

Thanks Chuck but I don't think that is the case. The spreadsheet works
fine on my computer. This would lead me to believe it is a settings
issue on the other computer. Is there an add-in or setting that might
impact the year function?

- JohnI know of nothing that might affect just the YEAR function........Maybe the
formula in H6 is lookig for a value in another workbook that does not exist
on your user's computer...........

Vaya con Dios,
Chuck, CABGx3

quot;John Michlquot; wrote:

gt; Thanks Chuck but I don't think that is the case. The spreadsheet works
gt; fine on my computer. This would lead me to believe it is a settings
gt; issue on the other computer. Is there an add-in or setting that might
gt; impact the year function?
gt;
gt; - John
gt;
gt;

Figured it out. I'm not sure why by both the ATP and ATP - VBA add-ins
need to be installed. I was able to replicate the problem on another
computer that did not have Analysis ToolPak - VBA installed. I noticed
that the formula included the full path to the add-in. I installed the
add-in and all is fine. I'm going to post a message on the programming
forum and search for some understanding of the issue.

Problem solved but not understood!

- JohnIf excel thinks there are links, I bet there are.

When I can't find links, I'll use Bill Manville's FindLink program:
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 www.oaltd.co.uk/mvp
John Michl wrote:
gt;
gt; I'm having a problem with a function on a colleague's computer. The
gt; following formula...
gt; =YEAR(H6)
gt; works find on my computer but returns a Name Not Found error on her
gt; computer (Excel 2002, SP3). She states that she receives a message
gt; when opening the file asking if she wants to update links. There are
gt; no links in the workbook!
gt;
gt; She does have the Analysis ToolPak add-in installed and the formula
gt; =WEEKNUM(H6) works fine.
gt;
gt; What's up? Isn't YEAR a standard function?
gt;
gt; Thanks for the help.
gt;
gt; - John

--

Dave Peterson

Apparently the link is to the Excel Analysis ToolPak - VBA addin. That
is what shows in the Edit Links dialog box. I don't know why since I'm
not calling any functions that would need it.

- John