Pivot table unavailable on worksheet

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
 
D

Dave Peterson

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