Pivot table greyed out in Data menu

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

I would like to create a pivot table, but on this particular spreadsheet the
command is grayed out on the Data menu. How can I convince Excel to allow me
to use it? The only anomaly I see is in the title bar it has [Shared] after
file name. If this is my problem, how do I get rid of it?
 
Tools|share workbook|Editting tab
uncheck all/any names.


You may want to look at Shared workbooks in excel's help to see what was
happening. (Multiple users update the workbook at the same time.)

Fred said:
I would like to create a pivot table, but on this particular spreadsheet the
command is grayed out on the Data menu. How can I convince Excel to allow me
to use it? The only anomaly I see is in the title bar it has [Shared] after
file name. If this is my problem, how do I get rid of it?
Click to expand...
 
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
Display No Data in Pivot 1
Pivot Tables 1
Pivot Tables & data changes 6
Data Validation Menu Greyed Out? 5
Pivot Table Grayed Out 1
Pivot Table - Changes 5
date filter in a pivot table 1

Back
Top