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:
    266
    Likes Received:
    21
    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
    1. Advertisements

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.
Similar Threads
  1. Josephine Gooi

    Data link properties

    Josephine Gooi, Apr 23, 2012, in forum: Excel
    Replies:
    0
    Views:
    708
    Josephine Gooi
    Apr 23, 2012
  2. cabbagedude88
    Replies:
    0
    Views:
    661
    cabbagedude88
    Jun 1, 2012
  3. eeger toknow
    Replies:
    0
    Views:
    495
    eeger toknow
    Dec 3, 2012
  4. Kate
    Replies:
    0
    Views:
    478
  5. rx3210
    Replies:
    0
    Views:
    273
    rx3210
    Nov 10, 2014
  6. ChrisOK
    Replies:
    3
    Views:
    205
    ChrisOK
    Jan 3, 2017
  7. NathanielJS
    Replies:
    0
    Views:
    191
    NathanielJS
    May 5, 2017
  8. Ron Gui

    Excel opening from Email link

    Ron Gui, Jun 11, 2017, in forum: Excel
    Replies:
    0
    Views:
    88
    Ron Gui
    Jun 11, 2017
Loading...