Converting Excel 2003 WS to Exccel 2.1 WS

[Kristibaer]

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?

 

[Ron Coderre]

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)