Hi, I have Openoffice Office Suite 3.3 RC 7 on Windows XP.
We follow steps for Data Pilot. 1. Select all. 2. Data option Data Pilot and Start. 3. In Row fields we take Mask and Cause. 4. In Data Fields we take Cause (Count-Cause). 5. Save it in .xlsx format . In open office this all takes 30 to 40 minutes. and in Microsoft XL it takes hardly 10 minutes. Minimum 65000 rows so we have to save it in xlsx format. Approx size of the file in csv format is 70 to 80 MB and we save it in xlsx format. Please suggest/guide Thanks Kaushal
