Excel Locking Documents Sporadically -- File Server
-
Argh grief, had this SOOO many times when I was mainly helpdesk based.
Excel files like to be annoying.
What file format are the spread-sheets exactly?
-
If what I think I found is the cause of this I'm going into the woods to punch dance until I can't feel feelings anymore
-
So I noticed indexing was enabled. I disabled it.
I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.
-
@wirestyle22 said:
So I noticed indexing was enabled. I disabled it.
I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.
I find the indexing system to almost always be bad.
-
@scottalanmiller said:
@wirestyle22 said:
So I noticed indexing was enabled. I disabled it.
I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.
I find the indexing system to almost always be bad.
I never enable indexing. I have no idea why it is enabled. I must have not noticed it when I started here. I will keep everyone updated once I test this further.
-
@wirestyle22 said:
@scottalanmiller said:
@wirestyle22 said:
So I noticed indexing was enabled. I disabled it.
I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.
I find the indexing system to almost always be bad.
I never enable indexing. I have no idea why it is enabled. I must have not noticed it when I started here. I will keep everyone updated once I test this further.
Microsoft has "helpfully" enabled that feature in updates for desktop versions of Windows, I wonder if that's what happened here?
-
@wirestyle22 said:
@scottalanmiller said:
@wirestyle22 said:
So I noticed indexing was enabled. I disabled it.
I have not been able to reproduce the problem. Might be too early to judge but after opening over 60 documents I have not run into the issue.
I find the indexing system to almost always be bad.
I never enable indexing. I have no idea why it is enabled. I must have not noticed it when I started here. I will keep everyone updated once I test this further.
On by default.
-
What error message does the user get when they try and open one that has this problem?
Oh, never mind - read only. One minute.
-
http://www.ozzu.com/mswindows-forum/word-files-saved-network-randomly-opening-read-only-t75734.html
"I checked. Before we tried opening a file, nothing was listed as being open. Once we tried to open a file. The file opened in word as read only. When I checked the open files then, it showed the file being accessed. But not by her, it was showing being accessed by one of the service accounts we have set up for our fax server. I checked and she is logged in as herself, this is very strange. "
"Double check her machine to make sure the fax service is not set as her default printer."
-
@MattSpeller said:
http://www.ozzu.com/mswindows-forum/word-files-saved-network-randomly-opening-read-only-t75734.html
"I checked. Before we tried opening a file, nothing was listed as being open. Once we tried to open a file. The file opened in word as read only. When I checked the open files then, it showed the file being accessed. But not by her, it was showing being accessed by one of the service accounts we have set up for our fax server. I checked and she is logged in as herself, this is very strange. "
"Double check her machine to make sure the fax service is not set as her default printer."
Are you shitting me right now Matt? Hold on. Sigh.
-
Nah. Her default printer is an HP 1350.
-
-
@MattSpeller said:
@wirestyle22 said:
Nah. Her default printer is an HP 1350.
I tried
Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information. The thing is there is no other open version of the file from the servers point of view. I think this might be a case of excel being closed improperly so to test this I had her start excel, open the file within excel, close the file in excel (while keeping excel running) and then open a new file. Rinse and repeat. We have not had this issue occur since then. We have probably opened at least 150 documents up until this point. So my question is where do i go from here?
@MattSpeller tagging you so you know I edited this.
-
My boss has gotten these errors many times over the years. I look around find nothing wrong and go about my day. No other user has ever complained about it, even the ones that I know use Excel a fair amount.
I'll be checking on the indexing option as well.
Question - indexing on the server or on the workstation?
indexing a network share I don't think is on from a workstation perspective by default - or am I mistaken?
-
@wirestyle22 said:
Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information.
Dictionary Entry for User: "One who lies about trivial items for which there is no reason to refuse accurate information."
-
@scottalanmiller said:
@wirestyle22 said:
Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information.
Dictionary Entry for User: "One who lies about trivial items for which there is no reason to refuse accurate information."
what's amazing, if you them into a lie detector, they would pass saying the first thing because they don't care enough to accurately report the problem.
-
@Dashrender said:
@scottalanmiller said:
@wirestyle22 said:
Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information.
Dictionary Entry for User: "One who lies about trivial items for which there is no reason to refuse accurate information."
what's amazing, if you them into a lie detector, they would pass saying the first thing because they don't care enough to accurately report the problem.
That would be an interesting test. It also suggests that they are sociopaths as that is what that means - that they do evil because they have no conscious.
-
@scottalanmiller said:
@Dashrender said:
@scottalanmiller said:
@wirestyle22 said:
Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information.
Dictionary Entry for User: "One who lies about trivial items for which there is no reason to refuse accurate information."
what's amazing, if you them into a lie detector, they would pass saying the first thing because they don't care enough to accurately report the problem.
That would be an interesting test. It also suggests that they are sociopaths as that is what that means - that they do evil because they have no conscious.
Is it really evil in that case?
-
@Dashrender said:
@scottalanmiller said:
@Dashrender said:
@scottalanmiller said:
@wirestyle22 said:
Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information.
Dictionary Entry for User: "One who lies about trivial items for which there is no reason to refuse accurate information."
what's amazing, if you them into a lie detector, they would pass saying the first thing because they don't care enough to accurately report the problem.
That would be an interesting test. It also suggests that they are sociopaths as that is what that means - that they do evil because they have no conscious.
Is it really evil in that case?
Are you suggesting that serial killers are not evil because evil requires a level of caring? An interesting argument. I'm going to go with.. yes. Very evil.
-
@scottalanmiller said:
@Dashrender said:
@scottalanmiller said:
@Dashrender said:
@scottalanmiller said:
@wirestyle22 said:
Appreciate the effort. For the record she told me it said "read only" but it actually says "open by another user". She was making an assumption which I specifically asked her about and she gave me false information.
Dictionary Entry for User: "One who lies about trivial items for which there is no reason to refuse accurate information."
what's amazing, if you them into a lie detector, they would pass saying the first thing because they don't care enough to accurately report the problem.
That would be an interesting test. It also suggests that they are sociopaths as that is what that means - that they do evil because they have no conscious.
Is it really evil in that case?
Are you suggesting that serial killers are not evil because evil requires a level of caring? An interesting argument. I'm going to go with.. yes. Very evil.
Yep, that's what I'm saying. If all of humaity didn't care, would it be evil then? I don't think so.
