Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying my hand at making a pivot table. When I go to Data/Pivot Table
and Pivot Chart Report, it is grayed out. Is it is because it is "read only"
and shared. Are there any other ways to make reports in excel 2000. Thanks
 
You can't create a pivot table in a shared workbook. You could create
the pivot table in a different workbook, and use the data from the
shared workbook as the source.
 
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

Duplicating Pivot Chart / Changing Pivot Chart data range 4
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table filter list - listing irrelevant subcategorys 1
Issue with pivot table 1
Pivot Table Refresh? 2
Pivot Chart Trendline? 0
Pivot Table - Changes 5
Pivot tables - Editing the data source shared by multiple pivot ta 1

Back
Top