View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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