MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 328|Reply: 2

How do I copy a Multi page excel table to word that automat

[Copy link]

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 2-12-2017 02:19:15 | All posts |Read mode
I need to paste an excel table into a word document that will automatically generate a header on each page.  This table is about 150 pages long on an 8.5 x 11 word page.  I also need it to link back to the excel file so when edited, the edits update in the word file.
When I try pasting it, it only pastes to one page.  So I need to 1) learn how to paste a file so that it carries over to multiple pages (instead of just one page) AND, get the header at the top of each page.












Reply

Props Report

0

Topics

615

Posts

1422

Integral

King

Rank: 6Rank: 6

Integral
1422
Post on 2-12-2017 02:28:37 | All posts



An Excel object pasted into Word cannot span a page break; you would have to use one of the other paste formats. However, Word's 'header row repeat' function does not apply to tables linked to Excel.
IMHO, trying to produce a 150-page table in Word is ridiculous; the impact of such a large table in a Word document, especially when linking is involved, will make molasses running down the face of a glacier seem fast by comparison.











Reply Support Opposition

Props Report

0

Topics

628

Posts

1450

Integral

King

Rank: 6Rank: 6

Integral
1450
Post on 2-12-2017 02:50:11 | All posts



That would explain why I can't get it to work.  Lol
So, how would I do this?  I need to publish a list from excel that will be turned into a PDF.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 11-20-2017 00:37 , Processed in 0.166267 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!