Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2022, 08:56 AM
andrewjmdata andrewjmdata is offline Excel sheet embedded into word - changes not reflected in word Windows 10 Excel sheet embedded into word - changes not reflected in word Office 2021
Novice
Excel sheet embedded into word - changes not reflected in word
 
Join Date: May 2022
Posts: 5
andrewjmdata is on a distinguished road
Default Excel sheet embedded into word - changes not reflected in word

Hi, I embedded an xl worksheet into a word doc by linking.



At that point in time, when I have both the word doc and xl doc open, if I change values in xl, they change in word. This is what I want.

However, if I close the xl doc and then reopen the xl doc and then change the values in the xl doc, there is no corresponding change in the word doc.

I am pretty sure I have linked them correctly, just looks like the link fails when I close and reopen the xls.

Both the xls and word doc are stored in SharePoint.

Any ideas?

Thanks Andrew
Reply With Quote
  #2  
Old 05-23-2022, 11:47 PM
wiganken wiganken is offline Excel sheet embedded into word - changes not reflected in word Windows 11 Excel sheet embedded into word - changes not reflected in word Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Maybe it is a SharePoint issue and not a Word issue? Be interesting to see what experts say.
Reply With Quote
  #3  
Old 05-24-2022, 02:15 AM
andrewjmdata andrewjmdata is offline Excel sheet embedded into word - changes not reflected in word Windows 10 Excel sheet embedded into word - changes not reflected in word Office 2021
Novice
Excel sheet embedded into word - changes not reflected in word
 
Join Date: May 2022
Posts: 5
andrewjmdata is on a distinguished road
Default

Yes, it could be. Help in my organisation with SP isn't great
Reply With Quote
  #4  
Old 05-24-2022, 08:59 AM
andrewjmdata andrewjmdata is offline Excel sheet embedded into word - changes not reflected in word Windows 10 Excel sheet embedded into word - changes not reflected in word Office 2021
Novice
Excel sheet embedded into word - changes not reflected in word
 
Join Date: May 2022
Posts: 5
andrewjmdata is on a distinguished road
Default

Just saved both xls and doc on network folder and have same issue.

The word doc doesn't update when I close the xls, then reopen and then change a value in the xls.

Anyone have any other ideas?

Thanks

Andrew
Reply With Quote
  #5  
Old 05-24-2022, 09:02 AM
andrewjmdata andrewjmdata is offline Excel sheet embedded into word - changes not reflected in word Windows 10 Excel sheet embedded into word - changes not reflected in word Office 2021
Novice
Excel sheet embedded into word - changes not reflected in word
 
Join Date: May 2022
Posts: 5
andrewjmdata is on a distinguished road
Default

Just noticed that if I select the object in word there is an "update link" option. That seems to semi-fix the issue.

Still don't think this is as it should be though as when xls is first open and word doc initially and change a value, the word doc updates automatically.
Reply With Quote
  #6  
Old 05-24-2022, 10:09 AM
wiganken wiganken is offline Excel sheet embedded into word - changes not reflected in word Windows 11 Excel sheet embedded into word - changes not reflected in word Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Maybe it is a bug in Word 2021? Just guessing so not much help I know.

Is this a new problem that wasn't there before? If so then some update may have caused it and it will get fixed by another update soon. Is it possible to check for updates to Office 2021?
Reply With Quote
  #7  
Old 05-25-2022, 12:25 AM
andrewjmdata andrewjmdata is offline Excel sheet embedded into word - changes not reflected in word Windows 10 Excel sheet embedded into word - changes not reflected in word Office 2021
Novice
Excel sheet embedded into word - changes not reflected in word
 
Join Date: May 2022
Posts: 5
andrewjmdata is on a distinguished road
Default

Thanks for comment.

I have put it down to oddities of Microsoft.
There is a solution, though not very tidy, but I can live with that. 😘
Reply With Quote
  #8  
Old 05-25-2022, 04:39 PM
Guessed's Avatar
Guessed Guessed is offline Excel sheet embedded into word - changes not reflected in word Windows 10 Excel sheet embedded into word - changes not reflected in word Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,050
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

Does it make a difference if the Excel file is opened BEFORE the Word doc is opened?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
link, word365, xls

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open embedded excel sheet PDFs Peterino OneNote 0 02-08-2018 09:19 AM
Single embedded excel sheet for multiple graphs in PowerPoint GOCPT PowerPoint 1 07-26-2017 04:20 AM
Embedded Excel Forms in Word JamieGale Word 5 08-07-2014 12:15 AM
Using Embedded Links between Excel and Word Blaskowski Office 1 01-24-2014 04:37 PM
Excel sheet embedded into word - changes not reflected in word Link data from embedded excel sheet rwbarrett Word 1 05-27-2011 02:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:34 AM.


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