Excel Locking Documents Sporadically -- File Server
-
@travisdh1 said:
Just curious, have you tried restoring it from the latest backup (change the filename or directory to restore to), and seeing if the restored file has the same issue? Could be something as simple as a corrupted bit in the wrong place.
It's not just a single file it's all files and I'm not sure when this started. I think it most likely has been longer than 7 days (backup tapes). I don't think it's the files themselves.
-
@wirestyle22 They have a procedure for this type of thing here, it's called "Throw it in the pond." Good luck, I'll be watching to see the cause/fix.
-
@travisdh1 said:
@wirestyle22 They have a procedure for this type of thing here, it's called "Throw it in the pond." Good luck, I'll be watching to see the cause/fix.
Sad frowny time
-
@dafyre said:
@wirestyle22 said:
@dafyre said:
@wirestyle22 said:
wat
why
Friends of the internet assemble @Dashrender @dafyre @MattSpeller @coliver @travisdh1
Is that the event you are getting when somebody tries to open the locked file?
Yeah. The thing is it's not really locked. It opens a bunch of times perfectly fine but sporadically says it's locked. No one else has the file open. Another thing is I'm using two different version of Excel--BOTH VERSIONS have this happen. They can close it afterwards and then open it perfectly fine. It's not just one file either its any excel files. Driving me nuts
Is it ONLY Excel files? What about Word files?
Word seems fine. I cannot replicate the problem and the user can't either (in word).
Note: This doesn't just happen with one user as well. I am just using one person to test it in addition to my accounts. User has full access permissions to the folder and inherited permissions are on for it. I also removed inherited permissions and applied them manually. Same thing.
-
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.
