| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table option is grayed out
I am unable to select the Pivot table option under the Data menu. I was able
to use it the other day. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table option is grayed out
Is the workbook you are working in today a shared workbook? In a shared
workbook, you can view existing pivot tables, but you cannot create new pivot tables or edit existing tables. If it is a shared workbook, you have to make it not shared, create or edit your pivot table, then make it shared again. Hope this helps, Hutch "Sue" wrote: I am unable to select the Pivot table option under the Data menu. I was able to use it the other day. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| Pivot Table Refresh option not able to see | Excel Worksheet Functions | |||
| if there an option allow me to appear the item in pivot table as . | Excel Discussion (Misc queries) | |||
| Pivot Table Grayed Out | Excel Discussion (Misc queries) | |||
| unmerge option is grayed out | Excel Discussion (Misc queries) | |||
Linear Mode
