Word 2007 - Linked object resize everytime they are updated
In Word 2007 when ever I have a Linked Object updated it resizes. Basically I have tables I created in Excel 2007 and I will create a link to them in a Word doc. When I open the Word Doc it will update all of my links (which I want it to do), but it will randomly resize them larger or smaller. If I Right Click > Format Object > Size Tab > check Lock Aspect Ratio it still resizes. My only other thought is an option under Links called "preserve formatting after update" but its always unchecked and grayed out.
Has anyone seen this before or does anyone have any resolutions?
Has anyone seen this before or does anyone have any resolutions?
ASKER
Thanks for the redrumkev but, this doesn't seem to be working for me.
I'll let the size of the linked table and cut it > insert a 1 row table and paste the linked table inside it. Then when ever I update the link it will resize. The end users that have this issue are creating large 100+ page publication that I don't think this work around would have really been feasible for them.
Is there a for to turn of this auto resizing? I can insert two linked tables (both linked to the same source) and one will resize larger and one will resize smaller. So it doesn't seem to have anything to do with the source of the link.
I'll let the size of the linked table and cut it > insert a 1 row table and paste the linked table inside it. Then when ever I update the link it will resize. The end users that have this issue are creating large 100+ page publication that I don't think this work around would have really been feasible for them.
Is there a for to turn of this auto resizing? I can insert two linked tables (both linked to the same source) and one will resize larger and one will resize smaller. So it doesn't seem to have anything to do with the source of the link.
Brew City,
Ok - I see what you are saying.
How about this:
http://www.eggheadcafe.com/software/aspnet/31264649/excel-worksheet-object-re.aspx
Which perhaps you need to change the entire way that you are linking the object... as explained above.
The 2007 insert linked object ways are listed here:
http://office.microsoft.com/en-us/word/HA101208101033.aspx?pid=CH100996521033
Kevin
Ok - I see what you are saying.
How about this:
http://www.eggheadcafe.com/software/aspnet/31264649/excel-worksheet-object-re.aspx
Which perhaps you need to change the entire way that you are linking the object... as explained above.
The 2007 insert linked object ways are listed here:
http://office.microsoft.com/en-us/word/HA101208101033.aspx?pid=CH100996521033
Kevin
ASKER
If anyone is interested in this case, I actually have a case open with Microsoft, which is calling it a bug and hasn't given me an ETA for resolution. Also we discovered a work-around of saving the the word file as a .doc. Then the linked table doesn't resize after updating it. The excel file can stay saved in the 2007 format. I hope this helps anyone with the same issue and I'll post a resolution if I get one from Microsoft.
I'm having this exact same problem, and it's killing me; unfortunately, though, the two workarounds don't seem to be doing the trick.
Saving as a .doc, link updates still expand the table, although not as drastically as they do in the .docx file.
Nesting the linked table in a 1-cell Word table does contain the width of the columns when the links update. Unfortunatley, it then strips out all of the colour and border formatting, which wasn't getting ruined before!
I've be very interested to know what Microsoft can come up with on this, if it is indeed a bug.
Saving as a .doc, link updates still expand the table, although not as drastically as they do in the .docx file.
Nesting the linked table in a 1-cell Word table does contain the width of the columns when the links update. Unfortunatley, it then strips out all of the colour and border formatting, which wasn't getting ruined before!
I've be very interested to know what Microsoft can come up with on this, if it is indeed a bug.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm afraid the saving as xls didn't seem to do anything for me: the links resized the chart object in a way that was slightly different to bus just as crazy as the Excel 2007 links. One thing I am noticing is that in the Table Options menu, if I have the auto resize to fit contents box unticked, after the links update it is ticked. Unticking it at that point sometimes brings back the formatting that I had set, but not consistently...
ASKER
AdamColligan:
We noticed they same thing while troubleshooting and we actually thought it was a work around for a while, until we started getting inconsistent results. I talked with my End-User thats been having this issue and I guess there was a little more to the work around.
"The Word-Excel link resizing and character corruption problem was only corrected when we did the all of these:
1. Save files as Office 2003
2. Use Calibri font
3. Use standard size font (e.g., 11 point, no half-sizes).
4. Have no range names in Excel.
Not doing any one of the four has resulted in problems. Our current solution has been working for about a month now."
We were using Arial Font as an office and have had to abandon it for multiple reasons with Office 2007 and Acrobat Pro 9. I hope maybe this helps.
We noticed they same thing while troubleshooting and we actually thought it was a work around for a while, until we started getting inconsistent results. I talked with my End-User thats been having this issue and I guess there was a little more to the work around.
"The Word-Excel link resizing and character corruption problem was only corrected when we did the all of these:
1. Save files as Office 2003
2. Use Calibri font
3. Use standard size font (e.g., 11 point, no half-sizes).
4. Have no range names in Excel.
Not doing any one of the four has resulted in problems. Our current solution has been working for about a month now."
We were using Arial Font as an office and have had to abandon it for multiple reasons with Office 2007 and Acrobat Pro 9. I hope maybe this helps.
I've given this a shot, but I haven't noticed a difference (screenshots attached as pdf). I'm thinking I might just be out of luck on this one.
xls-screenshots.pdf
xls-screenshots.pdf
ASKER
How are you creating the link? We do ours by copying the table in Excel and using Paste Special > Paste Link > Microsoft Office Excel Worksheet Object in Word.
I'm pasting it as HTML - I need to be able to change the formatting (column width, font sizes) from the xls sheet to the Word document; in particular, I need the column sizes to be different in different rows.
I'm experiencing this same issue Does anyone know if Microsoft ever resolved this issue or developed a workaround?
How are you doing?
This should help you out (says it is for a Mac, Word for Mac 2008, but the coding is the same as Office 2007):
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.mac.office.word&tid=f250296c-2daf-4c13-98dd-bce2b7b75553&cat=en_US_3cf8ecf1-ca81-4391-b07d-8933029ee8a9&lang=en&cr=US&sloc=&p=1
Kevin