open a excel07 file with 70,000 lines in Excel03

mahesh.pert · 05-20-2009, 08:04 PM

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** · 05-22-2009, 04:52 PM

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.

05-20-2009, 08:04 PM	#1 (permalink)
mahesh.pert Registered User Join Date: May 2009 Posts: 1 OS: win203	open a excel07 file with 70,000 lines in Excel03 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

05-22-2009, 04:52 PM	#2 (permalink)
macropod TSF Enthusiast Join Date: Apr 2008 Location: Australia Posts: 564 OS: Vista	Re: open a excel07 file with 70,000 lines in Excel03 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. __________________ Cheers macropod (MS MVP -Word)