Saved changes not there on re-opening

[DavidCTOC]

Hi,

As ludicrous as it sounds, I've an issue with a spreadsheet I've inherited in my current job in that I can make changes, save the file and not have the changes there when it re-opens. The file has auto-save on every ten minutes, I habitually press Ctrl+S and tend to be quite paranoid about changes being made. If its was one or two things, then maybe I could put it down to human error. But yesterday there were things that I know for certain had been changed and saved that weren't there. The file is stored on a server, using Excel 2007. It has no macros in it though does pull quite a bit of data from an accounts system using Query. I know that most reactions will just think that its an error on my part regards saving, but this is definitely happening. Any ideas? This is a critical file and can't really afford for it to be corrupted in any way.

Thanks

 

[VoG]

Hi.

Are you sure there is no code? Take a look in the ThisWorkbook module.

 

[DavidCTOC]

Actually, I take that back, there is a macro, but not an overly sophisticated one. It just copies and paste values some columns over others when the model is revised each month so it keeps the prior month figures. Forgot about that, long day! But where the data I'd changed is isn't part of where the macro is doing anything. Its also quite an old model, so it wasn't created in 2007. I'm starting to wonder if there are issues with the machine I'm using, as I had an error earlier where I was being told that deleting a blank row would impact upon a considerable amount of data, even though it was a new worksheet and nothing was linking in there. Not having a good Excel day.