Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default Unable to see add-in buttons in Excel 2007

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Unable to see add-in buttons in Excel 2007

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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Unable to see add-in buttons in Excel 2007

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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Unable to see add-in buttons in Excel 2007

I'd double check to make sure you actually enabled that addin.

At the bottom of that Addin section (under the office button|excel options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default Unable to see add-in buttons in Excel 2007

Hi Dave
Thanks for replying. It is enabled, but I don't see an button anywhere.
Where should it be? Is there a tools menus somewhere, or something under the
data tab?
--
Charles


"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that addin.

At the bottom of that Addin section (under the office button|excel options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Unable to see add-in buttons in Excel 2007

It wasn't a button. It was just on that Data Ribbon to the far right. At least
it shows up there for me--in the Analysis section/Group.

Charles wrote:

Hi Dave
Thanks for replying. It is enabled, but I don't see an button anywhere.
Where should it be? Is there a tools menus somewhere, or something under the
data tab?
--
Charles

"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that addin.

At the bottom of that Addin section (under the office button|excel options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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


--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Unable to see add-in buttons in Excel 2007

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



  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Unable to see add-in buttons in Excel 2007

Yep, same place for me when I have the ATP Addin ticked

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
It wasn't a button. It was just on that Data Ribbon to the far right.
At least
it shows up there for me--in the Analysis section/Group.

Charles wrote:

Hi Dave
Thanks for replying. It is enabled, but I don't see an button
anywhere.
Where should it be? Is there a tools menus somewhere, or something
under the
data tab?
--
Charles

"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that addin.

At the bottom of that Addin section (under the office button|excel
options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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


--

Dave Peterson



  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Unable to see add-in buttons in Excel 2007

Good. I don't use xl2007 enough to know if I have that special copy yet <vbg.

Roger Govier wrote:

Yep, same place for me when I have the ATP Addin ticked

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
It wasn't a button. It was just on that Data Ribbon to the far right.
At least
it shows up there for me--in the Analysis section/Group.

Charles wrote:

Hi Dave
Thanks for replying. It is enabled, but I don't see an button
anywhere.
Where should it be? Is there a tools menus somewhere, or something
under the
data tab?
--
Charles

"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that addin.

At the bottom of that Addin section (under the office button|excel
options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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


--

Dave Peterson


--

Dave Peterson
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Unable to see add-in buttons in Excel 2007

And there was me thinking you always had special copies - how else can
you come up with all those wonderful solutions<vbg

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
Good. I don't use xl2007 enough to know if I have that special copy
yet <vbg.

Roger Govier wrote:

Yep, same place for me when I have the ATP Addin ticked

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
It wasn't a button. It was just on that Data Ribbon to the far
right.
At least
it shows up there for me--in the Analysis section/Group.

Charles wrote:

Hi Dave
Thanks for replying. It is enabled, but I don't see an button
anywhere.
Where should it be? Is there a tools menus somewhere, or something
under the
data tab?
--
Charles

"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that addin.

At the bottom of that Addin section (under the office
button|excel
options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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


--

Dave Peterson


--

Dave Peterson





  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Unable to see add-in buttons in Excel 2007

Every once in a while, I can't replicate something that occurs to someone else
with the same version of excel. That scares me (or makes me feel special)
<vbg.

And I've saved lots of posts from others. I just snip out the From's and add my
name!

Roger Govier wrote:

And there was me thinking you always had special copies - how else can
you come up with all those wonderful solutions<vbg

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
Good. I don't use xl2007 enough to know if I have that special copy
yet <vbg.

Roger Govier wrote:

Yep, same place for me when I have the ATP Addin ticked

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
It wasn't a button. It was just on that Data Ribbon to the far
right.
At least
it shows up there for me--in the Analysis section/Group.

Charles wrote:

Hi Dave
Thanks for replying. It is enabled, but I don't see an button
anywhere.
Where should it be? Is there a tools menus somewhere, or something
under the
data tab?
--
Charles

"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that addin.

At the bottom of that Addin section (under the office
button|excel
options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default Unable to see add-in buttons in Excel 2007

Thanks. This is all most odd. I do not have that. I wonder if it is a
consequence of having both 2003 and 2007 on the same machine. THe add-in
(significance analysis of microarrays) still works in 2003, but doesn't
appear in 2007. Looks like I will have to move completely to 2007 alone to
see if that is the case. A bit loth to do so though.
--
Charles


"Dave Peterson" wrote:

Every once in a while, I can't replicate something that occurs to someone else
with the same version of excel. That scares me (or makes me feel special)
<vbg.

And I've saved lots of posts from others. I just snip out the From's and add my
name!

Roger Govier wrote:

And there was me thinking you always had special copies - how else can
you come up with all those wonderful solutions<vbg

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
Good. I don't use xl2007 enough to know if I have that special copy
yet <vbg.

Roger Govier wrote:

Yep, same place for me when I have the ATP Addin ticked

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
It wasn't a button. It was just on that Data Ribbon to the far
right.
At least
it shows up there for me--in the Analysis section/Group.

Charles wrote:

Hi Dave
Thanks for replying. It is enabled, but I don't see an button
anywhere.
Where should it be? Is there a tools menus somewhere, or something
under the
data tab?
--
Charles

"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that addin.

At the bottom of that Addin section (under the office
button|excel
options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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


--

Dave Peterson

--

Dave Peterson


--

Dave Peterson

  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Unable to see add-in buttons in Excel 2007

Hi Charles

I have all versions of XL loaded on the same machine.
Data Analysis on both 2003 and 2007 show the same 19 different types of
analysis.

THe add-in (significance analysis of microarrays) still works in 2003,
but doesn't

appear in 2007

I don't know what this is, but I do not see anything of that name in
Data Analysis on either version.
Maybe it was part of some additional add-in you have in 2003.

--
Regards

Roger Govier


"Charles" wrote in message
...
Thanks. This is all most odd. I do not have that. I wonder if it is a
consequence of having both 2003 and 2007 on the same machine. THe
add-in
(significance analysis of microarrays) still works in 2003, but
doesn't
appear in 2007. Looks like I will have to move completely to 2007
alone to
see if that is the case. A bit loth to do so though.
--
Charles


"Dave Peterson" wrote:

Every once in a while, I can't replicate something that occurs to
someone else
with the same version of excel. That scares me (or makes me feel
special)
<vbg.

And I've saved lots of posts from others. I just snip out the From's
and add my
name!

Roger Govier wrote:

And there was me thinking you always had special copies - how else
can
you come up with all those wonderful solutions<vbg

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
Good. I don't use xl2007 enough to know if I have that special
copy
yet <vbg.

Roger Govier wrote:

Yep, same place for me when I have the ATP Addin ticked

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
It wasn't a button. It was just on that Data Ribbon to the
far
right.
At least
it shows up there for me--in the Analysis section/Group.

Charles wrote:

Hi Dave
Thanks for replying. It is enabled, but I don't see an button
anywhere.
Where should it be? Is there a tools menus somewhere, or
something
under the
data tab?
--
Charles

"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that
addin.

At the bottom of that Addin section (under the office
button|excel
options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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


--

Dave Peterson

--

Dave Peterson


--

Dave Peterson



  #14   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default Unable to see add-in buttons in Excel 2007

Roger
So where do you see the analysis features? When I click on my Data tab, I
have "Get external data", "Connections", "Sort and Filter", "Data Tools" and
"outline" panes, but no "analysis". THe "Data tools" has "Text to columns",
Remove duplicates", "data validation", "consolidate" and "what if analysis".
SHould there be some other pane?

Alternatively, can you give me the name of an addin you are seeing, that I
can load, and I'll see if I can load it?

Charles
--
Charles


"Roger Govier" wrote:

Hi Charles

I have all versions of XL loaded on the same machine.
Data Analysis on both 2003 and 2007 show the same 19 different types of
analysis.

THe add-in (significance analysis of microarrays) still works in 2003,
but doesn't

appear in 2007

I don't know what this is, but I do not see anything of that name in
Data Analysis on either version.
Maybe it was part of some additional add-in you have in 2003.

--
Regards

Roger Govier


"Charles" wrote in message
...
Thanks. This is all most odd. I do not have that. I wonder if it is a
consequence of having both 2003 and 2007 on the same machine. THe
add-in
(significance analysis of microarrays) still works in 2003, but
doesn't
appear in 2007. Looks like I will have to move completely to 2007
alone to
see if that is the case. A bit loth to do so though.
--
Charles


"Dave Peterson" wrote:

Every once in a while, I can't replicate something that occurs to
someone else
with the same version of excel. That scares me (or makes me feel
special)
<vbg.

And I've saved lots of posts from others. I just snip out the From's
and add my
name!

Roger Govier wrote:

And there was me thinking you always had special copies - how else
can
you come up with all those wonderful solutions<vbg

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
Good. I don't use xl2007 enough to know if I have that special
copy
yet <vbg.

Roger Govier wrote:

Yep, same place for me when I have the ATP Addin ticked

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
It wasn't a button. It was just on that Data Ribbon to the
far
right.
At least
it shows up there for me--in the Analysis section/Group.

Charles wrote:

Hi Dave
Thanks for replying. It is enabled, but I don't see an button
anywhere.
Where should it be? Is there a tools menus somewhere, or
something
under the
data tab?
--
Charles

"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that
addin.

At the bottom of that Addin section (under the office
button|excel
options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't enabled???

Charles wrote:

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


--

Dave Peterson

--

Dave Peterson

--

Dave Peterson




  #15   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Unable to see add-in buttons in Excel 2007

Charles the Data tab for me (and surprisingly for Dave<bg) has the
following sections.
Get External Data, Connections, Sort & Filter, Data Tools, Outline,
Analysis

Under Round Office buttonExcel Options
Addinsat bottom of page Click Go, when Manage "Excel Add ins" is
showing in dropdown

This will give the normal dialogue box you see under ToolsAddins in
Xl2003.
Ensure Analysis Toolpak is ticked, (and Analysis Toolpak VBA is ticked
on my copy).

Then you should see the Data Analysis section.
--

Regards

Roger Govier


"Charles" wrote in message
...
Roger
So where do you see the analysis features? When I click on my Data
tab, I
have "Get external data", "Connections", "Sort and Filter", "Data
Tools" and
"outline" panes, but no "analysis". THe "Data tools" has "Text to
columns",
Remove duplicates", "data validation", "consolidate" and "what if
analysis".
SHould there be some other pane?

Alternatively, can you give me the name of an addin you are seeing,
that I
can load, and I'll see if I can load it?

Charles
--
Charles


"Roger Govier" wrote:

Hi Charles

I have all versions of XL loaded on the same machine.
Data Analysis on both 2003 and 2007 show the same 19 different types
of
analysis.

THe add-in (significance analysis of microarrays) still works in
2003,
but doesn't

appear in 2007

I don't know what this is, but I do not see anything of that name in
Data Analysis on either version.
Maybe it was part of some additional add-in you have in 2003.

--
Regards

Roger Govier


"Charles" wrote in message
...
Thanks. This is all most odd. I do not have that. I wonder if it is
a
consequence of having both 2003 and 2007 on the same machine. THe
add-in
(significance analysis of microarrays) still works in 2003, but
doesn't
appear in 2007. Looks like I will have to move completely to 2007
alone to
see if that is the case. A bit loth to do so though.
--
Charles


"Dave Peterson" wrote:

Every once in a while, I can't replicate something that occurs to
someone else
with the same version of excel. That scares me (or makes me feel
special)
<vbg.

And I've saved lots of posts from others. I just snip out the
From's
and add my
name!

Roger Govier wrote:

And there was me thinking you always had special copies - how
else
can
you come up with all those wonderful solutions<vbg

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
Good. I don't use xl2007 enough to know if I have that
special
copy
yet <vbg.

Roger Govier wrote:

Yep, same place for me when I have the ATP Addin ticked

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
It wasn't a button. It was just on that Data Ribbon to the
far
right.
At least
it shows up there for me--in the Analysis section/Group.

Charles wrote:

Hi Dave
Thanks for replying. It is enabled, but I don't see an
button
anywhere.
Where should it be? Is there a tools menus somewhere, or
something
under the
data tab?
--
Charles

"Dave Peterson" wrote:

I'd double check to make sure you actually enabled that
addin.

At the bottom of that Addin section (under the office
button|excel
options) is a
button that you use to manage the addins.

Maybe the addin was in the list, but it wasn't
enabled???

Charles wrote:

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


--

Dave Peterson

--

Dave Peterson

--

Dave Peterson






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to open some 2003 files in Excel 2007 ChrisW (MCP) Setting up and Configuration of Excel 0 April 19th 07 02:10 PM
EXcel 2007 - Unable to sort by font and cell colors Mr. Low Excel Worksheet Functions 1 October 28th 06 03:49 PM
Excel Beta 2007 on PC: unable to handle very large workbooks? Victor Excel Discussion (Misc queries) 1 October 5th 06 12:31 PM
In Excel 2007 Unable to view or print text box [email protected] Excel Discussion (Misc queries) 2 September 27th 06 02:55 PM
Excel 2007 - unable to copy chart [email protected] Charts and Charting in Excel 2 September 15th 06 11:39 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"