Data Disappearing from Excel 2000 Worksheet

[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.

 

[Ron de Bruin]

Do you mean the rows are empty?
Can you see the rows??

 

[Dave]

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.

 

[Ron de Bruin]

Maybe they are hidden

Ctrl-A
Right click on the selection and choose Unhide

 

[Walt Weber]

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

 

[Gail]

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

 

[Dave]

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.

 

[Dave]

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.

 

[Gail]

Glad I could help -- but Walt's post actually gave me the answer!