Share via

Storing docs on OneDrive breaks Linked and Embedded Excel data in Word and PowerPoint (OLE and OneDrive/SharePoint incompatibility)

GraniteStateColin 221 Reputation points
2026-01-29T20:11:54.19+00:00

Before OneDrive and SharePoint document Libraries, Microsoft fully supported a brilliant system many of us know as OLE -- Object Linking and Embedding. You could select a range of cells or a graph in Excel, then simply Paste Special -> Paste Link or Paste Image (Linked) in Word or PowerPoint, and it would appear exactly as it did in Excel, and any changes to the Excel file would automatically change it in the Word or PowerPoint Document. Brilliant. Beautiful. Nearly perfect. I've used it since the '90s. And this could go just as well in any other direction, such as if you wanted some PPTX slides or DOCX instructions in your Excel file. It also works across many more applications than just the big 3, e.g., Outlook, MS Project, and third-party apps like Corel Draw.

It still works today, but ONLY properly for documents that are only on a local drive. If moved to OneDrive (personal or business), SharePoint, or any other Microsoft-provided online storage system, the links all break following anything that modifies them (sometimes just making a change to the document seems to update them and the links break), because they get assigned GUID-looking http addresses instead of the traditional c:\Users\username\Documents\sourcefile.xlsx for the object, which the hosting document then can no longer resolve. Basically, in moving documents to the cloud, we lose this as one of the key advantages Office has had over competing office suites.

In searching for a solution to this problem, I see plenty of posts asking for solutions, with no good answers. In checking with Copilot, it says it's a known problem with no good solution.

My questions here are:

  1. MOST IMPORTANT: Is there any work-around? E.g., I've seen hints that if you paste as an image, it may be less likely to break, but I've not gotten than to work. I've seen other posts suggesting locking the objects to prevent linking, but I've not gotten that to work either (and maybe it defeat the whole point of linking and embedding). Perhaps there's a modern alternative to OLE that performs the same function and is intended to work for online documents?
  2. Does MS realize they broke this and do they have any intent to fix or provide a modern alternative (other than adding Dark Mode to Excel, they seem to be in let-those old Office apps die slowly mode at MS)? Other than Copilot saying it's a known issue, I've not seen it acknowledged publicly by MS.
  3. I've already reported this in the Feedback Hub. Is there anything else we can do to make sure that MS is at least aware that their recommendations for cloud storage break this core functionality of Office that's been there for decades?
Microsoft 365 and Office | Word | For home | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. John Korchok 232.7K Reputation points Volunteer Moderator
    2026-01-29T20:43:08.41+00:00

    There's no one here in a decision-making role at Microsoft, so we can't answer your questions.

    Unfortunately, OLE is now very old technology, written long before the internet and cloud storage were invented. It only works in Office for Windows and in a very lame fashion in Office for Mac. It doesn't work at all in the mobile versions of Office. My guess is that if and when it is replaced, it would have to be by a totally different method.

    Was this answer helpful?

    1 person found this answer helpful.

  2. AI answer

    2026-01-29T20:12:15.5166667+00:00

    Currently, the issue you are experiencing with Object Linking and Embedding (OLE) in Microsoft Office applications when using OneDrive or SharePoint is a known limitation. When documents are moved to cloud storage, the links can break due to the change in the file path format, which affects the ability to resolve linked objects.

    Workarounds:

    1. Paste as Image: While you mentioned trying to paste as an image, this method may not maintain the dynamic link that OLE provides. However, it can be a viable alternative if you only need a static representation of the data.
    2. Locking Objects: Locking the objects may prevent them from being modified, but it can also defeat the purpose of linking and embedding, as you noted. This approach may not be ideal if you want the data to update automatically.
    3. Local Storage: For the best compatibility with OLE, consider keeping your documents on a local drive when you need to maintain dynamic links. After making necessary updates, you can then upload the files to OneDrive or SharePoint if needed.

    Microsoft’s Awareness and Future Fixes:

    As for whether Microsoft is aware of this issue, it has been acknowledged as a limitation, but there has been no official statement regarding a fix or a modern alternative to OLE that would work seamlessly with cloud storage. Your feedback through the Feedback Hub is a good step in bringing attention to this issue, and continuing to report such problems can help raise awareness within Microsoft.

    Additional Steps:

    In addition to using the Feedback Hub, consider participating in Microsoft community forums or user groups where you can share your experiences and gather support from other users facing similar challenges. This collective feedback can sometimes prompt quicker responses from Microsoft.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.