Home

Publish Excel file online, but restrict opening in desktop app

%3CLINGO-SUB%20id%3D%22lingo-sub-834224%22%20slang%3D%22en-US%22%3EPublish%20Excel%20file%20online%2C%20but%20restrict%20opening%20in%20desktop%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834224%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20publish%20an%20excel%20model%20to%20a%20sharepoint%20site%20where%20people%20can%20interact%20with%20it%20using%20Excel%20Online.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20there%20a%20way%20to%20do%20this%2C%20but%20where%20I%20prevent%20people%20from%20opening%20the%20file%20in%20the%20Excel%20Desktop%20application%3F%26nbsp%3B%20The%20reason%20I%20want%20to%20do%20this%20is%20because%20there%20is%20sensitive%20information%20in%20some%20hidden%20sheets.%26nbsp%3B%20Although%20these%20can%20be%20password%20protected%2C%20there%20are%20ways%20around%20that%20if%20people%20are%20able%20to%20download%20the%20file.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScott%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-834224%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834600%22%20slang%3D%22en-US%22%3ERe%3A%20Publish%20Excel%20file%20online%2C%20but%20restrict%20opening%20in%20desktop%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834600%22%20slang%3D%22en-US%22%3EAre%20you%20positive%20people%20will%20not%20be%20able%20to%20view%20those%20tabs%20in%20On-line%20Excel%3F%3CBR%20%2F%3EYou%20should%20be%20able%20to%20change%20the%20user%20rights%20of%20the%20sharepoint%20library%2C%20but%20I%20am%20not%20sure%20if%20blocking%20access%20to%20edit%20on-line%20is%20one%20of%20them.%20You%20can%20set%20the%20default%20to%20work%20on-line%2C%20but%20that%20is%20already%20the%20default.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835607%22%20slang%3D%22en-US%22%3ERe%3A%20Publish%20Excel%20file%20online%2C%20but%20restrict%20opening%20in%20desktop%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835607%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20reply%20Jan.%26nbsp%3B%20As%20far%20as%20I%20see%2C%20there%20is%20not%20an%20option%20to%20restrict%20'opening%20in%20desktop'%20or%20downloading%20the%20file.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-836341%22%20slang%3D%22en-US%22%3ERe%3A%20Publish%20Excel%20file%20online%2C%20but%20restrict%20opening%20in%20desktop%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-836341%22%20slang%3D%22en-US%22%3EI%20would%20advise%20to%20remove%20the%20sensitive%20data%20from%20the%20file.%20Excel%20protection%20is%20too%20poor%20to%20prevent%20people%20from%20getting%20at%20sensitive%20data%20within%20the%20file%20once%20they've%20succeeded%20to%20open%20the%20file.%3C%2FLINGO-BODY%3E
ScottUx
New Contributor

Hello, 

 

I would like to publish an excel model to a sharepoint site where people can interact with it using Excel Online.  

 

It there a way to do this, but where I prevent people from opening the file in the Excel Desktop application?  The reason I want to do this is because there is sensitive information in some hidden sheets.  Although these can be password protected, there are ways around that if people are able to download the file.  

 

Thanks!

 

Scott

3 Replies
Are you positive people will not be able to view those tabs in On-line Excel?
You should be able to change the user rights of the sharepoint library, but I am not sure if blocking access to edit on-line is one of them. You can set the default to work on-line, but that is already the default.

@Jan Karel Pieterse Thanks for the reply Jan.  As far as I see, there is not an option to restrict 'opening in desktop' or downloading the file.  

I would advise to remove the sensitive data from the file. Excel protection is too poor to prevent people from getting at sensitive data within the file once they've succeeded to open the file.