Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Opening a SharePoint Document Library from within Windows Explorer - WSS3 and SharePoint 2010

By:   |   Updated: 2010-09-30   |   Comments   |   Related: > Sharepoint


What happened to "Open with Windows Explorer" in SharePoint 2010?


Don't worry. It's still there. They just put in a place that's hard to find the first time.

In WSS3 and MOSS 2007, there was a handy feature under the "Actions" menu of document libraries called "Open with Windows Explorer". This does what it says it does. It opens an Explorer window and allows you to copy, paste (or drag) document files to and from other libraries or file folders on the local PC or network file shares.

edit in datasheet
Note: When using this feature, it by-passes the filling out of metadata 
columns. And when a SharePoint column has a required field it can cause 
issues. But it's very handy for administrators that need to move large amounts 
of files around. Make sure to temporarily disable required fields.

So what happened to this menu option in SharePoint 2010?

In the ribbon bar of a document library, click on the "Library" tab of "Library Tools". Maximize the browser window. Unless you maximize the window, you will not see the text next to the icon. That's why this feature is easy to miss in SharePoint 2010.

Click on the option and a Windows Explorer window will pop up and you can manage files easily.

open with explorer
(Administrator's note: I would not show this feature to most users. 
It can defeat the purpose of a document library where you want to encourage 
users to use the extra metadata columns that you provide for tracking 
and analysis purposes. It's probably obscure for a reason.)		
Next Steps

Last Updated: 2010-09-30

get scripts

next tip button

About the author
MSSQLTips author Rob Fisch Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

View all my tips

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools