Excel -Word link

Hello

I have word files which are linked to Excel files, for example, showing monthly volume.  When I refresh for a new months volume the bars are updated in the word file, but I have a text box in the chart which shows the total which does not update.  In excel the total of the text box is updated but not in the word file.  Does this have to do linking vs embedding?

How do I get the text box of the word file to update, as well?

Thanks,
John
jverasqlAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joseph OLoughlinIT Support SpecialistCommented:
Attach a screen-shot, so we can see.
If the text box is simply a text box, it will have to be manually edited.
0
jverasqlAuthor Commented:
It is simply a text box. What could I use so it could automatically update?

The word file example attached shows that the total text boxes did not update for April.  The totals shown are only for Jan-Mar.  The total text boxes in the excel file have updated correctly, though.
0
Joseph OLoughlinIT Support SpecialistCommented:
Without programming, only through some property of the graph, i.e. add data labels
http://www.homeandlearn.co.uk/excel2007/excel2007s3p6.html
0
Eric FletcherCommented:
In your Excel sheet, set up a cell for the total you want to display. (You can use the TEXT function to ensure that it has whatever text you need with the value.) Copy the cell.

Then, in the Word document, create a text box and use Paste Special to choose one of the link options (F for Link and Keep Source Formatting, or L for Link and Merge Formatting). This will insert a LINK field code into the text box. Now select the text box and right click to choose Wrap Text > In Front of Text. You can then drag it over your linked chart to position it where you want it. (Use Format Shape to alter line, fill, etc.)

When your Excel data changes, the chart will update in Word as you experience it now. However, now the content within the Word text box will also be updated via the LINK field code.

A text box within your Excel chart doesn't get updated for the Excel-Word link, but the separate LINK will update. If you need the text box within the Excel chart, just position the one in Word to cover the non-updating one from Excel.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.