Office 2016 - Display a list of all SharePoint Online sites a user has access to when saving a file

%3CLINGO-SUB%20id%3D%22lingo-sub-139439%22%20slang%3D%22en-US%22%3EOffice%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-139439%22%20slang%3D%22en-US%22%3E%3CP%3EWhile%20saving%20a%20file%2C%20Office%202016%20displays%20a%20list%20of%20the%20recently%20used%20'Saved%20To'%20document%20library%20locations%20to%20select%20from.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20possible%20to%20display%20a%20list%20of%26nbsp%3B%3CU%3EALL%3C%2FU%3E%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20file%20in%20Office%202016%3F%20If%26nbsp%3Bthis%20is%20to%20be%20a%20future%20release%20feature%2C%20when%20is%20this%20expected%20to%20be%20available%20for%20the%20enterprise%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-139439%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProPlus%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363157%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363157%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fuse-the-highlighted-content-web-part-e34199b0-ff1a-47fb-8f4d-dbcaed329efd%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fuse-the-highlighted-content-web-part-e34199b0-ff1a-47fb-8f4d-dbcaed329efd%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363152%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363152%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20unable%20to%20understand%20where%20and%20how%20to%20implement%20this%20.%20I'm%20all%20new%20to%20sharepoint%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20explain%20as%20if%20i%20was%20three%20years%20old%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%2F%2FLars%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-308142%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-308142%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20do%20roughly%20the%20same%20thing%20with%20the%20Highlighted%20Content%20web%20part%20on%20modern%20pages.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20320px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64503i7A769243015DCB7A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22HighLightedContent.png%22%20title%3D%22HighLightedContent.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-150543%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-150543%22%20slang%3D%22en-US%22%3E%3CP%3EI%20agree%20with%20other%20replies%3A%20having%20ALL%20SPO%20sites%20in%20Office%20App%20wouldn't%20help.%3C%2FP%3E%0A%3CP%3EAs%20a%20workaround%2C%20you%20could%20create%20a%20page%20in%20the%20root%20site%20collection%20(https%3A%2F%2F%3CTENANT%3E.sharepoint.com)%20and%20place%20a%20Search%20Results%20Web%20Part.%20Edit%20the%20query%20and%20put%20this%20in%20query%20text%3A%26nbsp%3Bcontentclass%3A%E2%80%9DSTS_Site%E2%80%9D%20contentclass%3A%E2%80%9DSTS_Web%E2%80%9D%3C%2FTENANT%3E%3C%2FP%3E%0A%3CP%3EYou%20will%20have%20a%20page%20with%20all%20sites%20the%20logged-in%20user%20has%20access%20to.%3C%2FP%3E%0A%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Fjohnmhester.files.wordpress.com%2F2013%2F05%2Fsearch_results_web_part_config.jpg%22%20border%3D%220%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-150019%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-150019%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Kevin%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ehow%20do%20you%20achieve%20this%20in%20windows%207%20%3F%26nbsp%3Balso%20you%20don't%26nbsp%3Bwant%20to%20display%20all%20the%20SharePoint%20sites%20but%20the%20one%20syou%20are%20following%26nbsp%3B.%26nbsp%3BThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149997%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149997%22%20slang%3D%22en-US%22%3E%3CP%3E%26gt%3BIs%20it%20possible%20to%20display%20a%20list%20of%26nbsp%3B%3CU%3EALL%3C%2FU%3E%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%3C%2FP%3E%0A%3CP%3EDepending%20on%20the%20use%20of%20SharePoint%20in%20an%20organization%2C%20that%20number%20could%20be%20hundreds%20or%20thousands%20of%20sites.%20Not%20sure%20you'd%20want%20%22ALL%22%20of%20them%20to%20display%20there%20(being%20able%20to%20search%2Fbrowse%20to%20them%20would%20help%2C%20though).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149985%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149985%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Domenic%20%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20windows%2010%20latest%20update%20and%20word%202016%20pro%20%2C%20when%20I%20click%20on%20open%20I%20can%20see%20all%20the%20share%20point%20sites%20that%20I%20am%20following%20.%26nbsp%3BI%20am%20looking%20to%20replicate%26nbsp%3B%20this%20on%20windows%207%20but%20I%20am%20not%20sure%20how%20to%20achieve%26nbsp%3B%20this.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPiero%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-139453%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-139453%22%20slang%3D%22en-US%22%3EI%20am%20not%20aware%20of%20such%20a%20feature%20coming%20to%20Office...the%20true%20fact%20is%20that%20you%20will%20see%20recent%20places%20(in%20your%20local%20PC%2C%20ODFB%2C%20SPO)%20where%20you%20have%20been%20working%20with%20documents%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748106%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748106%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Adam%2C%20great%20response%2C%20as%20I've%20been%20looking%20for%20something%20like%20this%20to%20get%20around%20some%20limitations.%26nbsp%3B%20One%20minor%20question%20-%20how%20do%20I%20get%20this%20to%20Sort%20by%20the%20Name%20of%20the%20site%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748178%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748178%22%20slang%3D%22en-US%22%3EIm%20sorry%20but%20AFAIK%20you%20can%E2%80%99t%20%3A%5C%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748287%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748287%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOk%2C%20thanks.%26nbsp%3B%20Appreciate%20the%20prompt%20response.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-810160%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810160%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14864%22%20target%3D%22_blank%22%3E%40Dominic%20Horne%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20Dave%20and%20Pablo%20said%2C%20you%20can%20use%20the%20Content%20Search%20and%20Highlighted%20Content%20web%20parts.%20Another%20option%20is%20to%20use%20the%20Search%20Results%20web%20part%20with%20the%20Search%20Box.%20They%20are%20all%20useful%20options%20depending%20on%20the%20given%20scenario.%26nbsp%3B%20View%20the%20comparison%20matrix%20I%20use%20when%20determining%20which%20to%20use%20at%20%3CA%20href%3D%22https%3A%2F%2Fjennyssharepointtips.wordpress.com%2F2019%2F08%2F18%2Fdisplay-a-list-of-all-sites-a-user-can-access%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjennyssharepointtips.wordpress.com%2F2019%2F08%2F18%2Fdisplay-a-list-of-all-sites-a-user-can-access%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-810790%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810790%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394196%22%20target%3D%22_blank%22%3E%40JennyHersko%3C%2FA%3EApologies%20for%20what%20I'm%20not%20seeing%20here%2C%20but%20when%20my%20desired%20end%20result%20here%20is%20to%20give%20the%20user%20one%20link%20to%20click%20on%20to%20show%20the%20listing%20of%20all%20associated%20sites%20to%20the%20hub%2C%20to%20which%20they%20have%20access%2C%20in%20alphabetical%2C%20case%20insensitive%20sort%20order%2C%20I%20still%20don't%20have%20a%20solution.%26nbsp%3B%20Exploring%20the%20options%20you%20mention%20in%20your%20response%20and%20in%20your%20blog%20-%20Content%20Search%2C%20Search%20Results%2C%20and%20Highlighted%20Content%20web%20parts%20-%20does%20not%20get%20me%20any%20closer%20to%20a%20solution%2C%20as%20the%20only%20one%20of%20those%20web%20parts%20that%20I%20can%20add%20to%20a%20modern%20page%20is%20the%20Highlighted%20Content%20web%20part.%26nbsp%3B%20I%20can%20almost%20get%20that%20to%20work%2C%20except%20that%20there%20is%20little%20ability%20to%20sort%20by%20the%20Site%20Name%2FTitle.%26nbsp%3B%20Do%26nbsp%3B%20you%20have%20anything%20that%20shows%20a%20working%20example%20of%20a%20solution%20where%20I%20can%20provide%20a%20user%20with%20a%20link%20that%20lists%20all%20of%20the%20sites%20in%20alphabetical%20order%2C%20when%20there%20are%20100%2B%20sites%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1001802%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Display%20a%20list%20of%20all%20SharePoint%20Online%20sites%20a%20user%20has%20access%20to%20when%20saving%20a%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1001802%22%20slang%3D%22en-US%22%3EI%20have%20the%20same%20remark.%20A%20new%20SharePoint%20user%2C%20such%20as%20a%20new%20employee%2C%20will%20not%20yet%20have%20any%20sites%20listed%20under%20%22Following%22%20or%20%22Recent%22%2C%20so%20an%20obvious%20first%20step%20would%20be%20to%20search%20for%20what%20is%20accessible.%20Many%20user%20fora%20posts%20question%20the%20right%20to%20do%20this%2C%20citing%20that%20%22there%20might%20be%20hundreds%20of%20sites%22.%20(Yeah%2C%20so%3F)%20Others%20do%20offer%20a%20solution%2C%20for%20which%20I%20am%20always%20grateful%2C%20yet%2C%20like%20Jenny%2C%20they%20tend%20to%20never%20offer%20step-by-step%20instructions.%20The%20best%20answer%20that%20I%20have%20found%20to%20date%2C%20is%20to%20teach%20end%20users%20to%20search%20for%20%22contentclass%3A%20STS_Site%22.%20To%20offer%20end%20users%20an%20even%20easier%20way%20seems%20to%20require%20advanced%20SharePoint%20skills...%3C%2FLINGO-BODY%3E
Highlighted
Contributor

