LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
Roy
 
Posts: n/a
Default how to link excel spreadsheets that are embedded in word

I have a simular issue. I have 2 worksheets embedded in Word. Both are
built using the Excel embed option from the Word toolbar. Theses Workbooks
do not exitst anyware else. I need to reference a cell from one in a formula
in the other.

"realmike" wrote:

Thx for the answer - I'm trying it out right now,

Mike


"Earl Kiosterud" wrote:

Mike,

If the sheets are in the same embedded workbook, it should be embedded in
the Word document only once. You can copy the embedded workbook, in Word,
(it doesn't matter which cells of which sheet you see -- it embeds the
entire workbook, not just a sheet), and Paste special - Excel object - Paste
link into another part of the Word document. YOu can only update the
original, but changes will be reflected in the linked one.
--
Earl Kiosterud
www.smokeylake.com

"realmike" wrote in message
...
is is possible to link spreadsheets that are embedded in word, without
creating a separte excel file and using the paste special, link commands?






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
want to link excel doc. to pdf. jtrushin Excel Discussion (Misc queries) 1 June 2nd 05 07:44 PM
Embedded Excel Spreadsheet in MS Word Corrupted Mary Excel Worksheet Functions 0 March 24th 05 05:29 PM
Networking excel spreadsheets error Leander Excel Discussion (Misc queries) 0 February 22nd 05 10:09 AM
most effective way to link ms word tables to excel Mark S Lloyd Excel Discussion (Misc queries) 0 November 26th 04 08:11 PM
Open a file in excel from a link in eplorer Dave Peterson Excel Discussion (Misc queries) 0 November 26th 04 01:25 AM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"