Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data Import
Hello folks,
I have created a pivot table that links to an external csv file (there were too many records to store in Excel, 75K+). Pivot table works and performs well. An additional field was added to the csv dataset. I expected that additional field to be available when I refresh the pivot table data, however it is not. Any ideas as to why this additional field is not available? Am I missing something? Thanks, appreciate it. Jason |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data Import
Ron Coderre has a pivot table add-in that lets you view and edit a pivot
table's connection string and command text, so you can change the source, in Excel 2002 or Excel 2003: http://www.contextures.com/xlPivotPlay01.html You could add the new field to the connection string there. Jason wrote: Hello folks, I have created a pivot table that links to an external csv file (there were too many records to store in Excel, 75K+). Pivot table works and performs well. An additional field was added to the csv dataset. I expected that additional field to be available when I refresh the pivot table data, however it is not. Any ideas as to why this additional field is not available? Am I missing something? Thanks, appreciate it. Jason -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data Import
Is putting the CSV file into an Access database an option? Or, is upgrading
to Excel 2007 an option? If either is, then adding fields to the Access db table/Excel 2007 table should solve your problems. However, if these are not options for you, then Debra's response seems like a good bet. Dave -- Brevity is the soul of wit. "Jason" wrote: Hello folks, I have created a pivot table that links to an external csv file (there were too many records to store in Excel, 75K+). Pivot table works and performs well. An additional field was added to the csv dataset. I expected that additional field to be available when I refresh the pivot table data, however it is not. Any ideas as to why this additional field is not available? Am I missing something? Thanks, appreciate it. Jason |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data Import
Work perfectly. Great tool. Thanks a lot.
Jason "Debra Dalgleish" wrote: Ron Coderre has a pivot table add-in that lets you view and edit a pivot table's connection string and command text, so you can change the source, in Excel 2002 or Excel 2003: http://www.contextures.com/xlPivotPlay01.html You could add the new field to the connection string there. Jason wrote: Hello folks, I have created a pivot table that links to an external csv file (there were too many records to store in Excel, 75K+). Pivot table works and performs well. An additional field was added to the csv dataset. I expected that additional field to be available when I refresh the pivot table data, however it is not. Any ideas as to why this additional field is not available? Am I missing something? Thanks, appreciate it. Jason -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count only if another column has data in Pivot Table? | Excel Worksheet Functions | |||
Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |