• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Securely Share Excel Files

You are here: Home / Excel / Securely Share Excel Files
Securely Share Excel Files
April 5, 2023 by Mynda Treacy

In today's world, where remote work has become increasingly common, the need to securely share files with multiple people has never been greater.

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.

Table of Contents

  • How to Securely Share Excel Files Video Tutorial
  • Password Protect File Open and or Edit
  • Securely Share Files Online (set editing and download rules)
  • Allow Data Entry and Prevent Downloading
  • Information Rights Management (IRM)
  • Embedding Excel Files in a Web Page


How to Securely Share Excel Files Video Tutorial

Subscribe YouTube

Password Protect File Open and Edit

Files saved on OneDrive/SharePoint, a local network drive or even your hard drive can be password protected.

The password can be set at the Save As dialog box > Tools > General Options:

set password on excel file

If you want to password protect both opening and editing the file, enter the password in both fields 3 and 4 shown in the image above.

If you only want to prevent editing, simply enter the password in the ‘Password to modify’ field.

Likewise, if you only want to prevent opening the file by unauthorised users, only enter the password at the ‘Password to open’ field.

You’ll be prompted to enter the passwords again to verify them.

Note: when a workbook has password protection to open the file, AutoSave is disabled.

IMPORTANT: if you forget the password to open the file it is very unlikely you will be able to recover it, so be sure to make a note of it in a secure password vault. However, if you forget the password to edit the file, you can use these techniques to remove the Excel password protection.

Retrospective Password Protection

If you have already saved the file, you can add password protection via the File tab > Info > Protect Workbook.

Prevent editing by selecting ‘Always Open Read-Only’ (shown at 3 in the image below) and prevent opening by selecting ‘Encrypt with Password’ (shown at 4 in the image below):

set password on excel file that's already saved

Next time the file is opened you’ll be prompted to enter the password.

Just note that the read only option here doesn’t require the user to enter a password to edit the file, and they can simply enable editing by dismissing the notification.

If you want to restrict editing to specific users, then you’re best to set a password for editing via the Save As dialog box.

Securely Share Files Online

Microsoft OneDrive and SharePoint users can securely share files with restrictions on opening, editing, copying and sharing data.

These options are available in the file sharing settings accessible from within Excel (and Word, PowerPoint etc.), File Explorer, or online in OneDrive and SharePoint.

Excel Desktop App

To securely share an Excel file from the desktop app, click on the Share icon in the top right:

securely share excel file from desktop app share icon

Or via the File tab > Share:

securely share excel file from desktop app file share menu

This opens the Send Link dialog box where you can enter a name of someone or group inside your organisation, or email address of someone inside or outside of your organisation (1), then specify the editing rights (2):

specify rights in send link dialog

For more sharing restrictions open the Sharing Settings (3 in the image above), which opens this dialog box:

sharing settings

Here you can set an expiration date for the access (1), a password to open and edit the file (2) and prevent downloading of the file (3).

Once you’re happy with the settings, click Apply and you’ll be taken back to the Share dialog box where you can add a message (1), email the link via Outlook (2) or copy the link for sharing (3).

finalize settings for send link

Sharing via OneDrive or SharePoint

You can share a file or folder directly from OneDrive or SharePoint online via the Share button at the top of the screen, or the Share icon that appears when you hover over a file name:

sharing an excel file from onedrive or sharepoint

The same Send Link dialog box opens where you can specify who has access and modify settings:

send link settings for sharing an excel file from onedrive or sharepoint

These screenshots are from OneDrive, but the experience in SharePoint is the same.

Sharing Files and Folders from File Explorer

If you have the OneDrive sync app installed, you can access the same sharing tool from the File Explorer.

Right click on the file then click the ‘Share’ icon at the top in Windows 11 as shown in the image below.

Note: In Windows 10 the Share option will be listed in the right click menu items.

share a file using right click menu

Allow Data Entry and Prevent Downloading

Unfortunately, allowing data entry but preventing downloading isn’t possible. Instead, you may find using Excel Forms is a better way to collect data from users.

Information Rights Management

If you need to take your data security up a notch further or want to restrict how employees use or distribute files in general, you might like to look into Information Rights Management (IRM).

IRM can be set at the SharePoint Library or List level and applies to Office documents like Excel, Word, PowerPoint and PDFs.

Click here for more on securing your data with Information Rights Management.

Securely Embedding Excel Files

Embedding Excel files in a web page is another great way to securely share reports.

All you need to do is save your file on OneDrive or SharePoint and get the embed code.

There are different approaches required depending on whether you have OneDrive Personal, or OneDrive for Business or SharePoint. The latter two offer more security and bigger file sizes.

Subscribe YouTube
Securely Share Excel Files

More Excel Posts

linear regression

Excel Linear Regression

Excel linear regression is easy with the built-in tools. Use charts to plot linear regression or use the Data Analysis Toolpak.
speed up slow excel files

How to Improve Excel Performance

How to improve Excel performance and the various causes of slow Excel files so you can speed up Excel and avoid problems in future.
excel check boxes

Interactive Excel Check Boxes

Excel check boxes are interactive elements you can link to formulas, charts, conditional formatting and more.
tips for working in multiple excel files

Hacks for Working in Multiple Excel Files

Awesome tips for navigating, arranging and working in multiple Excel files. Guaranteed to streamline your workflow and increase productivity.
chatgpt for excel

ChatGPT for Excel

Using ChatGPT for Excel can be hit and miss. Learn the best uses for ChatGPT to make your Excel life easier and what to avoid using it for.
excel templates

Where to Find Free Excel Templates

Where to find free Excel templates and how to create your own Excel templates. Using templates saves time and effort.
Easily Remove Password Protection from Excel Files

Easily Remove Excel Password Protection

How to remove Excel password protection when you’ve forgotten the password. Works for sheets, workbooks and read only files.
Import data from a picture to Excel

Import Data from a Picture to Excel

Import data from a picture to Excel. Works with pictures from a file or the clipboard and loads it to the spreadsheet.
excel online

5 Excel Online Features Better than Desktop

5 Excel Online Features Better than Desktop including searchable data validation, track changes, single line ribbon and more.

10 Common Excel Mistakes to Avoid

10 common Excel mistakes to avoid, including merge cells, external links, formatting entire rows/columns and more.


Category: Excel
Previous Post:excel check boxesInteractive Excel Check Boxes
Next Post:Project Management Dashboard Dynamic Periodsexcel project management dashboard custom periods

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

239 Excel Keyboard Shortcuts

Download Free PDF

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.