Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Excel from Word
Hi!
I need to create an Excel file that would update from multiple Word documents. Ex. In Word, I have a table with a cell that has the person responsible for a project. If the person responsible changes, I'd like cell B2 in Excel to automatically update with the name change. Is this possible? I tried to copy, paste special, paste link, Microsoft Office Word Document Object to my Excel file but anytime I update the Word document, it gives me a message saying cannot start the source application for this object. Can anyone help? Is there a way to do this rather than changing all those Word documents to Excel files? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Excel from Word
There is a tiny trick to make this type of linkage much easier than normal.
Everyone knows how to link a cell in one workbook to another cell in a defferent workbook. We just want to do the same thing to a cell in a Word Table. We can cheat! Open both a Word doc and an Excel Workbook In the Word doc, instead of inserting a Table in the Word doc: Insert Object Microsoft Excel Worksheet If you double-click in a cell in the resulting object, you see the embedded worksheet. Enter data and copy the cell. If you click outside the object, it changes appearance. It looks just like any other Word table. Now go to the Work book, select a cell and: Edit PasteSpecial Paste Link Link updates work because we have really linked two worksheets (even though one of them is embedded) -- Gary''s Student - gsnu200722 "SueK" wrote: Hi! I need to create an Excel file that would update from multiple Word documents. Ex. In Word, I have a table with a cell that has the person responsible for a project. If the person responsible changes, I'd like cell B2 in Excel to automatically update with the name change. Is this possible? I tried to copy, paste special, paste link, Microsoft Office Word Document Object to my Excel file but anytime I update the Word document, it gives me a message saying cannot start the source application for this object. Can anyone help? Is there a way to do this rather than changing all those Word documents to Excel files? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Excel from Word
Gary''s wrote on Wed, 16 May 2007 09:45:00 -0700:
Gs We can cheat! Open both a Word doc and an Excel Workbook Gs In the Word doc, instead of inserting a Table in the Word doc: Insert Object Microsoft Excel Worksheet Gs If you double-click in a cell in the resulting object, you Gs see the embedded worksheet. Enter data and copy the cell. Gs If you click outside the object, it changes appearance. It Gs looks just like any other Word table. Gs Now go to the Work book, select a cell and: Edit PasteSpecial Paste Link Gs Link updates work because we have really linked two Gs worksheets (even though one of them is embedded) Gs -- Gs Gary''s Student - gsnu200722 Gs "SueK" wrote: I'm not the OP but that's neat! James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Excel from Word
Thanks James:
I usually work this thing backwards. The finance guys around here that do cost estimates always work in Excel, but they deliver their estimates in Word docs. They claim the linking thing saves them lots of time and trouble. -- Gary''s Student - gsnu200722 "James Silverton" wrote: Gary''s wrote on Wed, 16 May 2007 09:45:00 -0700: Gs We can cheat! Open both a Word doc and an Excel Workbook Gs In the Word doc, instead of inserting a Table in the Word doc: Insert Object Microsoft Excel Worksheet Gs If you double-click in a cell in the resulting object, you Gs see the embedded worksheet. Enter data and copy the cell. Gs If you click outside the object, it changes appearance. It Gs looks just like any other Word table. Gs Now go to the Work book, select a cell and: Edit PasteSpecial Paste Link Gs Link updates work because we have really linked two Gs worksheets (even though one of them is embedded) Gs -- Gs Gary''s Student - gsnu200722 Gs "SueK" wrote: I'm not the OP but that's neat! James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Excel from Word
Thank you! It works great!
"Gary''s Student" wrote: There is a tiny trick to make this type of linkage much easier than normal. Everyone knows how to link a cell in one workbook to another cell in a defferent workbook. We just want to do the same thing to a cell in a Word Table. We can cheat! Open both a Word doc and an Excel Workbook In the Word doc, instead of inserting a Table in the Word doc: Insert Object Microsoft Excel Worksheet If you double-click in a cell in the resulting object, you see the embedded worksheet. Enter data and copy the cell. If you click outside the object, it changes appearance. It looks just like any other Word table. Now go to the Work book, select a cell and: Edit PasteSpecial Paste Link Link updates work because we have really linked two worksheets (even though one of them is embedded) -- Gary''s Student - gsnu200722 "SueK" wrote: Hi! I need to create an Excel file that would update from multiple Word documents. Ex. In Word, I have a table with a cell that has the person responsible for a project. If the person responsible changes, I'd like cell B2 in Excel to automatically update with the name change. Is this possible? I tried to copy, paste special, paste link, Microsoft Office Word Document Object to my Excel file but anytime I update the Word document, it gives me a message saying cannot start the source application for this object. Can anyone help? Is there a way to do this rather than changing all those Word documents to Excel files? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Excel from Word
You are welcome
-- Gary''s Student - gsnu200722 "SueK" wrote: Thank you! It works great! "Gary''s Student" wrote: There is a tiny trick to make this type of linkage much easier than normal. Everyone knows how to link a cell in one workbook to another cell in a defferent workbook. We just want to do the same thing to a cell in a Word Table. We can cheat! Open both a Word doc and an Excel Workbook In the Word doc, instead of inserting a Table in the Word doc: Insert Object Microsoft Excel Worksheet If you double-click in a cell in the resulting object, you see the embedded worksheet. Enter data and copy the cell. If you click outside the object, it changes appearance. It looks just like any other Word table. Now go to the Work book, select a cell and: Edit PasteSpecial Paste Link Link updates work because we have really linked two worksheets (even though one of them is embedded) -- Gary''s Student - gsnu200722 "SueK" wrote: Hi! I need to create an Excel file that would update from multiple Word documents. Ex. In Word, I have a table with a cell that has the person responsible for a project. If the person responsible changes, I'd like cell B2 in Excel to automatically update with the name change. Is this possible? I tried to copy, paste special, paste link, Microsoft Office Word Document Object to my Excel file but anytime I update the Word document, it gives me a message saying cannot start the source application for this object. Can anyone help? Is there a way to do this rather than changing all those Word documents to Excel files? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Excel from Word
Gary -
I'm pulling info from excel into word. Do I have to have my excel file open to update my word file? "Gary''s Student" wrote: There is a tiny trick to make this type of linkage much easier than normal. Everyone knows how to link a cell in one workbook to another cell in a defferent workbook. We just want to do the same thing to a cell in a Word Table. We can cheat! Open both a Word doc and an Excel Workbook In the Word doc, instead of inserting a Table in the Word doc: Insert Object Microsoft Excel Worksheet If you double-click in a cell in the resulting object, you see the embedded worksheet. Enter data and copy the cell. If you click outside the object, it changes appearance. It looks just like any other Word table. Now go to the Work book, select a cell and: Edit PasteSpecial Paste Link Link updates work because we have really linked two worksheets (even though one of them is embedded) -- Gary''s Student - gsnu200722 "SueK" wrote: Hi! I need to create an Excel file that would update from multiple Word documents. Ex. In Word, I have a table with a cell that has the person responsible for a project. If the person responsible changes, I'd like cell B2 in Excel to automatically update with the name change. Is this possible? I tried to copy, paste special, paste link, Microsoft Office Word Document Object to my Excel file but anytime I update the Word document, it gives me a message saying cannot start the source application for this object. Can anyone help? Is there a way to do this rather than changing all those Word documents to Excel files? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I update link from excel to word? | Excel Worksheet Functions | |||
Update Excel links in Word | Excel Discussion (Misc queries) | |||
When linked objects update in Word,it keeps changing the spacing? | Excel Discussion (Misc queries) | |||
Update Excel table in Word automatically from data in Excel | Excel Discussion (Misc queries) | |||
Installed Word XP only, then applied Office SP3, then Excel - need 2 re-update? | Excel Discussion (Misc queries) |