Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
source data for pivot table 2007
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
source data for pivot table 2007
Debbie Horner wrote:
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 Just a SWAG... See if you can fool the PT into thinking this is not external data. I would try, instead of placing the query at the default $A$1, put it at $B$1. Put a dummy label in $A$1, and your VLOOKUP column to the right of the data as before. Then point the PT at columns A:whatever. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set Excel 2007 pivot table default to not save source dat | Excel Discussion (Misc queries) | |||
View pivot table external data source in Excel 2007 | Excel Discussion (Misc queries) | |||
Pivot table source data | Excel Discussion (Misc queries) | |||
Pivot Table Data Source | Excel Discussion (Misc queries) | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |