Excel 2000-Inherited workbook ;Cant find where column data coming from

[mhansler]

Hello, I've inherited a workbook from a former colleague.
This workbook has 7 worksheets; of which, 3 are charts, 3 are pivot tables and one is for the rawdata. The rawdata is pulled via Microsoft Query from a Oracle database. There is nothing in the query that references to two additional fields that appear on the rawdata worksheet after the columns are updated via the external data link. There are no formulas in these two columns. The sheets are unprotected. When I right click on charts the data source option is greyed out. There no scripts, no vb and only one macro. The macro only refreshes the pivot tables. When I unhide formulas I see the formats behind the cells but no formulas. When I access the pivot wizard to see where it's getting its range of data from nothing is hightlighted. I created a new ODBC connection and recreated the Microsoft Query and the two additional columns do not appear. Does anyone have any ideas that will help me determine what is going on with this workbook? Thank you.

 

[rdodge]

If you can't find the information that you looking for through the normal means and you know how to work with the VBA Debugging tools, you can use the Watch Window efficiently. When all else fails, I have used the Watch window to find anything and everything that I could on an object. Sometimes, this can be a longer process cause it does show all or nearly all of the related objects and properties

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.