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.

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.