Pivot Table Grayed Out

G

Guest

I have a spreadsheet of data that I want to use a pivot table with. However,
excel won't let me; when I go to the menu it is grayed out. The pivot table
still works in other windows, but not this one. I can't figure it out. Any
thoughts?

Thanks.
 
D

Debra Dalgleish

If the worksheet is protected, or the workbook is shared, you won't be
able to create a pivot table.
 

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
Refresh pivot table on protected sheet 3
Duplicating Pivot Chart / Changing Pivot Chart data range 4
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table - Changes 5
How do I add extra data to a pivot table? 3
Excel 2007 change data source 1
pivot table data 2

Top