Excel pivot table - missing fields

Question

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

Answer 1

Check to see if there is a connection to an external data source. Go to your ribbon, Data tab, select Connections. In the dialog box it will list all connections to external data sources, and if you click on one, it will tell you where the connection is used.

Mike

Answer 2

Thanks for the reply

There is a connection to a filtered web page sort - if you see what I mean. However I can't see the the field in there either. I suspect step one is to filter the data on the web page and then refresh the data. I don't however know what the expected filter is.

I ran refresh and it totally snafu'ed it - I suspect there is some post refresh data tidy up.

I think I need to hunt down the creator of the spreadsheet