How to Move an Excel Workbook from SharePoint to OneDrive

A folder with a move arrow

Summary

This post shows you how to move an Excel workbook from SharePoint to your OneDrive by using SharePoint's Move to command.

By default, Alerts for Excel monitors only workbooks saved in your own OneDrive. When you open a workbook stored in SharePoint, the pane displays This workbook is outside your OneDrive.

Excel with a SharePoint workbook open and the Alerts for Excel pane showing This workbook is outside your OneDrive

To move the workbook:

  1. Close the workbook in Excel, and ask teammates to close it too.
  2. In the SharePoint library, move the workbook to My files with Move to, keeping Keep sharing with the same people checked.
  3. In OneDrive, check who has access and share the workbook with any missing teammates.
  4. Open the workbook from OneDrive, then open Alerts in Excel.

Using SharePoint's Move to command (instead of File > Save a Copy in Excel) moves the original workbook with its version history intact. SharePoint carries over direct shares automatically, while teammates who had access through the SharePoint site lose access until you share the moved file with them.

If the workbook must stay in SharePoint, contact support and we'll help your Microsoft 365 admin enable SharePoint access for your organization.

Move the workbook to your OneDrive

  1. Close the workbook in Excel, and ask teammates to close it too. If someone leaves the workbook open during the move, their Excel window keeps the old SharePoint address and shows UPLOAD FAILED on the next edit.
  2. In your browser, open the SharePoint library that contains the workbook.
  3. Select the workbook (1), then select Move to (2) in the command bar.
SharePoint document library with numbered red boxes around the selected workbook and the Move to command
  1. Select My files (1), check Keep sharing with the same people (2), and select Move here (3).
SharePoint's Move to dialog with numbered red boxes around My files, the Keep sharing with the same people checkbox, and the Move here button

SharePoint shows Moved 1 item to My files, and the workbook moves to your OneDrive with its version history intact.

Do not use File > Save a Copy in Excel. Save a Copy leaves the original workbook in SharePoint and switches your Excel window to a separate OneDrive copy without version history. Alerts for Excel then monitors only that copy while teammates keep editing the original in SharePoint, so their changes never trigger your alerts.

Check who has access

Keep sharing with the same people preserves access for anyone you shared the workbook with directly. Permissions from the SharePoint site do not carry over, so share the workbook in OneDrive with any teammates who had access through the site.

  1. Open My files in OneDrive. To see who already has access, select ... beside the workbook, then select Manage access.
  2. To add missing teammates, select the workbook, then select Share.
  3. Enter a name, group, or email for each missing teammate (1), then select Send (2). The default Can edit permission lets them continue editing.
OneDrive's Share dialog with numbered red boxes around the people field and the Send button

Alerts for Excel monitors this shared workbook in your OneDrive, including any changes your teammates save.

Open the workbook from OneDrive

  1. In OneDrive, open My files, select the workbook, then select Open > Open in Excel.
  2. Select Alerts on the Home tab. The pane opens to Checks, where you can select Add to set up your alerts.
Excel with the moved workbook open from OneDrive and the Alerts for Excel pane showing an empty list of checks with an Add button

For help with Alerts for Excel, contact support.