|create pivot table from external csv file||Sunny||2/11/09 12:06 PM|
I am dumping huge data to csv file, Now what I want to do is, create pivot
table/chart from csv file without importing data into it. Reason behind
doing this is, end user view updated report without messing with thier
limited excel knowledge.
|RE: create pivot table from external csv file||Shane Devenshire||2/11/09 12:35 PM|
So what's your question?
If you're asking if it can be done, the answer is Yes.
If you're asking how to do it, the question is - what version of Excel are
For Example in 2003 you would choose Data, Pivot Table and Pivot Chart
|Re: create pivot table from external csv file||Sunny||2/11/09 1:24 PM|
Sorry for not clear about my question.
I am using excel 2007 and I tried to follow your steps for excell 2003 but
Thanks for looking into it.
"Shane Devenshire" <ShaneDe...@discussions.microsoft.com> wrote in
|Re: create pivot table from external csv file||Shane Devenshire||2/11/09 11:17 PM|
Sorry to take so long getting back to you, but I work and have a long commut.
In 2007, Press Alt D P this will put you in the 2003 pivot table wizard.
|Re: create pivot table from external csv file||Roger Govier||2/12/09 12:14 AM|
In Excel 2007>Data tab>Get External Data>From Other Source>from Microsoft
"Sunny" <sunny...@hotmail.com> wrote in message
|Re: create pivot table from external csv file||Sunny||2/12/09 9:11 AM|
Shane and Roger,
Thanks you very much and it worked great. Although I have couple more
1. I notice file size is very big as my csv file. I assumes it imports data
2. Is there any way in pivot table to find unique count? Like I want total
I really appreciate your help.