Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Mount Prospect, Illinois
    Posts
    142
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked Excel data - keep repeating headers? (Word and Excel 2010)

    I have some large spreadsheets that are still being updated, and will end up as appendices in a Word document.
    Since they are not final, Paste with Link seemed like an ideal way to include the data, except for one small detail: There does not appear to be any way to specify that the top row repeats on each page (e.g. Word's Table Layout > Repeat Header Rows) on the Excel data. This means that each time the data is updated (and I've set it not to auto-update), I need to fix the headers.

    I have tried setting the page layout "Rows to repeat at top" and the split windows -- neither setting in Excel makes a difference.

    Any suggestions?

  2. #2
    Star Lounger
    Join Date
    Dec 2009
    Location
    Lansing, MI
    Posts
    65
    Thanks
    1
    Thanked 2 Times in 2 Posts
    How about a kind of "dumb" work-around? What if you created a table in the header in Word to match the headings in Excel?

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Mount Prospect, Illinois
    Posts
    142
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hmm.. Do-able... I'd just need to start a new section for each such table so that the "real" header row on the Excel sheet uses a first-page header in Word, or else not paste/link the header row at all.

    Still, it's less than optimal: a change to the Excel sheet's structure means I still have to manually muck with headers. This is yet another place where Microsoft falls down on consistency between Office apps (top of the list includes how to put line breaks in a paragraph/cell/presentation outline item)

Posting Permissions

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