Is my colleague a liar? Am I wrong to accuse?

This might seem like an Excel question but my colleague is implying that it's a problem with the network....

One of the guys in my office said that he's been working on an Excel document which is stored on our Compaq Proliant server running NT, for the last hour or so saving every 10 minutes. Then Excel crashed and when he tried to open it again it said that the document is already in use which is understandable if Excel crashed whilst the document was open.
The part that's hard to swallow is that he reckons he's lost all his work since he opened it an hour ago even though he saved it every ten minutes. I mean he's right, the document's last modification time was an hour previous but does that mean he's lying and he hasn't saved it for an hour or is it possible that Excel had become unstable for the last hour and even though it seemed like he was saving in fact it wasn't. He seems to think it's a problem with the network and I think that's b***ocks as his drive mappings were still OK and his network connection was fine.

Is he lying?
Am I wrong?
screenm0nkeyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SysExpertConnect With a Mentor Commented:
I think it depends on how he saved.

Autosave puts the saves at the end of the file.

A norma1 save ( Ctrl -S ) updates the original ususually.

Did he have backups turned on ?

In addition - excel keeps some recovery files locally.

Restarting excel usually gives you a prompt to recover lost data.

In any case- by removing his connection using server manager, and having him reboot locally, you will soon have an answer.

I would make a copy of the file on the server in any case.

I hope this helps !
0
 
screenm0nkeyAuthor Commented:
Excellent answer, nice and concise. Unfortunately for him there was no option to recover the data when we restarted Excel which is what normally happens.

screenm0nkey:)
0
All Courses

From novice to tech pro — start learning today.