Thank you for writing.
It is not a page field. It is any box contained in the table (row, data,
column etc.) itself. I am simply reading from another sheet (basic columns
with headings) in the workbook. I uninstalled Office 2000 and reinstalled
and it did not correct the problem. I can create a simple new workbook with
only 2 columns and 2 or 3 rows and still, on the Pivot Table, no "Select All"
appears.
Everything is as it should be except the "Select All" is not present. Each
item is listed and has a check in front of it. If I only want to look at say
9 of 100 items, I have to deselect the non targeted 91..and to put them back,
the same is true.
I can take the same workbook and email it to another computer and the
"Select All" will be present on the other machine.
VERY FRUSTRATING! The only thing I can possbily think of is that the AM
that this began, I got an email from someone with a spreadsheet (no pivot
table built) as an attachment and the problem began after opening this
shreadsheet - I didn't notice at the time, because it was just data, but the
next time I went to a previouly created workbook with pivot, the problem was
evident.
I run fully up to date Norton for Anti-Virus. I have since scanned and no
problems were noted.
ANY help....GREATLY APPRECIATED.