Creating a Word file using the data from an Exel Spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seemore - 05 May 2008 15:53 GMT

I am creating a brochure in Word but I have an exel file with a number
of tabs and functions that spits those results into my actual exel
data tab. I would rather use Word to pull this data from Exel since
that data may change often. Is there a way to get my formula results
from Excel into Word? Hopefully I explained that properly.

Thanks,
Corey

Reply to this Message

Herb Tyson [MVP] - 06 May 2008 04:32 GMT

I'm assuming you want to be able to have updated Excel results appear in
Word when the formula kicks out a new number. The easiest way usually is to
copy from Excel, then paste a link into Word. The manifestation in Word will
look like a table or a table cell. When you double-click it in Word, it will
open in Excel. Copy the cell(s) to the clipboard in Excel (select and press
Ctrl+C), then, in Word, choose Edit - Paste Special - Microsoft Office Excel
Worksheet Object - Paste Link - OK.

Another way is to use Insert - Object - Create from File, and tick Link to
File. In my experience, with the latter method, it's hard to control exactly
what displays in Word.

Signature

Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com

>I am creating a brochure in Word but I have an exel file with a number
> of tabs and functions that spits those results into my actual exel
[quoted text clipped - 4 lines]
> Thanks,
> Corey

Reply to this Message

Rate this thread: