[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Word 2007 - Linked object resize everytime they are updated

Posted on 2009-02-17
12
Medium Priority
?
2,376 Views
1 Endorsement
Last Modified: 2012-05-06
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
Comment
Question by:Brew_City
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 23

Expert Comment

by:redrumkev
ID: 23670218
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
 

Author Comment

by:Brew_City
ID: 23670477
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
 
LVL 23

Expert Comment

by:redrumkev
ID: 23670957
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Brew_City
ID: 23979358
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
 

Expert Comment

by:AdamColligan
ID: 24003353
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
 

Accepted Solution

by:
Brew_City earned 0 total points
ID: 24030347
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
 

Expert Comment

by:AdamColligan
ID: 24037217
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
 

Author Comment

by:Brew_City
ID: 24049244
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
 

Expert Comment

by:AdamColligan
ID: 24050183
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
 

Author Comment

by:Brew_City
ID: 24059567
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
 

Expert Comment

by:AdamColligan
ID: 24059803
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
 

Expert Comment

by:brandonpf
ID: 34966504
I'm experiencing this same issue  Does anyone know if Microsoft ever resolved this issue or developed a workaround?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question