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?
Bookmarks