Solved

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

Posted on 2002-04-09
2
195 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
Comment Utility
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
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Sometimes you might need to configure routing based not only on destination IP address, but also on a combination of destination IP address (or hostname) and destination port number. I will describe a method how to accomplish this with free tools. …
Downtime reduced, data recovered by utilizing an Experts Exchange Business Account Challenge The United States Marine Corps employs more than 200,000 active-duty Marines with operations in four continents, all requiring complex networking system…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now