+ Reply to Thread
Results 1 to 6 of 6

Excel object permanently distorts when expanded in word

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    27

    Excel object permanently distorts when expanded in word

    I am using Microsoft Office 2003.
    I have pasted an Excel object in a word document.
    It is a long list of dates for future appointments.
    The list contains about 800 rows each representing a day in the future over the next two years.
    The columns are filtered to display only the "(NonBlanks)" which is about 50 rows.
    When I want to add more information and use the filter to show "(All)" it expands to about 800 rows.
    After about 5 seconds of stability the width of the whole excel spreadsheet shrinks to about one inch wide on the screen and is unusable.
    I have tried adjusting it using the 'Format Object' window but nothing I do works.
    When I click back to word document after trying to repair it the Excel Object is so badly distorted and merged into itself that I have to close the word document without saving and reopen it.
    Any help would be much appreciated.

    I have attached the file. (See next post).
    (Using the 'Events' column filter (All) to expand will trigger the problem).

    Thank you.
    Last edited by DeanExcel; 03-24-2021 at 12:30 AM. Reason: To inform that I have uploaded the file.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,138

    Re: Excel object permanently distorts when expanded in word

    The paper clip icon does not work for attachments. To attach a file:

    1. Under the text box where you type your reply click the Go Advanced button.
    2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
    3. Click the Choose File button to select a file to attached.
    4. Click the Upload button to upload the file.
    5. Then click the Close This Window button. Your file is now attached to your post.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-21-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Excel object permanently distorts when expanded in word

    Many thanks for your help.
    I have attached the file as per your instructions.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-21-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Excel object permanently distorts when expanded in word

    Solution (Sort of)

    I always like to post a solution to my questions if I find one so that others may benefit.

    After many hours of mucking around I worked out that the worksheet must be fully expanded (filter set to show 'All' rows) when sizeing the object to neatly fit the whole page of MS Word.
    If I use filters to hide blank rows and thereby contract the sheet then the whole object reshapes to a shorter size taking up less space on the page it is embedded in.
    If I resize it again to fit the whole page where it is embedded then that's fine until I unhide the filtered rows which then causes the workbook to expand off the bottom of the page and then distort.
    However, if I leave it in it's 'self-adjusted' new shorter size I can use the filters and the longest it will stretch is no further than it's original size filling the whole page again.
    Downside is that I can't have it fill the whole page when filtered down. (More to the point I haven't found a way yet!)

    I hope this info helps anyone else with the same problem.
    Last edited by DeanExcel; 03-24-2021 at 10:04 AM. Reason: Tidy up text.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,628

    Re: Excel object permanently distorts when expanded in word

    @Jhon654

    Your pointless posts here are raising suspicion about your motives here. If you continue to make pointless posts, then I shall terminate your posting rights here.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  6. #6
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,579

    Re: Excel object permanently distorts when expanded in word

    Quote Originally Posted by DeanExcel View Post
    Downside is that I can't have it fill the whole page when filtered down. (More to the point I haven't found a way yet!)
    Embedded objects cannot span page boundaries.

    Personally, I'd be using a separate Excel workbook, in conjunction with which which I'd use either:
    a LINK field to display the filtered Excel data in any of the variety of link formats that Word supports (workbook, table, etc.); or
    a DATABASE field in Word to both filter and display the Excel data.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel chart embedded in powerpoint automatically resizes and distorts
    By BlueDaze in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-23-2021, 03:19 AM
  2. [SOLVED] Object doesn't support this property or method - word object
    By Yakov on Excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2017, 09:46 AM
  3. Copy Paste from Excel to Word distorts image
    By Amphibia07 in forum Excel General
    Replies: 7
    Last Post: 10-29-2009, 11:11 AM
  4. Cannot destroy Word Object in Excel
    By dai50 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2006, 07:11 AM
  5. Replies: 1
    Last Post: 09-25-2005, 11:05 PM
  6. [SOLVED] word object in excel
    By daron tan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2005, 06:05 AM
  7. Excel data not transfering to Word. Colums are expanded.
    By carolsue1313 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-24-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1