Pivot Table option is grayed out

S

Sue

I am unable to select the Pivot table option under the Data menu. I was able
to use it the other day.
 
T

Tom Hutchins

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
 
Top