'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Word for Mac Showing Invalid Excel Links (Update Error)
Question details
The user is experiencing invalid or blank links in Word for Mac when trying to update connections to an Excel workbook stored in OneDrive.
- Product
- Microsoft Word for Mac
- Device & OS
- macOS
- Scenario
- Updating data links in a Word document connected to a local Excel workbook synced via OneDrive.
- Observed behavior
- Links turn blank, get removed, or display "Error! Not a valid link." Additionally, Microsoft AutoUpdate incorrectly reports that updates are temporarily unavailable.
Ensure you have a stable internet connection and save a local backup copy of your Word document and Excel workbook before making any software updates.
Manually Update Microsoft AutoUpdate
If your Microsoft AutoUpdate version is outdated (below 4.65), it will fail to fetch the latest Office fixes required for OneDrive links to work correctly.
Microsoft AutoUpdate is responsible for keeping your Office applications up to date. When this tool becomes too old, it can no longer communicate with Microsoft's servers, causing false "temporarily unavailable" errors and preventing critical bug fixes from being installed.
Launch any Office app, such as Microsoft Word. Click 'Help' in the top Mac menu bar, and select 'Check for Updates'.
In the update window, click 'Microsoft AutoUpdate' in the top menu bar, select 'About Microsoft AutoUpdate', and check the version number.
If the version is below 4.65, download the latest Microsoft AutoUpdate package directly from the official Microsoft Mac update CDN.
Run the downloaded installer package. Once the installation is complete, restart your Mac, open Word, and test updating the linked documents again.
Try WPS Office for Seamless Word and Excel Integration on Mac
If Microsoft 365 update errors and broken OneDrive links disrupt your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with excellent support for linking documents and spreadsheets without complex update hurdles.
- 1. Download and Install: Visit the WPS Office website and download the macOS version.
- 2. Open Existing Files: Launch WPS Office and open your existing .docx and .xlsx files directly without any conversion.
- 3. Link Data Easily: Copy data from your WPS Spreadsheet and paste it into WPS Writer using the 'Paste Special' option to maintain active, reliable links.
Frequently Asked Questions
Why does Word for Mac say "Error! Not a valid link" for my Excel data?
This usually happens when the source Excel file is moved, renamed, or stored in a cloud directory like OneDrive that is experiencing sync delays. It can also occur if your Office applications are missing critical bug fixes due to an outdated AutoUpdate tool.
What should I do if reinstalling Microsoft 365 fails on my Mac?
Instead of completely reinstalling Microsoft 365, focus on manually updating the Microsoft AutoUpdate tool first. Outdated update agents often block successful installations and prevent Office apps from functioning properly.
Can I link Excel cells to Word without relying on OneDrive?
Yes. You can move both the Word document and the Excel workbook to a local folder on your Mac's hard drive. Re-establish the links by copying the Excel cells and using 'Paste Special' > 'Paste Link' in Word to avoid cloud syncing conflicts altogether.
