Changed data in Excel spreadsheet is not being saved

S

Sean Ricketts

I have a strange problem with data being saved in excel spreadsheet.

I've previously created an excel spreadsheet on a PC entered the data and saved it to our server.

If I then open on a different PC and change data in any of the cells(eg change cell A1 from 100 to 200)and then save the spreadsheet, close excel down and reopen the spreadsheet, the cell A1 data is missing, even though the date and timestamp of the file has got the date and time of modification are correct.

Please help
 
D

Dave Peterson

My guesses:

Either you saved to a different location--goes against your date/time comment.

or

(unlikely) maybe you a macro that resets that cell.

Try opening excel in safe mode
close excel
windows start button|run
excel /safe

file|open (your workbook)

make the change, save, close, and reopen (all in safe mode).

If it's there, maybe (still maybe) you have a macro that's "helping".

===
When I see errors like this in my work, they are usually caused by a mistake by
the user (me!)--not excel.
 
D

Dave Peterson

(unlikely) maybe you a macro that resets that cell.

should be

(unlikely) maybe you have a macro that resets that cell.
 
Top