To save a copy of your workbook from OneDrive to your computer, you will first need to download it.
After downloading the workbook, you can open the workbook and make any changes—if you have Excel desktop application. Don’t have Excel desktop application? Not a problem, try it out at Office.com.
Follow these steps:
Click File > Save As > Download a Copy.
Excel asks whether to open or save the workbook. Click Save.
Note: If you click Open instead of Save, the workbook will open in Protected View.
You can either open the workbook or open the folder containing the workbook. Open the folder if you first want to rename or move the workbook to another location.
Open the workbook
Follow these steps to open a workbook:
After downloading your workbook, click File > Open.
In the yellow Protected View bar, click Enable Editing.
Click File > Save As > Browse.
Choose a folder where you want to save the workbook.
In the File name box, type a name.
Open the folder
After downloading your workbook, click Open folder and do one of the following:
To rename the workbook, select the workbook, click Rename, and type a new name.
To move the workbook, select the workbook and click Move to, and choose a new location.
Note: The Ribbon must be displayed in the Downloads window to see the rename and move options. If you don't see the Ribbon, click the View tab at the very top of the window (see the figure above), and then click the pushpin icon on the right. The Rename and Move options will appear on the Home tab.