Fix Excel for Mac Links Between OneDrive Workbooks
Question details
The user needs to update links between Excel workbooks stored in separate OneDrive folders.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A destination workbook references values in a source workbook stored in another OneDrive folder.
- Observed behavior
- Excel cannot update the links and reports that the OneDrive URL, Internet connection, or proxy server cannot be found.
Open both workbooks and identify the source cells and formulas that refer to them. Check which OneDrive account contains each file and whether you can open the source workbook.
Move source values to a worksheet in the destination workbook
Use this workaround when Excel for Mac cannot reliably update links between separate OneDrive workbooks.
This removes the dependency on a link between separate workbooks. Update the values on the new worksheet when the source data changes.
In the destination workbook, click the plus button next to the sheet tabs to create a new worksheet.
Open the source workbook, select the required cells, and choose Copy. Return to the new worksheet and use Paste Special > Values.
In the destination workbook, edit each affected formula to refer to the new worksheet, such as ='Source Data'!A1, instead of the external workbook.
Review the updated formula cells and change a source value on the new worksheet to confirm that dependent cells recalculate.

Check OneDrive access and recreate the workbook link
Try this if you want to keep the source and destination in separate workbooks, although this scenario may not be supported in Excel for Mac.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open Excel files and organize source data on another worksheet for an easier transition; it does not fix Excel for Mac's OneDrive link issue.

Frequently Asked Questions
Why can't Excel for Mac update my OneDrive workbook links?
This linked-workbook scenario may not be supported in Excel for Mac. Account access, sharing, or the stored link can also affect whether Excel can find the source.
How can I avoid the external OneDrive link?
Create a worksheet in the destination workbook, copy the source values into it, and edit the destination formulas to reference that worksheet instead.
Will copied values update automatically when the original workbook changes?
No. If you use Paste Special > Values, update the copied values on the new worksheet whenever the original source data changes.
What should I check before recreating the link?
Open both workbooks from OneDrive, verify that they use the same account, and check the source file's Share settings to ensure that account has access.




