Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fields from Excel
I have used the insert field document to insert text from a different word
document. I wanted to know whether this was possible with word and excel. If i enter a value in word, i would like it to appear on an excel spreadsheet either automatically (which would be great) or by pressing F9 after clicking on the cell. Is this possible? |
#2
|
|||
|
|||
Yes it is possible. The quick and dirty way is simply to select and copy the
text/cell in one application, switch to the other and Paste Special Paste as link. Or insert a hyperlink using the Bookmark switch. For Word, you need to bookmark the piece of text you want to refer to in Excel; going the other way, the cell reference or any defined name can be used as the bookmark. "Rahul" wrote in message ... I have used the insert field document to insert text from a different word document. I wanted to know whether this was possible with word and excel. If i enter a value in word, i would like it to appear on an excel spreadsheet either automatically (which would be great) or by pressing F9 after clicking on the cell. Is this possible? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting links from excel into word (extra line feeds) | Microsoft Word Help | |||
How to update 2003 Word Doc for 2004 with Excel list | Microsoft Word Help | |||
I can't open the embedded excel sheet in one of my word document . | Microsoft Word Help | |||
refreshing / updating fields | Microsoft Word Help | |||
posting data from text input fields to fields later in document | Microsoft Word Help |