Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 52
Default Link to embedded spreadsheet

I need to embed two spreadsheets in a Word doc - one has detail rows, the
other has summary. They must be on different pages, with text between them.
How to link the summary to the detail, so that changes in detail rows are
automatically reflected in the summary? I know I can link to an external
spreadsheet, but want the doc to be self-contained within one file.

Thanks.
--
Ted
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 329
Default Link to embedded spreadsheet

Hi Ted,

Simple: Save your document, then open the embedded source workbook select
the source cells and copy them. Then, open the embedded target workbook,
select the destination cells and use Edit|Paste Special to paste the data as
a link in Excel format.

Cheers

--
macropod
[MVP - Microsoft Word]


"TedMi" wrote in message
...
I need to embed two spreadsheets in a Word doc - one has detail rows, the
other has summary. They must be on different pages, with text between

them.
How to link the summary to the detail, so that changes in detail rows are
automatically reflected in the summary? I know I can link to an external
spreadsheet, but want the doc to be self-contained within one file.

Thanks.
--
Ted



Reply
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
how do I edit an embedded spreadsheet? lldelk Excel Worksheet Functions 6 September 19th 06 11:14 PM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
How do I link password protected files to a master spreadsheet? Laurie M. Excel Worksheet Functions 1 July 17th 06 10:50 PM
how to link excel spreadsheets that are embedded in word realmike Excel Discussion (Misc queries) 5 November 17th 05 03:02 PM
Bogus link in spreadsheet Martin James Thornhill Excel Discussion (Misc queries) 3 March 12th 05 07:04 PM


All times are GMT +1. The time now is 10:40 PM.

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

About Us

"It's about Microsoft Excel"