software

A problem has started coming up with EOMONTH, which I've been using
successfully for years. Lately, when I drill down into the function
arguments, EOMONTH works fine, but at any other level (i.e IF(EOMONTH...,
etc, or even just =EOMONTH(... ) it produces a #NAME! error, in spreadsheets
that used to work fine just a month or two ago on this very PC. I am using a
registered copy of Excel 2002, with both the Analysis and VBA Analysis
ToolPaks added in, and have installed Office XP SP3. Any ideas? (And yes,
I've tried reinstalling the Add-Ins, closing and reopening the spreadsheet,
etc.)


Some details and example would help..--
Infinity
------------------------------------------------------------------------
Infinity's Profile: www.excelforum.com/member.php...oamp;userid=32725
View this thread: www.excelforum.com/showthread...hreadid=528431Hi,

Directly form Excel's help files:

quot;If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.quot;

Go to Tools, Addin's and select the Analysis ToolPak

Sean

quot;puppetheadquot; gt; wrote in message
...
gt;A problem has started coming up with EOMONTH, which I've been using
gt; successfully for years. Lately, when I drill down into the function
gt; arguments, EOMONTH works fine, but at any other level (i.e IF(EOMONTH...,
gt; etc, or even just =EOMONTH(... ) it produces a #NAME! error, in
gt; spreadsheets
gt; that used to work fine just a month or two ago on this very PC. I am
gt; using a
gt; registered copy of Excel 2002, with both the Analysis and VBA Analysis
gt; ToolPaks added in, and have installed Office XP SP3. Any ideas? (And
gt; yes,
gt; I've tried reinstalling the Add-Ins, closing and reopening the
gt; spreadsheet,
gt; etc.)