Data Disappearing from Excel 2000 Worksheet

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a worksheet with 28 columns and 25,229 rows. When
I close and re-open it, only 16,383 rows remain. This
problem has repeated four times, and I can't for the life
of me figure out what is causing it.

Has anyone else ever experienced such a thing and know how
to prevent it? Thanks.
 
I can't see anything. The rows are empty, as if they had
been deleted.

-----Original Message-----
Do you mean the rows are empty?
Can you see the rows??

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




I have a worksheet with 28 columns and 25,229 rows. When
I close and re-open it, only 16,383 rows remain. This
problem has repeated four times, and I can't for the life
of me figure out what is causing it.

Has anyone else ever experienced such a thing and know how
to prevent it? Thanks.
 
Hi Dave,

You probably know that 16,384 was the maximum rows in
Excel 7.0 and 5.0. Is someone else on your network
opening and saving the file with one of these?

Walt
 
or is Dave saving as Excel 5.0 format?


Walt Weber said:
Hi Dave,

You probably know that 16,384 was the maximum rows in
Excel 7.0 and 5.0. Is someone else on your network
opening and saving the file with one of these?

Walt
Click to expand...
 
Nope. They are not hidden.

-----Original Message-----
Maybe they are hidden

Ctrl-A
Right click on the selection and choose Unhide

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)


I can't see anything. The rows are empty, as if they had
been deleted.

-----Original Message-----
Do you mean the rows are empty?
Can you see the rows??

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)



I have a worksheet with 28 columns and 25,229 rows. When
I close and re-open it, only 16,383 rows remain. This
problem has repeated four times, and I can't for the life
of me figure out what is causing it.

Has anyone else ever experienced such a thing and know how
to prevent it? Thanks.
 
That appears to be the answer!
Thank you, thank you, thank you!!!

Where do I send the check? :)

-----Original Message-----
or is Dave saving as Excel 5.0 format?


Hi Dave,

You probably know that 16,384 was the maximum rows in
Excel 7.0 and 5.0. Is someone else on your network
opening and saving the file with one of these?

Walt

-----Original Message-----
I have a worksheet with 28 columns and 25,229 rows. When
I close and re-open it, only 16,383 rows remain. This
problem has repeated four times, and I can't for the life
of me figure out what is causing it.

Has anyone else ever experienced such a thing and know how
to prevent it? Thanks.
 
Back
Top