Linked File Not Updating

[LadyDi]

I have a Word Document Linked to an Excel Spreadsheet. The link is set up to display the spreadsheet in the Word document and to update the link automatically when the document is opened. I recently added a line (which I merged and centered) to the spreadsheet and saved it. However, when I open the Word document, the new line is there, but all the text is shown in one small cell, not in several merged cells. I've tried everything I can think of, and can't get it to display correctly. Do you have any ideas as to why it won't display right or how to fix it?

 

[Trevor G]

Have you tried linking the spreadsheet into a blank word document to see if a fresh document works.

 

[LadyDi]

I tried linking the spreadsheet in a new document, but whenever I tried to update the link in the new document my formatting got all messed up. I tried pasting the link as a hyperlink, rich text, a Word Hyperlink, a picture, and an Excel Object and could not get any of them to work properly. The spreadsheet that I am linking is landscape and the document that I am pasting it into is mostly Portrait. When I first pasted the link, I selected and set the layout for the selected text to be landscape - which worked perfectly until I updated the link. Then the whole document went back to portait. When I pasted it as an Excel object or a picture, the context did not break across pages. When I pasted it as a hyperlink, Word hyperlink, or rich text, it spontaneously merged cells that are not merged in my spreadsheet after I updated the link. What am I doing wrong? I just want to show the spreadsheet as it is in a Word document.

 

[Brianwarnock]

When you linked did you select match destination formatting? your first post suggestes thst you did, try starting your linking over and select match source formatting.

brian

 

[Trevor G]

Perhaps reading this article may help you.

http://www.ion.icaew.com/itcounts/21055

 

[LadyDi]

Where do I find the checkbox to select to match destination formatting? The original document was created in Office 2003, and I cannot find that checkbox in Office 2007.

 

[Brianwarnock]

I don't have 2007 so do not know if it is different, but way back on 2002 , you decide on the way the linked data is formatted when you first paste the object into the word document, an icon appears alongside the data and by clicking on the arrow a menu opens allowing the choices to be made, that's why I said recreate the document from fresh.

Brian

 

[Trevor G]

In Word select the Office Button top left side of the screen then select Options at the bottom right, then select the Advanced on the left.

Look at the Cut Copy Paste and change the drop downs on the right to Match Destination Formatting.

 

[Trevor G]

Did this work for you?