Converting Excel 2003 WS to Exccel 2.1 WS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kristibaer - 19 Mar 2008 21:39 GMT

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 to this Message

Ron Coderre - 19 Mar 2008 21:46 GMT

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)

>I have done this function several times, yet today when I save a 2003 Excl
>WS
[quoted text clipped - 5 lines]
>
> How do I keep the record count at 20,635 when saving as 2.1?

Reply to this Message