Hi Dave

Since I have never used any of the tools from the Data Analysis section,
I had not realised that.
I do have ATP and ATP for VBA checked as a matter of course, but on
previous occasions when I had tried EOMONTH, NETWORKDAYS etc., they
worked fine whether it was checked or not, so I had assumed all was
included by default.

Thank you for correcting me.

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
The functions that were part of the analysis toolpak have been
migrated into
excel.

But the Data|Analysis stuff is still in the addin and that addin has
to be
enabled.



Roger Govier wrote:

Hi Charles

On my XL2007 I see a tab called Addins, and on there I can see a list
of
the Addins I have loaded.
Analysis Toolpak doesn't show up, as it is incorporated into XL2007
by
default.
--
Regards

Roger Govier

"Charles" wrote in message
...
I want to use add-ins in excel 2007 - e.g. Anaylsis toolpak, and
others
for
biostatistics. They are all loaded, as I have verified this in the
Excel
options / Manage Addins dialog. However I can't see them anywhere.
In
Excel
2003 the buttons appeared on the toolbars, or in the data menu.
Microsofts
web site says there should be an "analysis" panel in the Data tab
in
Excel
2007, but there is no such panel I can find. Can anyone help?

Note - this is not an issue in Excel 2003 on the same machine - I
can
still
see the add-in buttons (or access via menus). I am trying to use
them
in 2007
due to the dataset size.
--
Charles

--
Charles

--

Dave Peterson