• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2566
  • Last Modified:

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?
1
Brew_City
Asked:
Brew_City
  • 5
  • 4
  • 2
  • +1
1 Solution
 
redrumkevCommented:
Brew City,

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
0
 
Brew_CityAuthor Commented:
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.
0
 
redrumkevCommented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Brew_CityAuthor Commented:
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.
0
 
AdamColliganCommented:
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.
0
 
Brew_CityAuthor Commented:
Please be aware this Microsoft service ticket originally was placed with the Word team who ultimately deemed it an Excel issue.  The Excel team did acknowledged the issue and provided the workaround of saving your excel workbook as an .xls.  We have had success with this work around and it doesn't cause us much pain.  I incorrectly mentioned the work around as saving the Word file as a .doc before.

Here is the final response from Microsoft's Excel Team:

"I spoke with my escalation team today and they confirmed that we have not seen this behavior before, and that it is currently not a known bug. From my discussions I do know that there will be several fixes around linking objects in 2007 applications that will be corrected in SP2 for Office 2007, but we will go ahead and submit this to our Developers.

I do want to set your expectations that once we submit this to our developpers, they will review the submitted bug, make their considerations, and set priorities based on other submissions. We will be sure to include your business impact for added weight to this submission, but I do not expect to hear or have any immediate response from our Developers. In fact, many of these bug submissions do not become available, until the next Service Pack release, and SP2 is already closed down for any additional fixes/additions."

If anyone else is having this issue please open a ticket with Microsoft, so hopefully it will put more pressure on them to provide a fix.
0
 
AdamColliganCommented:
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...
0
 
Brew_CityAuthor Commented:
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.
0
 
AdamColliganCommented:
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
0
 
Brew_CityAuthor Commented:
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.
0
 
AdamColliganCommented:
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.
0
 
brandonpfCommented:
I'm experiencing this same issue  Does anyone know if Microsoft ever resolved this issue or developed a workaround?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 5
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now