Embedding spreadsheet into Word

  • Thread starter Thread starter Humphrey
  • Start date Start date
H

Humphrey

I would like to embed a spreadsheet into Word and have it refresh its links
when the document is opened. Is this possible?

Can I display mutiple tabs of the same embedded spreadsheet, or am i
restricted to only the single tab?

I trust this is a Word issue.

H
 
Hi Humphrey,

For the range you want to display on a single Word page, copy the source range from Excel, then use Edit|Paste Special, choose the
'paste link' option and the Excel workbook format. Note that Excel objects cannot span more than a single page in Word, so you may
need to use this method multiple times to get all that you need. Likewise, you can't display multiple Excel tabs in a single linked
object. From the Edit|Paste Special dialogue, you'll see a number of other formats, some of which allow the pasted range to span
more than one page in Word, but are less faithful in reproducing the Excel formatting.
 
Back
Top