Microsoft Word Paste Link Fails with Excel Cells

Hello David Holley,

I understand how disruptive this is, especially when the Excel-to-Word links previously updated automatically.

A linked Excel object in Word stores the location of the source workbook. If OneDrive changes how that location is resolved, Word may no longer be able to find the source and can display “Error! Not a valid link.” However, I could not find an official Microsoft notice confirming this specific behavior as a known OneDrive bug or providing a date for a fix.

Please try the following:

1. Make sure both files are fully downloaded to the computer and available offline, rather than shown as online-only OneDrive files.
2. Open the Excel workbook first, and then open the Word document.
3. In Word, select File > Info > Edit Links to Files, if that option is available.
4. Select the affected Excel link, choose Change Source, and select the current Excel workbook from its OneDrive-synced folder.
5. Choose Update Now, save the Word document, close both applications, and test again.

If Edit Links to Files is unavailable or the repaired link breaks again, create a small test workbook and Word document in the same OneDrive folder and recreate the link using Paste Special > Paste Link > Microsoft Excel Worksheet Object. This can help determine whether the issue affects the existing documents specifically or all linked files in the OneDrive location.

Moving the files outside OneDrive can be used as a temporary diagnostic test, but I agree that it is not an ideal permanent solution. If the behavior also occurs with newly created files, please report it through Word > File > Feedback.

Feel free reply back to this post if you need further assistance, I'll be happy to help.

I did as you requested. The links seem to work for a while but break later. I noticed the Source File uses the OneDrive location even though my Spreadsheet is on my local drive. I'm guessing that's the problem - the OneDrive location changes arbitrarily and that breaks the links. I've tried hitting the Change Source button and pointing to my local file. It shows that file in the Source file field but when I hit OK, it says the source file cannot be found.

I've tried many options to fix this (some with the help of AI) and nothing seems to work. There are other posts talking about this same issue. Gemini (Google's AI tool), after sending me down the wrong path several times concluded that there is not workaround except moving the files out of a location managed by OneDrive. I'm surprised that there's not a problem documented with a time for a fix. I pay for an Office 365 subscription. This is the first time I've asked for help and am disappointed with the lack of support to fix, or at least, acknowledge the problem.

As I originally stated, this is are recent problem - starting sometime in August. Prior to that, it worked fine. This has caused me a lot of wasted time and effort trying to fix the problem. Now I just paste the values in every time my Excel values change - which is a lot of manual effort that should not be necessary.