Update Excel objects (links) in word automatic

[anonymous]

My word document contains excel-docs (objects). When I open the word-doc word ask a queastion about automatic update the objects. I click Yes but no the changes in the excel docs är not updated.
My question is: How do I update the excel docs automatically?

 

[Shirley Zaknich]

My understanding of your problem is as follows: You copied somthing from Excel. You pasted it into Word. When you change the original in Excel, Word doesn't update

If this is the problem, Firstly, you copy from Excel. You PASTE SPECIAL (Edit Menu) into Word and select PASTE LINK, and select Formatted text

Make your changes in Excel - and Word should update. Good Luck

 

[anonymous]

Instead of using "objects" i tried your way "paste special" and still that wont correct my problem.

Correct me if i'm wrong but "paste special" and "object" is almost the same? Either way the excel-doc is linked in to the word-doc.

Bug?

 

[Guest]

Is there a way to make it stop asking every time you open
the document with the link if you want to update the link
and just to automatically make the update?

-----Original Message-----
My understanding of your problem is as follows: You

copied somthing from Excel. You pasted it into Word.
When you change the original in Excel, Word doesn't update.

If this is the problem, Firstly, you copy from Excel.

You PASTE SPECIAL (Edit Menu) into Word and select PASTE
LINK, and select Formatted text.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?YW5vbnltb3Vz?=,

Instead of using "objects" i tried your way "paste special" and still that wont correct my problem.

Correct me if i'm wrong but "paste special" and "object" is almost the same?

Either way the excel-doc is linked in to the word-doc.Depends on what format you use to "paste special". If you choose "object" you
should get the same thing as with Insert/Object, yes.

My word document contains excel-docs (objects). When I open the word-doc word

ask a queastion about automatic update the objects. I click Yes but no the changes
in the excel docs är not updated.Has any information in the Excel file been changed? If you're set up to get the
prompt, you'll get it even if there's nothing to be changed/updated. Word doesn't
know whether there is when it prompts, it's basically asking you if it should go
and check.

Which version of Office are you using?

Is the Excel object formatted in-line with the text, or does it have textwrap
formatting applied? If you use HTML from "paste special" (as a test) do you see
any different result after updating has occurred?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail

 

[anonymous]

Hi

Has any information in the Excel file been changed Yes

Which version of Office are you using

Office X

Is the Excel object formatted in-line with the text, or does it have textwrap
formatting applied?

Formatted in-line

If you use HTML from "paste special" (as a test) do you see
any different result after updating has occurred?

N

/Anonymou

----- Cindy M -WordMVP- skrev: ----

Hi =?Utf-8?B?YW5vbnltb3Vz?=,

Instead of using "objects" i tried your way "paste special" and still that wont correct my problem.

Either way the excel-doc is linked in to the word-doc

Depends on what format you use to "paste special". If you choose "object" you
should get the same thing as with Insert/Object, yes

My word document contains excel-docs (objects). When I open the word-doc word

ask a queastion about automatic update the objects. I click Yes but no the changes
in the excel docs är not updated

Has any information in the Excel file been changed? If you're set up to get the
prompt, you'll get it even if there's nothing to be changed/updated. Word doesn't
know whether there is when it prompts, it's basically asking you if it should go
and check

Which version of Office are you using

Is the Excel object formatted in-line with the text, or does it have textwrap
formatting applied? If you use HTML from "paste special" (as a test) do you see
any different result after updating has occurred

Cindy Meiste
INTER-Solutions, Switzerlan
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003
http://www.mvps.org/wor

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail :-

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?YW5vbnltb3Vz?=,

So, you've use Paste Special WITH LINK (just double-checking that!), both as an
object and in HTML format. You get the Excel table on the page. You go into Excel
and open the original file, change a cell value, SAVE it, go back into Word...

Click in the table (either format) and press F9. Does the data update?

(A thought occurs to me: what kinds of changes are not being reflected? You are
talking about cell content, and not, for example, additional rows or columns
you've added?)

Office XP

Formatted in-line

No

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail