Ran into this today. User can open and edit, but cannot then save an excel spreadsheet from a document library. Error msg says “document is read only”. But it isn’t read only. And the user has proper permissions to the library and the document.
Solution: The Minor Version limit had been reached. It seems MOSS 2007 will only keep 500 minor versions max.
Problem. Versioning was turned on with NO LIMITS! 500 Minor versions have piled up. There are 500 betas and no version 1! There’s no “bulk delete older than” option. I don’t want to click, edit, delete each and every one. Supposedly, if you change the “max versions” to some number then the next time you upload a change, it will empty the documents folder of all but the most recent number you specified. But in practice, it did not do it. I changed it to keep only a max of 25 versions of both major and minor. And when I went to upload a changed document, it still complained that the max minor version had been exceeded. And the version history still showed 500 old minor versions.
Solution: I turned OFF versioning entirely. Then I saved the one document I had open. That finally did clear all old versions. but… all of them. I expected that, though. I figured it would clear the old versions and allow me to save the document, and it did. I then turned versioning back on, and specified my max limits again.
So, I had to start over as far as versioning goes. But we did get past the “can’t save” problem.
Any suggestions as to how to better handle this are welcome. I inherited a 160GB sharepoint document library, and I’m pretty new to this.