#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |