problem with linked excel worksheet object in word changing to object and then link not updating

Anonymous
2022-08-10T04:02:31+00:00

I have used linked excel tables or worksheet object in word documents for years without any issues until yesterday 8/8/22.

Out of nowhere the "Linked Worksheet Object", or the excel table that I linked into word (paste special > paste link > microsoft excel worksheet object), changed to an "object" after the word doc was saved, closed and opened again.

Before yesterday, I could right-click on the linked table, or "Linked Worksheet Object", and select "Update Link" and any changes I made to the table in the linked excel file would appear in the word doc. Now, I right-click on what is now an "object" and select "Update Link" and nothing happens. Strangely, if I right-click on the linked table, select "object", then "Links...", and then "Open Source", the "object" reverts back to a "Linked Worksheet Object" and updates as usual.

But after saving, closing, and opening the word document again the "Linked Worksheet Object" changes back to an "object" again and I have to take the same steps to update a linked table in word after changes made to it in excel.

This is happening in the Word and Excel provided by the Microsoft 365 Personal subscription. I am using a Dell Latitude 3500 and Surface Pro 7 under this subscription but am only having this issue when using the Dell Latitude 3500. I have checked all the Options in Word & Excel and they are the same on both computers. I have also checked the Registry Editor and everything related to Word & Excel looks to be the same on both.

What is going on? Better yet, how do I fix this and get back to normal?

Microsoft 365 and Office | Word | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

53 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2022-08-11T19:38:41+00:00

    Thanks Clarence but that did not fix the problem I am having.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-08-11T19:58:16+00:00

    Try this steps. Select data in excel copy > go in word > go in paste option > paste special > paste link > as > Microsoft Excel Worksheet Object > ok

    Let me know if it helps resolve your query.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-08-11T20:50:50+00:00

    This does not fix it. Please see my original post where I explained how I inserted this table that way but after saving, closing, and opening the file it changes to an "object".

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2022-08-11T20:59:21+00:00

    David,

    We are having the same problem in our office, as well. We're also on Version 2207. So frustrating. We are going to try reinstalling Office 365.

    K

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-08-11T21:36:10+00:00

    Thank you for letting me know! I was about to lose my mind trying to figure out what the heck changed on my end. Maybe is a bug on Microsoft's end that will somehow be fixed soon. I uninstalled some of the recent updates to match what was on my laptop that somehow still works but that didnt fix it either. I have reinstalled 365 too but that didnt work. I am thinking about wiping computer and reinstalling windows.

    Anyways, I will keep you posted on any progress on my end. Please keep me posted on anything you find out.

    Thanks again!

    Was this answer helpful?

    0 comments