cells reverting

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

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

I would check that in <file><properties> that it says it was saved when you
last saved it.
I would also check that it is not been converted to a template format and is
opening a copy, not the document itself.

If neither of these indicate a problem. I would use save-as for awhile. If
this is the only document you have that is doing this, It may be worthwhile
copying everything to a new workbook. There may be some corrupted code in
the current file.
"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

Sorry, false alarm. It was actually my colleague problem and when I sat down
to look at the problem I found the records duplicated. She locate the
records, made changes and locate again. It found the next block of records
which looks exactly like previous records before changing.

Ming

"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