Link to Excel cell within Word

J

Jane

Is it possible to create a Word document that can
reference a cell in an Excel spreadsheet and therefore
update automatically (perhaps on save) if the cell has
been modified?

For example if I were to have a budget set up in an excel
spreadsheet and then I wanted to write a document in
Word, could my 'total budget amount' cell be directly
linked to display in the document? and hence update
automatically in the document if i were to change the
budget amounts in the spreadsheet.
 
J

Jane

that's really cool

thanks cindy!
-----Original Message-----
Hi Jane,

Sure. Easiest way is to COPY the cell in Excel. In Word go
to Edit/Paste Special and choose "plain text" and activate
"Link".

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e- mail
:)

.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking data in MS Word into Excel 5
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Integrating information from Word to Excel (not mail merge) 1
Embed the same Excel multiple times 0
Excel - Wich Function should I use? 1
Link Excel to word 2
Need Help Creating a Word Template using Excel 1
External cell reference between two excel worksheets both in One Drive 0

Top