• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

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?
0
screenm0nkey
Asked:
screenm0nkey
1 Solution
 
SysExpertCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now