Pivot Table option is grayed out

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I am unable to select the Pivot table option under the Data menu. I was able
to use it the other day.
 
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
 
You must log in or register to reply here.

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

Pivot table change data source 1
Pivot table filter list - listing irrelevant subcategorys 1
Refresh pivot table on protected sheet 3
Duplicating Pivot Chart / Changing Pivot Chart data range 4
Display No Data in Pivot 1
Question on the occupied field of the pivot table in excel spreadsheet 0
How do I add extra data to a pivot table? 3
Pivot Table Grayed Out 1

Back
Top