Are you sure you're opening the same workbook each time?

My bet is that you have two workbooks with the same name (in different
folders). And you are not opening the "correct" one each time.

And if the workbook is an attachment to an email and you're opening that
workbook from the email program, that could be the trouble.

Maybe you could put:
=cell("Filename",a1)
in an unused cell.

After the workbook is saved, this will return the path of that workbook (as well
as the sheet name).

It might make it easier to see where that workbook originated.

Ming wrote:

I have a spreadsheet where some cells reverted automatically to it previous
values. This is the first time that I have anything close to 130 columns and
8000 rows.

I would change some values, save and make some more changes. Then all of a
sudden when I noticed previously changed data were the same as the original.
I thought I was going insane, but it did happen more than one occasion.

I did worked on the worksheet in both Excel 97 and Excel 2002 before. Any
problems there?

Ming

--

Dave Peterson