Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a document library containing hundreds of folders each with a single word document. Each document has an approval status column set to "Waiting Approval". I would like to change the value for all of the files to "Approved" at once, similar to how SP Designer allows you to check-out/in multiple files at once (even though they are in separate folders). Can this be done? It's taking 3 people several days to make these changes, which is ridiculous in my opinion. Thanks.

share|improve this question
1  
Well, what looks ridiculous is to set up hundreds of folders each with a single document. But you must have your reasons... –  Christophe Nov 10 '11 at 20:57
    
I can only hope that it's permission related, but ya... –  PirateEric Nov 10 '11 at 21:32

3 Answers 3

Create a view that displays all items without folders, it's in the Folder options when you create the view. Be sure to include any columns you wish to modify. Once done, go into Actions, Edit in data sheet view. Toggle the field you want to edit, then you can drag that down to apply it to all items.

share|improve this answer

Batch check in, it can be used to edit column values for multiple documents at one time and check them in.

share|improve this answer
    
While this post may answer the question, we prefer more details such as "why". Please edit your post with additional details. See answer for general guidelines. Thanks. –  SPDoctor Mar 19 '12 at 13:20

You can try approving "Manage Content and Structure" Under Site Actions. It gives you the flexibility to select multiple items and perform your action. For this feature to enable publishing feature of your site must be activated.

share|improve this answer
    
While this post may answer the question, we prefer more details such as "why". Please edit your post with additional details. I have already removed your salutation, which is not necessary. See answer for general guidelines. Thanks. –  SPDoctor Mar 19 '12 at 13:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.