![]() |
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 |
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 |
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