Stop People Editing & Downloading Your Files!

Published 2023-04-04
Whether your file is in the cloud or a local network drive, Microsoft has tools to enable you to prevent unauthorised opening, editing and downloading of your data.

More on Excel Workbook Protection: www.myonlinetraininghub.com/excel-workbook-protect…

🔗 LINKS
- Remove Passwords:    • Forgotten your Excel Password? How to...  
- Excel Forms:    • Easy Excel Forms - No VBA & access fr...  
- Embed Excel Files in Web Pages:    • STOP Emailing Excel Files - Securely ...  
- Information Rights Management: learn.microsoft.com/en-us/microsoft-365/compliance…

🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🧟‍♀️ CONNECT with Mynda on LinkedIn: www.linkedin.com/in/myndatreacy/

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS
0:00 How to Securely Share Excel Files
0:26 Password Protection
2:32 Securely Sharing Files from Excel Desktop App
3:18 Blocking Downloading
3:56 Securely Sharing Files from OneDrive
4:30 Securely Sharing from File Explorer
4:47 Allowing Data Entry & Prevent Downloading
5:06 Information Rights Management
5:34 Embedding Files in a

All Comments (15)
  • This is Excellent. Question - is there a way to lock down a sheet containing a table but still allow a non-password viewer to utilize built out Slicers to filter the table(s)? Thank you for all you do!
  • @starry_config
    Do you have any best practices for sharing excel files with links to other data sources? I’ve been using power query a lot more recently and not sure if I’m sharing the final files correctly
  • I have a file, where I want the users to populate data. Full edit access on that tab. A second tab then reorders the data (simple "=" to formula) and add other meta data that we need. Can I protect the second tab with the "=" data on it. I tried a few different ways, but it looks like the static data is password protected, but not the cells with the "=" formulas in them.
  • Thanks Mynda.I have a question, maybe for another video: Can you protect a hidden sheet with a password? I tried File Info, protect workbook structure. That works fine. But the user can not find this hidden sheet anymore. So the only way to solve this is to unprotect the whole file. greetings Bart
  • @jeffreywong1725
    Hi Great Video, I tried to share a video in sharepoint but the problem is that even i set to view only and block download, user still able to " Copy " the video which essentially download ? Is there a way to prevent that ?
  • @NK-qk8cn
    Is the block download option in onedrive offered with business account only?
  • @tegarnalle6888
    hallo madam, is there any alternative tip for restricting edit those office files in the same folder/or even bunch of office files automatically?
  • @shoppersdream
    Nice, thanks! Mynda, I have a Pivot Table with Data source with over 40 to 50 columns and I am instructed not to send the whole Data Source to other Groups I can send them maybe 15 columns and one column has over 30 Names and I need to send maybe 10 of them by filtering that field. Others are not supposed to see those 30 names so what is my best option? Is there any way that rather than going through the whole process with fewer columns and filtered columns, I hide those columns which I should not be sending but I don't even want them to see that they exist. Hide and Unhide won't work. They will be using double click to see the details but, in those details, I don't want them to see the hidden columns? Is it possible, or not? Thanks
  • @YusufMumtaz
    OneDrive Personal does not have a block download option.
  • @tstansfi
    Tools when saving a file! Everyday is a school day.... But I think the link to embed excel files in webpage is incorrect.