While saving a file, Office 2016 displays a list of the recently used 'Saved To' document library locations to select from.

 

Is it possible to display a list of ALL SharePoint Online sites a user has access to when saving a file in Office 2016? If this is to be a future release feature, when is this expected to be available for the enterprise?

14 Replies
Highlighted
I am not aware of such a feature coming to Office...the true fact is that you will see recent places (in your local PC, ODFB, SPO) where you have been working with documents
Highlighted

Hi Domenic ,

 

I have windows 10 latest update and word 2016 pro , when I click on open I can see all the share point sites that I am following . I am looking to replicate  this on windows 7 but I am not sure how to achieve  this.

 

Piero

Highlighted

>Is it possible to display a list of ALL SharePoint Online sites a user has access to

Depending on the use of SharePoint in an organization, that number could be hundreds or thousands of sites. Not sure you'd want "ALL" of them to display there (being able to search/browse to them would help, though).

Highlighted

Hi Kevin,

 

how do you achieve this in windows 7 ? also you don't want to display all the SharePoint sites but the one syou are following . Thanks

Highlighted

I agree with other replies: having ALL SPO sites in Office App wouldn't help.

As a workaround, you could create a page in the root site collection (https://<tenant>.sharepoint.com) and place a Search Results Web Part. Edit the query and put this in query text: contentclass:”STS_Site” contentclass:”STS_Web”

You will have a page with all sites the logged-in user has access to.

Highlighted

You can do roughly the same thing with the Highlighted Content web part on modern pages. 

 

HighLightedContent.png

 

 

 

Highlighted

I'm unable to understand where and how to implement this . I'm all new to sharepoint 

Please explain as if i was three years old :)

