Installation steps to automatically save Excel files to OneDrive

Unlike Google Sheets, which automatically saves data according to the input operation, with Excel we will have to manually save it to a folder on the computer. If you are using Microsoft 365 version, you can set up the mode to automatically save Excel files to your OneDrive account. Then we will not worry about losing the content we just entered in the Excel data table. The following article will guide you how to automatically save files to OneDrive.

Instructions to save Excel files automatically to OneDrive

Step 1:

At the interface on Excel, click File in the top left corner and then click New .

Step 2:

Next we click on the empty Excel file next to it or click right on the Excel file shown below to open the Excel file.

Step 3:

Looking to the top will see the AutoSave feature is off. Please turn this button to On mode to enable automatic saving of Excel files.

Step 4:

Now display the interface asking where you want to set up the mode to automatically save files, we click on the OneDrive storage service . Finally, enter a name for the Excel document .

So when working on Excel, the content is automatically saved.

Step 5:

In case you want to change back to the file storage folder in OneDrive without trying to save it to a default folder, we click on File , select Save a Copy and then select OneDrive .

Step 6:

Now display the new interface, click New Folder to create a new file storage folder in OneDrive.

After creating the folder, click on the folder and then select Save to save the Excel file to this folder.

Then we will return to the interface to work with the Excel file. You click on the file name at the top and you will see the folder to save the new file that you just set up.

Good luck.

David Pac

Update 01 June 2021