How to set the default open behavior or Configure Office files open by default in SharePoint online
This article is about “How to set the default open behavior or Configure Office files open by default in SharePoint online” in SharePoint site collection or in document library.
I will explains how can we configure the default open behavior for Office documents (browser or Application) in SharePoint site collections and document libraries.
This solution article will applies to SharePoint online, SharePoint Server 2013, SharePoint Foundation 2013, and Office Web Apps.
So let’s start with small description about set how document behavior will be there in browser, as we know we are creating document library to store the documents like word, excel, PPT and etc.. by default after configure the SharePoint server clicking on any of document will get open and behavior to open any of those file will set as Use server default (Open in browser) PDF documents open in the Word Web App.
We can do setup the same three different ways:
- SharePoint Farm (farm based we can configure)
- Site collection (Can be configured on site collection)
- Document Library (one document library also can be configured the same)
In the SharePoint Farm: we can configure or adjust the default open behavior of file per file types basis; example: Word, excel or notebook and PDF behavior as well.
To do the above we need to run a command called New-SPWOPIBinding this command will Creates a new binding to associate file name extensions or applications with actions on the current SharePoint farm where this cmdlet is run.
The New-SPWOPIBinding cmdlet associates file name extensions or applications to actions on the current SharePoint farm where this cmdlet is run.
Syntax: New-SPWOPIBinding -ServerName "Prashant.spsolutions.com"
Above example creates bindings for all the applications and file name extensions that the WOPI application supports on the current SharePoint farm where this cmdlet is run.
For specific application we can run below command:
New-SPWOPIBinding -ServerName "Server.corp.Contoso.com" -Application "Excel"
To get more about farm based changes for office file behaviour, visit below URL:
Don’t get confuse about, once you have configured farm based settings for office files, later we can remove also so may there will be a lot of question on the same, so kindly do visit the above URL and there sub added site you will get all details from the same.
We have another option to change the behaviour in site collection itself:
Setup Office file behaviour in Site collection: SP administrators and users can use the OpenInClient feature in SharePoint online or 2013 to specify whether Office (Word, excel etc…) files will be opened in the client application or in the browser. Users (who have permission) can change this setting in the document library properties also for site collection administrators can change it in Site Collection Administration or by using the Enable-SPFeature cmdlet to enable the OpenInClient feature.
Below are the step by step solution with screen shots to the same:
Note: I am going to perform this on SharePoint Online, same steps will for SharePoint on-premises with some different GUI mode.
- Login to the SharePoint online site collection with admin rights.
- Navigate the page to Site setting by clicking on Gear box on the top of page and Site collection features from site collection administrator, see below
- Now click on highlighted site collection features and activate Open documents in client application by default.
- By default it will be deactivate so just click on activate wait for activation
- Once all done, go back to any of document library and open document see the result, earlier it was opening in browser now it will prompt to ask Application which you want to use.
We can configure the above by using PowerShell command as well;
- Open SharePoint Online Management Shell and run below command
Connect-SPOService -Url https://Spsolutions.sharepoint.com -credentialPrashant@spsolutionsonmicrosoft.com
- Once entered hit enter, it will prompt us for password enter the password and wait a second, it will connect your Office 365 site.
Note: Make sure you have admin rights to follow the steps, or else you will be getting an error called access denied or not authorised.
- Now on the connected office 365 site, run below command
Enable-SPFeature 8A4B8DE2-6FD8-41e9-923C-C7C3C00F8295 -url <SiteCollURL (enter your site URL>
The above command is to activate the feature for one site URL, if you wish to enable to same features for all site URL we need to run below command:
Get-SPSite -limit ALL |foreach{ Enable-SPFeature 8A4B8DE2-6FD8-41e9-923C-C7C3C00F8295 -url $_.URL }
At the last point:
Set the default open behaviour for a document library by using the document library settings page:
This is very simple to do for one particular document library, we can set behaviour for office document in one document library as well, and it will take effect for all document available in the same.
- Open one document Library and move your mouse cursor to Documents ribbon.
- As SharePoint online is keep changing view, in the experienced view we can click on site setting and select document settings option, see below
- Once select Library settings it will take us to setting page, default view classic. Here we need to scroll down the page and select open document in browser option and select as you wish to open your file.
- Here we can see default, use the server default (open in the browser), so here we need to select other option like open in the client application and save this settings.
- Now go back to Library page and open any one document and see the behaviour is as expected or not? In my case I have done
- We can configure the same with Office 365 PowerShell management shell also, below is the command:
Get-SPWeb -site <SiteCollURL> | % {$_.Lists} | where {$_.IrmEnabled -eq $true} | % {$_.DefaultItemOpen =[Microsoft.Sharepoint.DefaultItemOpen]::<DefaultItemOpenSetting>; $_.Update()}
*Change site coolection URL on the coloured object.
Thanks ☺
Healrun is a health news blog we provide the latest news about health, Drugs and latest Diseases and conditions. We update our users with health tips and health products reviews. If you want to know any information about health or health product (Side Effects & Benefits) Feel Free To ask HealRun Support Team.
ReplyDeleteSupplements For Fitness so you never have to worry about someone telling you what I said to my friend.First, your diet should be low in calories and focused on delivering high quality, nutrient-rich foods to your body. You need to cut
ReplyDeletePilpedia is supplying 100 percent original and accurate information at each moment of time around our site and merchandise, and the intent is to improve the usage of good and pure health supplement. For More Info please visit Pilpedia online store.
ReplyDeleteKeto Buzz is a weight reduction supplement known for giving its ketogenic diet and keeping body solid and fit as a fiddle without doing numerous endeavors. Keto Buzz is being concluded as the best product till date, it reduces all unwanted fats giving you better-enhanced metabolism. Kindly Visit on http://www.choosetolose.net/keto-buzz-weight-loss-diet-reviews/
ReplyDeleteHere are some important statistics. Keto Prime Diet It's all cut and dried. Who desires Effective Weight Loss? I don't recognize regarding you, though after I have a belief the primary place I look is Yahoo.
ReplyDeletehttps://www.supplementmegamart.org/keto-prime-diet/
https://www.supplementmegamart.org/
Pure Life Keto is an exceptional weight loss supplement which makes use of some natural ketone salts like Beta-Hydroxybutyrate (BHB).Pure life keto pills are designed to help you reduce weight and improve focus without demanding a lot of effort which is generally required to lose weight.The makers of this amazing weight reduction recipe claim that it facilitates your body to encounter the process of ketosis more efficiently and quickly. This fat burner is based on the latest technology that falls in the category of keto diet trend. Visit On http://www.powerenrich.com/purelife-keto-weight-loss-supplement-pure-life-keto-reviews/
ReplyDeleteScientists have done a large number of learns about structure a solid resistant framework and it is a relative surety that they will keep on doing reads for a long while. Immune Defence Reviews The safe framework is exceptionally convoluted. Immune Defence Its typical capacities appear to, in specific maladies, aggravate conditions. However, feelings regarding that matter fluctuate.
ReplyDeletehttps://www.topbodyproducts.com/immune-defence/
https://twitter.com/body_products/status/1249983234986799106
https://www.linkedin.com/posts/top-body-products-2171451a4_immunesystem-bacteria-covid-activity-6655753259598344192-isFf/
http://topbodyproducts.over-blog.com/immunedefence
https://topbodyproductsreviews.blogspot.com/2020/04/immune-defense-how-it-works-and-its.html
https://www.reddit.com/user/topbodyproducts/comments/g17ye0/immune_defense_reviews/
https://sites.google.com/site/topbodyproducts/immune-defence
Thank you for taking the chance to talk about this, I'm strongly about this and really like having to learn more about this type of field. Do you mind updating your site article with extra insight? It ought to be really beneficial for every one of us.
ReplyDeleteHow To Get Free Robux
https://bayanlarsitesi.com/
ReplyDeleteGöktürk
Yenidoğan
Şemsipaşa
Çağlayan
EİXQ
görüntülü show
ReplyDeleteücretlishow
7JC5
https://istanbulolala.biz/
ReplyDelete3VEEHS
tekirdağ evden eve nakliyat
ReplyDeletekocaeli evden eve nakliyat
yozgat evden eve nakliyat
osmaniye evden eve nakliyat
amasya evden eve nakliyat
İMRJ1
urfa evden eve nakliyat
ReplyDeletemalatya evden eve nakliyat
burdur evden eve nakliyat
kırıkkale evden eve nakliyat
kars evden eve nakliyat
B1OD85
A8285
ReplyDeleteKırşehir Lojistik
Bingöl Lojistik
Bayburt Parça Eşya Taşıma
Yozgat Evden Eve Nakliyat
Ağrı Parça Eşya Taşıma
798C8
ReplyDeleteKastamonu Evden Eve Nakliyat
Kars Evden Eve Nakliyat
Samsun Evden Eve Nakliyat
Kilis Evden Eve Nakliyat
Balıkesir Evden Eve Nakliyat
Sinop Evden Eve Nakliyat
Manisa Evden Eve Nakliyat
Yalova Evden Eve Nakliyat
https://steroidsbuy.net/steroids/
55AA5
ReplyDeleteSilivri Fayans Ustası
Etlik Boya Ustası
Bolu Evden Eve Nakliyat
Uşak Evden Eve Nakliyat
Burdur Şehir İçi Nakliyat
Tunceli Parça Eşya Taşıma
Sakarya Evden Eve Nakliyat
Kırklareli Şehir İçi Nakliyat
Tekirdağ Çatı Ustası
010BA
ReplyDeleteCate Coin Hangi Borsada
Malatya Şehir İçi Nakliyat
Çerkezköy Sineklik
Van Şehir İçi Nakliyat
Antep Parça Eşya Taşıma
Çanakkale Şehir İçi Nakliyat
Şırnak Evden Eve Nakliyat
Giresun Şehirler Arası Nakliyat
Gölbaşı Boya Ustası
72645
ReplyDeleteUşak Parça Eşya Taşıma
Keçiören Parke Ustası
Pancakeswap Güvenilir mi
Sinop Parça Eşya Taşıma
Kalıcı Makyaj
Adana Parça Eşya Taşıma
Keçiören Boya Ustası
Aydın Şehir İçi Nakliyat
Huobi Güvenilir mi
FE8D6
ReplyDeleteİstanbul Şehirler Arası Nakliyat
Pitbull Coin Hangi Borsada
Nevşehir Şehirler Arası Nakliyat
Düzce Şehir İçi Nakliyat
Urfa Şehirler Arası Nakliyat
Big Wolf Coin Hangi Borsada
Karabük Lojistik
Urfa Evden Eve Nakliyat
Ünye Boya Ustası
96C44
ReplyDeleteCoin Kazma
Kripto Para Çıkarma Siteleri
Coin Para Kazanma
Binance Hesap Açma
Kripto Para Madenciliği Siteleri
Binance Komisyon Ne Kadar
Binance Nasıl Kayıt Olunur
Bitcoin Madenciliği Siteleri
Coin Nasıl Çıkarılır
2F4F3
ReplyDeleteBitcoin Üretme Siteleri
Mexc Borsası Güvenilir mi
Kripto Para Madenciliği Nedir
Mexc Borsası Kimin
Kripto Para Üretme
Kripto Para Nedir
Kripto Para Üretme Siteleri
Mexc Borsası Güvenilir mi
Binance Nasıl Oynanır
F4686
ReplyDeletebinance referans kodu
referans kimliği nedir
resimli magnet
binance referans kodu
referans kimliği nedir
resimli magnet
resimli magnet
binance referans kodu
binance referans kodu
FD558
ReplyDeleteArdahan Kadınlarla Sohbet
Çanakkale Parasız Görüntülü Sohbet
malatya ücretsiz sohbet
mobil sohbet odaları
kadınlarla sohbet
samsun ücretsiz sohbet sitesi
Muş Ücretsiz Sohbet Siteleri
bitlis en iyi ücretsiz sohbet siteleri
ücretsiz sohbet uygulamaları
4D0AB
ReplyDeletekırşehir rastgele sohbet uygulaması
sakarya canlı sohbet ücretsiz
kadınlarla görüntülü sohbet
artvin ücretsiz sohbet odaları
Osmaniye Telefonda Kadınlarla Sohbet
bursa canlı sohbet odası
En İyi Ücretsiz Sohbet Uygulamaları
kars sohbet chat
kars mobil sohbet sitesi
1E33B
ReplyDeleteavax
pancakeswap
quickswap
aave
poocoin
poocoin
arculus
poocoin
dexscreener
18CCB
ReplyDeleteparibu
referans kodu
kraken
kizlarla canli sohbet
okex
binance
en az komisyon alan kripto borsası
mobil 4g proxy
canlı sohbet ücretsiz
966B8
ReplyDeleteJanuary 2024 Calendar
January 2024 Calendar
aax
kaldıraç nasıl yapılır
telegram kripto para grupları
en az komisyon alan kripto borsası
bibox
paribu
btcturk