Refference worksheet object mutipel times in word

Question

Hi!

I'm trying to reference a worksheet object that is already existing in my word document.

This is the existing object:

When I open the object i want to reference 2 other sheets with a payment plan and a overview of the total price:

I want it so when I update the prices in the overview, the 2 other sheets update as well. I have already put in the reference between the sheets, but I don't know how to display the other 2 sheets so they update when I change the prices in the overview.

I hope there is someone out there who can help me :))

Answer 1

Hi @August Bromann ,
How did you insert the Excel object into Word?
Did you use Insert- Object feature?
If yes, you should check the link to file option:

Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@Emi Zhang-MSFT Thank you for the help!

I've inserted it the way you reference, but how do I change what sheet it shows? I want to show 3 different sheets from the same excel file, 3 different places. So i guess i have to insert and link from file 3 times but then i don't know how to change what sheet it shows

Answer 3

@Emi Zhang-MSFT Is there any additional information you need?

Answer 4

@Emi Zhang-MSFT IT WORKS LIKE A DREAM! Thank you so much for the help. I do have a new problem :P I want it so my colleagues can download the two files and make an offer for the clients. But when they download the file, the directory of the excel file is changed and can't be opened in the word document. Is there a way that the directory updates automatically when the location of the files changes?

Hope you can help me out once again :P