Re: Creating a Word file using the data from an Exel Spreadsheet
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.
--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com
"Seemore" wrote in message
news:c7b09807-6ec7-47db-a0dd-3270d73243e8@34g2000hsf.googlegroups.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
> 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
date: Mon, 5 May 2008 23:32:48 -0400
author: Herb Tyson [MVP]
