Hi folks,

Bit of a problem with a pivot table in XL2003.

When I right-click any cell in the table and attempt to use the structured selection commands - i.e. right-click > choose "Select" > then either "Label", "Data", "Label & Data" or "Entire Table" - those four selection commands are greyed out.

The last command ("Enable selection") is not greyed out, and clicking it enables/disables the option as usual. Whenever this option is disabled and subsequently re-enabled, the selection changes to cover the field which contains the currently active cell (label AND data) but the 4 selection commands mentioned above are still greyed out.

The worksheet is not protected, nor is the pivot table auto-formatted.

Any ideas?