//Lars 

Highlighted

@adam deltinger 

Hi Adam, great response, as I've been looking for something like this to get around some limitations.  One minor question - how do I get this to Sort by the Name of the site?

 

Highlighted
Highlighted
Highlighted

@Dominic Horne 

Like Dave and Pablo said, you can use the Content Search and Highlighted Content web parts. Another option is to use the Search Results web part with the Search Box. They are all useful options depending on the given scenario.  View the comparison matrix I use when determining which to use at https://jennyssharepointtips.wordpress.com/2019/08/18/display-a-list-of-all-sites-a-user-can-access.

Highlighted

@JennyHerskoApologies for what I'm not seeing here, but when my desired end result here is to give the user one link to click on to show the listing of all associated sites to the hub, to which they have access, in alphabetical, case insensitive sort order, I still don't have a solution.  Exploring the options you mention in your response and in your blog - Content Search, Search Results, and Highlighted Content web parts - does not get me any closer to a solution, as the only one of those web parts that I can add to a modern page is the Highlighted Content web part.  I can almost get that to work, except that there is little ability to sort by the Site Name/Title.  Do  you have anything that shows a working example of a solution where I can provide a user with a link that lists all of the sites in alphabetical order, when there are 100+ sites?

Highlighted
I have the same remark. A new SharePoint user, such as a new employee, will not yet have any sites listed under "Following" or "Recent", so an obvious first step would be to search for what is accessible. Many user fora posts question the right to do this, citing that "there might be hundreds of sites". (Yeah, so?) Others do offer a solution, for which I am always grateful, yet, like Jenny, they tend to never offer step-by-step instructions. The best answer that I have found to date, is to teach end users to search for "contentclass: STS_Site". To offer end users an even easier way seems to require advanced SharePoint skills...