Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel linked objects not printing in color | Microsoft Word Help | |||
Linked Microsoft Excel Objects | Microsoft Word Help | |||
Error with Linked Word and Excel files. | Microsoft Word Help | |||
Linked excel table loses borders on update | Tables | |||
Excel worksheet in Word linked text boxes | Page Layout |