We have a bunch of excel files that are at random becoming corrupt. The error message is excel has found unreadable content...
I believe this question is relevant to serverfault because the problem has only started occurring since we have setup folder redirection, roaming user profiles and offline files on our desktops. The files have been in use for around 5 years prior with no issues.
The excel files are located in a subfolder of our company folder on the server. The entire company folder is shared and available offline. About 32gb in total.
After one of the files became corrupt I tried to restore if from a backup. From one of the desktops I deleted the corrupted file on the server, I copied the new file to the existing location then opened, saved, closed, opened and noticed it was corrupted. I can recreate this occurrence many times, but the weird thing is it seems to be related to that particular folder. If I copy the file to any other folder (even other shared and available offline folders), open, save, close, reopen it then it is not corrupted. It only gets corrupt if I copy it to its original location.
Does anyone know what an earth is going on?
Using windows 7 on all desktops and windows server 2008 r2 on the server.
I think a packet capture would be the way to investigate, although that would be a bit "the hard way", considering there are a lot of known issues with file system redirector. If you have not applied the recommended updates, you may want to start here:
List of currently available hotfixes for the File Services technologies in Windows Server 2008 and in Windows Server 2008 R2
http://support.microsoft.com/kb/2473205
There are fixes for both the client and server. You may want to apply both.
In the above article, client hotfix 2646563 includes and supersedes fixes included in the following article:
Data corruption when one user on a computer that is running Windows 7 or Windows Server 2008 R2 updates a shared file that is open on multiple computers by using SMB Version 2
http://support.microsoft.com/kb/2618096
We had the same issue when we moved over to roaming profiles, though it was only for protected Excel files i believe. The Office Trust Center was reading shared files on the network as originating from the internet and tried to open them in Protected Mode. When I went to options->Trust Center and disabled Protected Mode, the files opened normally.