Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Excel 2003 WS to Exccel 2.1 WS
I have done this function several times, yet today when I save a 2003 Excl WS
as Excel 2.1, I am losing 4251 records out of 20,635. This has never happened to me before today and I need the file to stay intact for a Fox Pro application. I have tried to paste in the missing records and re-save and that doesn't work either. How do I keep the record count at 20,635 when saving as 2.1? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Excel 2003 WS to Exccel 2.1 WS
As I recall, Excel 2.1 had a limit of 16k rows.
1,024*16 = 16,384 In your situation 20,635 source rows - 4,251 rows lost = 16,384 I think that's your problem....too many rows. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Kristibaer" wrote in message ... I have done this function several times, yet today when I save a 2003 Excl WS as Excel 2.1, I am losing 4251 records out of 20,635. This has never happened to me before today and I need the file to stay intact for a Fox Pro application. I have tried to paste in the missing records and re-save and that doesn't work either. How do I keep the record count at 20,635 when saving as 2.1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - converting 51322 to 513.22 | Setting up and Configuration of Excel | |||
CONVERTING OFFICE 97-2003 EXCEL FILES TO 2007 EXCEL | Excel Discussion (Misc queries) | |||
Converting Excel 97 files to 2003 | Excel Discussion (Misc queries) | |||
converting international characters in English in Excel 2003 | Excel Discussion (Misc queries) | |||
Converting Works 2001 Spreadsheet to Excel 2003 | Excel Discussion (Misc queries) |