Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
pixiecat
 
Posts: n/a
Default Linked excel objects do not update properly

I have several objects pasted in a word doc as linked excel objects. If I
don't format them for layout, they update just fine. If I have to format
them for layout, they don't update anymore. The link still exists, but any
changes to the excel file do not flow through to the word doc. Any ideas?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
John McGhie [MVP - Word and Word Macintosh]
 
Posts: n/a
Default Linked excel objects do not update properly

This comes under the heading of "That's the way it is..."

When you alter the formatting of an embedded object, you are effectively
creating a new local instance of the object that will not update.

Perform your formatting in the original application and the formatting
changes should flow through to your Word document with the update.

Cheers


On 10/2/06 10:31 AM, in article
, "pixiecat"
wrote:

I have several objects pasted in a word doc as linked excel objects. If I
don't format them for layout, they update just fine. If I have to format
them for layout, they don't update anymore. The link still exists, but any
changes to the excel file do not flow through to the word doc. Any ideas?


--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
pixiecat
 
Posts: n/a
Default Linked excel objects do not update properly

The changes that I'm making all have to do with layout, so that the linked
table is no longer in line with the text. If I set it for square, tight,
etc., it no longer updates. It seems odd to me that if the parts of the
office suite are designed to work together, you should be able to set linked
tables to the most appropriate alignment for the report and still have them
update, especially if the link is still intact, which it is.

If anyone can come up with a workaround, I'd really appreciate it. I'm
fresh out of ideas.

Thanks in advance.

"pixiecat" wrote:

I have several objects pasted in a word doc as linked excel objects. If I
don't format them for layout, they update just fine. If I have to format
them for layout, they don't update anymore. The link still exists, but any
changes to the excel file do not flow through to the word doc. Any ideas?

  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
 
Posts: n/a
Default Linked excel objects do not update properly

When you apply wrapping other than In Line With Text, you are sending the
object into the drawing layer, where Word doesn't "see" it. You may be able
to accomplish what you need by placing the object in a frame instead. You
can still wrap text around it, but the frame content is still in the text
layer.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"pixiecat" wrote in message
...
The changes that I'm making all have to do with layout, so that the linked
table is no longer in line with the text. If I set it for square, tight,
etc., it no longer updates. It seems odd to me that if the parts of the
office suite are designed to work together, you should be able to set

linked
tables to the most appropriate alignment for the report and still have

them
update, especially if the link is still intact, which it is.

If anyone can come up with a workaround, I'd really appreciate it. I'm
fresh out of ideas.

Thanks in advance.

"pixiecat" wrote:

I have several objects pasted in a word doc as linked excel objects. If

I
don't format them for layout, they update just fine. If I have to

format
them for layout, they don't update anymore. The link still exists, but

any
changes to the excel file do not flow through to the word doc. Any

ideas?

  #5   Report Post  
Posted to microsoft.public.word.docmanagement
pixiecat
 
Posts: n/a
Default Linked excel objects do not update properly

I tried to do that, but I can't figure it out. I'm using Word 2003, and it
doesn't handle frames the same way older versions do. Nothing I read in Help
actually helped. Can someone who knows how to handle frames in Word 2003
explain the process, step-by-step?

Again, thanks to all who have replied.

"Suzanne S. Barnhill" wrote:

When you apply wrapping other than In Line With Text, you are sending the
object into the drawing layer, where Word doesn't "see" it. You may be able
to accomplish what you need by placing the object in a frame instead. You
can still wrap text around it, but the frame content is still in the text
layer.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"pixiecat" wrote in message
...
The changes that I'm making all have to do with layout, so that the linked
table is no longer in line with the text. If I set it for square, tight,
etc., it no longer updates. It seems odd to me that if the parts of the
office suite are designed to work together, you should be able to set

linked
tables to the most appropriate alignment for the report and still have

them
update, especially if the link is still intact, which it is.

If anyone can come up with a workaround, I'd really appreciate it. I'm
fresh out of ideas.

Thanks in advance.

"pixiecat" wrote:

I have several objects pasted in a word doc as linked excel objects. If

I
don't format them for layout, they update just fine. If I have to

format
them for layout, they don't update anymore. The link still exists, but

any
changes to the excel file do not flow through to the word doc. Any

ideas?




  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
 
Posts: n/a
Default Linked excel objects do not update properly

Frames still work the same way; you just have to find the same kind of
frame! Frame was removed from the Insert menu in Word 97 and made difficult
to find. You can use Customize to put it back, or you can use the Insert
Frame button on the Forms toolbar.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"pixiecat" wrote in message
...
I tried to do that, but I can't figure it out. I'm using Word 2003, and

it
doesn't handle frames the same way older versions do. Nothing I read in

Help
actually helped. Can someone who knows how to handle frames in Word 2003
explain the process, step-by-step?

Again, thanks to all who have replied.

"Suzanne S. Barnhill" wrote:

When you apply wrapping other than In Line With Text, you are sending

the
object into the drawing layer, where Word doesn't "see" it. You may be

