Solved

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

Posted on 2002-04-09
2
198 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Clients download Emails from other exchange servers. 14 107
Best free website shortner services 2 74
BGP routing on Windows 2016 7 51
Freeproxy running on Server 2012 R2 2 48
A common practice in small networks is making file sharing easy which works extremely well when intra-network security is not an issue. In essence, everyone, that is "Everyone", is given access to all of the shared files - often the entire C: drive …
We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
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…

808 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