View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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?