The Samba-Bugzilla – Bug 8713
SMB2/Excel_2007: "The file 1.xlsx may have been changed by another user since you last saved it"
Last modified: 2012-11-24 14:45:23 UTC
Samba-3.6.1 (SerNet), RHEL5.x in a VMware VM.
Client: Windows 7 64bit, Excel 2007 SP3
I create an Excel .xlsx file (.xls is the same).
I then open it and I click "save" (even w/o any modification) repeatedly.
When saving, I randomly (not always, but often) get
"The file 1.xlsx may have been changed by another user since you last saved it" (actually in my case Excel will produce a message in Italian, but I think this is the equivalent English message).
I may get this at the 1st try, or maybe the 4th try, or whatever.
No one else is accessing the file.
I first though about an issue in Excel, read
and applied QFE_Saskatchewan fix, but the problem persisted.
Then I noticed that the problem disappears if I turn off SMB2 in Samba, and that there's no issue if the file is hosted on another Win7 server (SMB2 is used too).
So I think maybe there's an issue in Samba+SMB2.
I have a 700K wireshark trace of 4 "saves" in a row, the last causing the message; I'll send it via email to a developer willing to look into it.
I wanted to test against latest v3-6-test but couldn't find any way to download just that (or better the delta between 3.6.1 and v3-6-test HEAD) and not the entire git tree (more that half GB it seems).
Since ancient times I had in smb.conf
dos filetime resolution = yes
it turns out that this old setting causes problem to Excel when using SMB2, and it's evident why, since the issue is about Excel checking timestamps.
When SMB2 is off it doesn't matter, and since the only setting I changed was enabling SMB2 I thought SMB2 was the problem.
Turned it off and the Excel saving issue w/SMB2 is gone.