OK - I've inherited a spreadsheet with a pivot table
I can trace all the pivot table fields to the headings in another worksheet, except one of them. There is a field shown in the list I can't find in any worksheet. HOw do I go about finding where the field data is.
Does seem to be any hidden column ot worksheets that might hold it.
Reason for asking is - insupplying new data this field has a whole heap more values and I don't know where they are coming from. They are playing havoc with the Pivot tables