OneDrive Excel

Last Updated :

-

Blog Author :

WallStreetMojo Team

Edited by :

Ashish Kumar Srivastav

Reviewed by :

Dheeraj Vaidya, CFA, FRM

Table Of Contents

arrow

What Is OneDrive Excel?

OneDrive in Excel is used to connect all files. Users can share, protect and save excel files in Microsoft OneDrive and can easily access over internet. The OneDrive app can also be downloaded and used on mobile phones.

In this article, let us learn how to use OneDrive in Excel.

Table of contents
  1. One Drive file can be accessed anywhere if one has an internet connection and a gadget. OneDrive offers 15 GB of free cloud storage and makes sharing files with social networks easy.
  2. It works well for individuals but has limitations for sharing. Use a strong password, don't share unnecessary data, and be mindful that files can be modified during upload to prevent misuse.
  3. Limit online file sharing to trusted users. Confirm successful uploads before accessing files online. Regularly back up files and use the OneDrive app for mobiles, but carefully select the sync folder.

How To Save Excel Files In Microsoft OneDrive?

Let us follow the below steps.

  1. When saving the file, click on the "File" option and see the option "Save" or "Save As."


    onedrive example 1.1

  2. Go to the "Save As" option in Excel and choose "OneDrive" on the upper right-hand side.


    onedrive example 1.2

  3. Click "Sign In" and insert details if you are a registered Microsoft account user.


    onedrive example 1.3

  4. Enter the email address/contact number to sign in. If you are already a registered user of OneDrive:


    onedrive example 1.4

  5. Enter a password, and you can now use Microsoft Excel OneDrive.


    onedrive example 1.5

  6. If you are not registered with this online platform, click "Sign up" to register an account or use the link: https://onedrive.live.com.


    example 1.6

  7. Click on "Sign up for free."


    example 1.7

  8. Create the account by filling in the necessary details in the required box if you have an Outlook.com or Xbox live account. No need to sign up for a new account.


    example 1.8

  9. We can sign up for the account with a phone or email address and need to verify the email address by entering the verification code.

  10. After signing up for the account, you can now access the OneDrive files.


    example 1.9

  11. Once you click, as shown above, it will directly go to files already on the computer.


    example 1.10

  12. Select the folder and Save the file.

  13. You can easily edit this file online, even without installing the Excel software on the computer.

How To Open OneDrive Excel Files Online?

  1. We must open the web browser and use the web address onedrive.com.
  2. Then, we must select the folder where we have saved the file, click on the "File," open it, and start working on your file.

Benefits Of Using OneDrive Excel

  • We can access the file anywhere if the internet connects and the gadget is with us.
  • OneDrive is private until and unless we won't share it with anyone.
  • It provides us free storage of up to 15 GB.
  • It can store any file, whether it is documented, Excel files, word documents, photos, videos, etc.
  • We can easily share the data with anyone.
  • We can link the OneDrive account with social network sites.

Drawbacks Of Using OneDrive Excel

  • OneDrive functions well for the individual yet is restricted when sharing documents with colleagues, customers/providers/stakeholders.
  • Users must follow some standard security measures to avoid any misuse of their files by others, so they should use a strong password.
  • We always try to share the required data with others, not to share all our files with others.
  • While the files are synced with OneDrive, they get altered while uploading them on the Drive.

Important Things To Note

  1. We must share the file with trusted users only.
  2. While working online, there is no need to save the file manually. Instead, it gets automatically saved on a server.
  3. When saving the files online, ensure we upload the file successfully; otherwise, we will not be able to access the file online.
  4. We must always make sure to take a backup of the files.
  5. We must always check which folder we want to sync with OneDrive.

Frequently Asked Questions

1. Can I share OneDrive file with someone who doesn't have OneDrive?

To allow anyone who receives the sharing link to access the content, choose the "Anyone with the link" option in the Link settings. This means that the recipients won't require a Microsoft account and can access the content without having to enter a passcode or sign in.

2. How do I protect Excel in OneDrive?

To protect a workbook, follow these simple steps:
Click on ‘File’, then ‘Info.’
2. Select Protect Workbook, then choose Encrypt with Password.
3. Enter your desired password in the box, then click ‘OK.’
4. Confirm your password by reentering it in the box, then click ‘OK’ again.

3. How do I add a password to OneDrive Excel?

To protect a sheet or workbook, first open it. Then, go to the Review tab and click on the "Protect Sheet" or "Protect Workbook" option. In the ‘Password’ box, type a password, and in the ‘Verify’ box, type the same password again to confirm it. You can also choose any other protection options you want. Once done, click ‘OK.’ Finally, remember to save your work.