Excel spreadsheet rows not showing in Word

Discussion in 'Apple' started by Markus, Nov 2, 2005.

  1. Markus

    Markus Guest

    Hi all,

    I have embedded Excel spreadsheets in a word document. When I change
    something or delete a row the changes show up in Word - however when I
    insert rows then the last rows are not shown (e.g. I insert 2 rows then the
    last two are not shown).

    On Windows one can increase the size of the inserted object until all rows
    show - but I can't find a way to do this on the Mac.

    What am I missing?


    Markus, Nov 2, 2005
    1. Advertisements

  2. Rats. I thought this would be easy, but Office X does things worse
    than Office2k or 98 so far as this goes. I couldn't find anything in
    the help file either.
    My only suggestion is to edit the Excel spreadsheet in Excel (NOT by
    opening up the copy in word) , then copy the region you want and
    PasteSpecial AsExcelWorksheet.
    I didn't play around with a pasted link. That might help (although the
    spreadsheet is not part of the Word doc in that case.)

    OTOH, I think this is a good thing, not bad. I've seen people naively
    paste a few cells into a document, not realizing that the entire
    workbook is now in the doc. They then send someone else the word doc
    with all sorts of info inside the spreadsheet they didn't want others to
    see. Better that you never embed a document in the first place.
    Carl Witthoft, Nov 3, 2005
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.