ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot Find Pivot Table Tool in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/144315-cannot-find-pivot-table-tool-excel-2007-a.html)

Frank Barrena

Cannot Find Pivot Table Tool in Excel 2007
 
I just installed Office 2007.

This is very silly, but I can't find the Pivot Table command in the new
"ribbon" from Excel, and I can't see the traditional menus.

I had to personalize the quick access toolbar in order to be able to create
a pivot table.

Can anybody tell me how to enable the old-style menus, or make the pivot
table command appear in the ribbon?
--
Frank Barrena

Nick Hodge

Cannot Find Pivot Table Tool in Excel 2007
 
Frank

It's Insert TabPivot Table

If you want the old wizard then add the command 'Pivot table and Pivot Chart
wizard' from all commands list box

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Frank Barrena" wrote in message
...
I just installed Office 2007.

This is very silly, but I can't find the Pivot Table command in the new
"ribbon" from Excel, and I can't see the traditional menus.

I had to personalize the quick access toolbar in order to be able to
create
a pivot table.

Can anybody tell me how to enable the old-style menus, or make the pivot
table command appear in the ribbon?
--
Frank Barrena



Shailesh Shah

Cannot Find Pivot Table Tool in Excel 2007
 
In addition you may see below link,

http://office.microsoft.com/en-us/ex...491511033.aspx


to download workbook showing location of excel-2003 menu in excel-2007.
http://office.microsoft.com/search/r...1 00860481033

In case you want to use excel-2003 menu in excel-2007, email me, you can
use my free addins excel-2003 menu for excel-2007. This will place worksheet
menu, standard toolbar & formatting toolbar in the addins tab.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)


"Frank Barrena" wrote:

I just installed Office 2007.

This is very silly, but I can't find the Pivot Table command in the new
"ribbon" from Excel, and I can't see the traditional menus.

I had to personalize the quick access toolbar in order to be able to create
a pivot table.

Can anybody tell me how to enable the old-style menus, or make the pivot
table command appear in the ribbon?
--
Frank Barrena



All times are GMT +1. The time now is 08:31 AM.

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