[mahesh.pert]

FYI-Only i have excel 2007 in the office others use 2003
I would like to know how to open a Excel 2007 file Pivot With 70,000 data Lines in Excel 2003.......??????.

I saved the 70,000 Data lines in new 07Format & formed pivots in New workbook and saved it as 97-2003 File.

I can see the pivot in 2003 but cannot use the Filter it more like a tables

Tired having both data and pivot in same file and saved it as excel 2007
but bring up an error... which state that line after 65 k will not be opened

IS THERE ANYWAY ON EARTH CAN I OPEN PIVOTS IN 2003 WHICH ARE HAVE 70k DATA LINES..........???????????
MK

 

[macropod]

Hi MK,

Excel '03 only supports 255 columns & 65536 rows, regardless of whether you've installed the '07 converter. That leaves you with 3 options:
1. Install '07 on the other PCs needing access to this wb
2. Reorganise you data to fit in 64K rows
3. Give the other users access to your PC when they need to use this wb.