hi community

when i open out my xls 2007 in my comp and select the tab (Data), it
displayed out six groups:

Get External Data
Connection
Sort & Filter
Data Tools
Outline
Analysis

but when I open the xls 2007 excel in my laptop and goes to the same tab
(Data)
it only display:

Get External Data
Connections
Sort & Filter
Data Tools
Outline

but no "Analysis" grp

tried going into Option and find out to insert but only able to insert into
the Access Toolbar, what i want is inside the Ribbon....

can anyone kindly englighten to me why is it that in my laptop, the Analysis
group is not being display if wishes for it, how can i do it?


thanks community for the help

:)

--
oldLearner57

For "Analysis" you have to load the Analysis Toolpak add-in. Office menu -
Excel Options - Add-ins and hit the Go button at the bottom..

--
Jim
"oldLearner57" wrote in message
...
| hi community
|
| when i open out my xls 2007 in my comp and select the tab (Data), it
| displayed out six groups:
|
| Get External Data
| Connection
| Sort & Filter
| Data Tools
| Outline
| Analysis
|
| but when I open the xls 2007 excel in my laptop and goes to the same tab
| (Data)
| it only display:
|
| Get External Data
| Connections
| Sort & Filter
| Data Tools
| Outline
|
| but no "Analysis" grp
|
| tried going into Option and find out to insert but only able to insert
into
| the Access Toolbar, what i want is inside the Ribbon....
|
| can anyone kindly englighten to me why is it that in my laptop, the
Analysis
| group is not being display if wishes for it, how can i do it?
|
|
| thanks community for the help
|
| :)
|
| --
| oldLearner57

thanks Jim Rech, now i recalled I did the Add-in

thanks community as well

:)
--
oldLearner57


"Jim Rech" wrote:

For "Analysis" you have to load the Analysis Toolpak add-in. Office menu -
Excel Options - Add-ins and hit the Go button at the bottom..

--
Jim
"oldLearner57" wrote in message
...
| hi community
|
| when i open out my xls 2007 in my comp and select the tab (Data), it
| displayed out six groups:
|
| Get External Data
| Connection
| Sort & Filter
| Data Tools
| Outline
| Analysis
|
| but when I open the xls 2007 excel in my laptop and goes to the same tab
| (Data)
| it only display:
|
| Get External Data
| Connections
| Sort & Filter
| Data Tools
| Outline
|
| but no "Analysis" grp
|
| tried going into Option and find out to insert but only able to insert
into
| the Access Toolbar, what i want is inside the Ribbon....
|
| can anyone kindly englighten to me why is it that in my laptop, the
Analysis
| group is not being display if wishes for it, how can i do it?
|
|
| thanks community for the help
|
| :)
|
| --
| oldLearner57