Office for Mac Issues

Fix Excel for Mac Links Between OneDrive Workbooks

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 868 views

Question details

The user needs to update links between Excel workbooks stored in separate OneDrive folders.

Fix Excel for Mac Links Between OneDrive Workbooks
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.
Before you start

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.

Solution 1Recommended

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.

1
Add a source worksheet

In the destination workbook, click the plus button next to the sheet tabs to create a new worksheet.

2
Copy the source values

Open the source workbook, select the required cells, and choose Copy. Return to the new worksheet and use Paste Special > Values.

3
Replace external references

In the destination workbook, edit each affected formula to refer to the new worksheet, such as ='Source Data'!A1, instead of the external workbook.

4
Check the results

Review the updated formula cells and change a source value on the new worksheet to confirm that dependent cells recalculate.

Move source values to a worksheet in the destination workbook
Free Microsoft Office alternative

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.

Keep related source values and formulas in worksheets within one workbookOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet tools for a smoother transitionWork with a free, lightweight Office alternative
QA img-9

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.