Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2022, 07:30 AM
Fabulist Fabulist is offline All linked objects in all documents stopped updating Windows 10 All linked objects in all documents stopped updating Office 2019
Advanced Beginner
All linked objects in all documents stopped updating
 
Join Date: Sep 2015
Posts: 33
Fabulist is on a distinguished road
Default All linked objects in all documents stopped updating

Hello everyone,



I am not sure if this relates to the latest Office (2021) update or not, but I am suddenly unable to update any Excel linked object on any Word document.

All Excel linked objects present the "Object" right click context option, instead of the "Linked Macro-enabled.." context option.

What does not work, that worked until recently:
1) Manually clicking on "Update Link".
2) Macros that automatically update all linked items.

What works:
1) Double-clicking on any Excel linked object (hence redirecting to the linked file and sheet), will afterwards allow it to update normally and will also make the "Linked Macro-enabled.." context option available again.
2) Setting the Excel linked object to "Automatic update" instead of "Manual update" in Word's links, will make all Excel linked objects work normally again, including the "Linked Macro-enabled.." context option.

> Having the linked Excel files open or closed in advance, makes no difference.
> Setting Word to have links automatically updated on open or not, also makes no difference.

Anyone experiencing this?

Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
All linked objects in all documents stopped updating Replace Embedded Objects with Linked Objects hicksi Word 3 09-29-2021 07:17 PM
Save and exiting corrupts linked objects Fabulist Word 0 07-25-2016 04:35 PM
All linked objects in all documents stopped updating Updating/Format Objects ptmuldoon Word VBA 4 01-22-2015 08:39 PM
Converting linked objects to embedded in Word 2010 wduvall Word 0 01-15-2014 03:50 PM
automate selection of new source for linked objects strebewi PowerPoint 0 08-03-2011 06:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft