Hi,

I have been working with pivot table for 10 years. I am now in Excel 2007
and I am trying to create a pivot table off of a range of data that has some
query data and a column of data that is accessed through vlookup. No matter
what I do, I can NOT get the addtional column to show up as an available
field for the pivot table. It seems like it is being "too smart"...any
suggestions? This will be a huge problem for us...we often have to
consolidate a lot of data before we roll up.

Thanks