open a excel07 file with 70,000 lines in Excel03

977 Views 1 Reply 2 Participants Last post by macropod, May 22, 2009

mahesh.pert

Discussion Starter · May 21, 2009

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

Save

Status: Not open for further replies.

1 - 2 of 2 Posts

macropod

· #2 · May 22, 2009

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.

Save

1 - 2 of 2 Posts

Status: Not open for further replies.

Top Contributors this Month