able
to accomplish what you need by placing the object in a frame instead.

You
can still wrap text around it, but the frame content is still in the

text
layer.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"pixiecat" wrote in message
...
The changes that I'm making all have to do with layout, so that the

linked
table is no longer in line with the text. If I set it for square,

tight,
etc., it no longer updates. It seems odd to me that if the parts of

the
office suite are designed to work together, you should be able to set

linked
tables to the most appropriate alignment for the report and still have

them
update, especially if the link is still intact, which it is.

If anyone can come up with a workaround, I'd really appreciate it.

I'm
fresh out of ideas.

Thanks in advance.

"pixiecat" wrote:

I have several objects pasted in a word doc as linked excel objects.

If
I
don't format them for layout, they update just fine. If I have to

format
them for layout, they don't update anymore. The link still exists,

but
any
changes to the excel file do not flow through to the word doc. Any

ideas?



  #7   Report Post  
Posted to microsoft.public.word.docmanagement
pixiecat
 
Posts: n/a
Default Linked excel objects do not update properly

Thank you, thank you, thank you. That worked.

"Suzanne S. Barnhill" wrote:

Frames still work the same way; you just have to find the same kind of
frame! Frame was removed from the Insert menu in Word 97 and made difficult
to find. You can use Customize to put it back, or you can use the Insert
Frame button on the Forms toolbar.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"pixiecat" wrote in message
...
I tried to do that, but I can't figure it out. I'm using Word 2003, and

it
doesn't handle frames the same way older versions do. Nothing I read in

Help
actually helped. Can someone who knows how to handle frames in Word 2003
explain the process, step-by-step?

Again, thanks to all who have replied.

"Suzanne S. Barnhill" wrote:

When you apply wrapping other than In Line With Text, you are sending

the
object into the drawing layer, where Word doesn't "see" it. You may be

able
to accomplish what you need by placing the object in a frame instead.

You
can still wrap text around it, but the frame content is still in the

text
layer.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"pixiecat" wrote in message
...
The changes that I'm making all have to do with layout, so that the

linked
table is no longer in line with the text. If I set it for square,

tight,
etc., it no longer updates. It seems odd to me that if the parts of

the
office suite are designed to work together, you should be able to set
linked
tables to the most appropriate alignment for the report and still have
them
update, especially if the link is still intact, which it is.

If anyone can come up with a workaround, I'd really appreciate it.

I'm
fresh out of ideas.

Thanks in advance.

"pixiecat" wrote:

I have several objects pasted in a word doc as linked excel objects.

If
I
don't format them for layout, they update just fine. If I have to
format
them for layout, they don't update anymore. The link still exists,

but
any
changes to the excel file do not flow through to the word doc. Any
ideas?




  #8   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
 
Posts: n/a
Default Linked excel objects do not update properly

Glad I could help.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"pixiecat" wrote in message
...
Thank you, thank you, thank you. That worked.

"Suzanne S. Barnhill" wrote:

Frames still work the same way; you just have to find the same kind of
frame! Frame was removed from the Insert menu in Word 97 and made

difficult
to find. You can use Customize to put it back, or you can use the Insert
Frame button on the Forms toolbar.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"pixiecat" wrote in message
...
I tried to do that, but I can't figure it out. I'm using Word 2003,

and
it
doesn't handle frames the same way older versions do. Nothing I read

in
Help
actually helped. Can someone who knows how to handle frames in Word

2003
explain the process, step-by-step?

Again, thanks to all who have replied.

"Suzanne S. Barnhill" wrote:

When you apply wrapping other than In Line With Text, you are

sending
the
object into the drawing layer, where Word doesn't "see" it. You may

be
able
to accomplish what you need by placing the object in a frame

instead.
You
can still wrap text around it, but the frame content is still in the

text
layer.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"pixiecat" wrote in message
...
The changes that I'm making all have to do with layout, so that

the
linked
table is no longer in line with the text. If I set it for square,

tight,
etc., it no longer updates. It seems odd to me that if the parts

of
the
office suite are designed to work together, you should be able to

set
linked
tables to the most appropriate alignment for the report and still

have
them
update, especially if the link is still intact, which it is.

If anyone can come up with a workaround, I'd really appreciate it.

I'm
fresh out of ideas.

Thanks in advance.

"pixiecat" wrote:

I have several objects pasted in a word doc as linked excel

objects.
If
I
don't format them for layout, they update just fine. If I have

to
format
them for layout, they don't update anymore. The link still

exists,
but
any
changes to the excel file do not flow through to the word doc.

Any
ideas?





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel linked objects not printing in color Jess Microsoft Word Help 1 October 31st 05 08:13 PM
Linked Microsoft Excel Objects lc Microsoft Word Help 1 September 9th 05 03:07 PM
Error with Linked Word and Excel files. dgundrum Microsoft Word Help 0 August 2nd 05 05:19 PM
Linked excel table loses borders on update Gary McGill Tables 2 March 27th 05 10:27 AM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM


All times are GMT +1. The time now is 05:31 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"