ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   xls 2007 ribbon (https://www.excelbanter.com/excel-discussion-misc-queries/190955-xls-2007-ribbon.html)

oldLearner57

xls 2007 ribbon
 
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

Jim Rech

xls 2007 ribbon
 
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



oldLearner57

xls 2007 ribbon
 
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





All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com