After upgrading some workstations to Windows 7 / 64b, users started having problems while saving big Excels. Sometimes when they open up a big Excel they get an empty error dialog window.
After editing and trying to save the document they get the following of 2 errors, they change from time to time, but most of the time it is the “File is checked out or locked for editing by someone else” error.
I noticed the error only appearing with big Excel documents so after some trial and error I found out the erros started appearing when the file was > 50.000.000 bytes. I knew the default file upload size in SharePoint is 50 MB, but this is quite easy to change. Go to Central Administration -> Web Application General Settings. Select the Web Application you want to change, and you will see a textbox to specify the maximum upload size. Problem solved? Not. I should have known because users on WinXP systems weren’t experiencing the same problems, so it had to be something client side.
After some googling I found the following Microsoft KB: You receive a folder copy error message when you try to download a file that is larger than 50000000 bytes from a Web folder. It was a long shot because there was nothing about SharePoint in the KB, but I tried. And, to my surprise, after changing the registry setting, all worked fine! No more errors!
The Release Candidate for Visual Studio 2010 and .NET Framework 4 are available for MSDN subscribers, you can download them immediately from this location. The Release Candidate will be made available to the public on 10 February 2010.
This release includes a “go-live” license for users who want to use VS in a production environment.
Remark: Before installing the Release Candidate you will have to uninstall any previously installed Visual Studio 2010 Beta 2 versions.
You can find most of the videos from the SharePoint Connections 2010 conference in Amsterdam by searching for the “SPC10” tag on Channel9.
This is a known issue. The metadata is actually stored within the document and gets read into SharePoint when being saved. Unfortunately, since the document is password protected, SharePoint cannot read the metadata values and therefore you lose them. More precise, if you open the document for example in Excel you will see in your Document Information Panel (DIP) that the metadata is stored (in the document), but you won’t see the metadata in SharePoint.
You have 2 different options to password protect an Office document, you can enter a “password to open” and/or a “password to modify“. The problem only occurs when you enter a “password to open”. If you use “password to modify” SharePoint will be able to read the metadata from the document.