Pivot table unavailable on worksheet

  • Thread starter Thread starter johnb
  • Start date Start date
J

johnb

I have a workbook with 2 sheets both with a 2 dimension
tables on each(without blank row or cols). On sheet1 the
Pivot table is not available(dimmed out), in other words I
cannot greate a Pivot table based on this data. While
sheet2 Pivot tables works find.

Anyone seen this before? What causes it?

Regards johnb
 
The first place I'd look is Tools|Protect. See if the worksheet is protected.
 

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

Back
Top