Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Jun 8 '11 at 16:38

This question came from our site for professional and enthusiast programmers.

    
Just noticed the Pivot table tools - lists the field as an "Active Field" is that the clue? –  Malc Jun 8 '11 at 16:27
    
is it a calculated summary field? –  datatoo Jun 8 '11 at 16:52

2 Answers 2

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

share|improve this answer

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

share|improve this answer
    
And no it's not a calcuulated field - thanks for the suggestion tho. Not something I'd checked –  Malc Jun 9 '11 at 14:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.