Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert Excel Worksheet (2000)

    In Word 2000, I did Insert, Object and inserted an Excel worksheet (linked) into a Word doc. It came in cropped to about half of the sheet. I tried landscape orientation but that didn't help. I tried the same thing on other computers and on some computers the entire sheet comes in while on other computers it comes in cropped. Any ideas why and what to do about it?
    Thanks in advance, Karen

  2. #2
    BAM
    Guest

    Re: Insert Excel Worksheet (2000)

    Hi Karen,

    I have a few questions that may help narrow down the problem.

    Are you trying it on other computers using the same files? (document and workbook)

    Is it a single file giving you the difficulty or does a new file create the same problem?

    How many active columns x rows does the workbook are you inserting have?

    Is the difference between the PC's the View that you are using when inserted the workbook? (Normal vs. Print Layout)

    Can you resize the image once it's inserted in the document?
    ~~~~~~~~~~~~~~~
    Cheers! <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Excel Worksheet (2000)

    I was using the same Excel file but not the same Word document.
    I have since had this same problem with another workbook. I'll attach the file. The inserted object in Word only extends out to Wednesday 10/3.
    The worksheet had 21 rows and 12 columns. It easily fits in landscape orientation.
    The Word view is Print Layout exclusively.
    You can resize the image but you're just resizing the cropped version. The rest of the worksheet never shows up.
    Thanks again. Karen
    Attached Files Attached Files

  4. #4
    BAM
    Guest

    Re: Insert Excel Worksheet (2000)

    Hi Karen,

    You might need to attach an example of the document and a cropped workbook. The example you posted inserts fine.
    ~~~~~~~~~~~~~
    Cheers! <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  5. #5
    Star Lounger
    Join Date
    Sep 2001
    Location
    Northern Virginia
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Excel Worksheet (2000)

    I agree, this spreadsheet inserts fine. However, I have experienced the problem you initially described... Excel cropping for no explainable reason.

    My solution has been to reduce the font size and narrow the columns before highlighting the area you want to copy. Then I usually Paste Special|Picture into the Word document and resize the picture image to fit on the page (cannot link or paste as an object as I am copying pricing into a Word Proposal response and don't want to send the formula information with it).

    Good luck,
    gg

Posting Permissions

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