Solved

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

Posted on 2002-04-09
2
200 Views
Last Modified: 2013-12-23
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
Comment
Question by:screenm0nkey
2 Comments
 
LVL 63

Accepted Solution

by:
SysExpert earned 50 total points
ID: 6928883
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
 

Author Comment

by:screenm0nkey
ID: 6928900
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

Featured Post

Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Greetings, Experts! First let me state that this website is top notch. I thoroughly enjoy the community that is shared here; those seeking help and those willing to sacrifice their time to help. It is fantastic. I am writing this article at th…
Resolve DNS query failed errors for Exchange
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question