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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Power Pivot. Yikes. 0
Pivot Table cell values 1
Write back from pivot table 1

Top