Link Excel to word

Discussion in 'Excel' started by BoBo, Jun 28, 2017.

  1. BoBo

    BoBo

    Joined:
    Jun 28, 2017
    Messages:
    1
    Likes Received:
    0
    I have done calculation on an excel spreadsheet, pasted on a WORD document, formatted it the report and linked the two documents. When I changed the excel calculation on excel, the formatting on the WORD document are gone. Is there a way to update the WORD document without disturbing the formatting.

    Any help is appreciated.
     
    BoBo, Jun 28, 2017
    #1
    1. Advertisements

  2. BoBo

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    296
    Likes Received:
    24
    You can't apply formatting to part of a Word field's display; any time you update the field, your formatting will be lost. You may get better results using a different paste format, or by changing the formatting in Excel.
     
    macropod, Aug 11, 2017
    #2
    jessicawhite999 likes this.
    1. Advertisements

  3. BoBo

    jessicawhite999

    Joined:
    Nov 14, 2017
    Messages:
    2
    Likes Received:
    0
    Your answer fully provide information for my trouble with excel but other thing. thanks much
     
    jessicawhite999, Nov 14, 2017
    #3
    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.