PC Review


Reply
Thread Tools Rate Thread

How can I embed one Excel worksheet at multiple points in a docume

 
 
Davcams
Guest
Posts: n/a
 
      14th Jan 2008
I use word for financial report writing. In doing so, I often use embedded
excel spreadsheets.
From time to time, I need to refer to the same spreadsheet at different
points within a document. During the writing process, several numbers may
change with market conditions, etc, and may affect the results in each table
that is embedded. At present, when a worksheet is embedded, it cannot be
copied/pasted, and have any updates carried through to each embedded
spreadsheet. Is it possible for a “master” excel file to be embedded, which
can be pasted several times afterwards, but each successive item that is
pasted, refers back to the “master” which can be updated?

I think not, but if not, MS should look into it.

 
Reply With Quote
 
 
 
 
tedmi
Guest
Posts: n/a
 
      14th Jan 2008
You can do this by pasting links to ranges in your embedded spreadsheet.
Here's how:
Right-click your embedded sheet and choose Worksheet Object, Open. This
opens the sheet not for in-place editing but in a new instance of Excel in a
separate window.
In the Excel Window, copy the desired range to the clipboard, switch to the
Word window and Paste Special, Worksheet Object, Paste Link, OK.
--
TedMi

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
I embed a word document in an Excel worksheet JeanneL Microsoft Excel Misc 1 8th Apr 2008 02:53 AM
How to embed the excel worksheet into my forms? zhangyl Microsoft VB .NET 4 10th Feb 2006 04:27 AM
How do I get excel to print an embedded multiple page word docume. =?Utf-8?B?UmFkIEJyb3du?= Microsoft Excel Worksheet Functions 0 11th Oct 2004 03:45 PM
How to let Embed Excel WorkSheet support Excel Addins? Robin Wei Microsoft Excel Discussion 1 18th Oct 2003 07:24 AM
How to let Embed Excel WorkSheet support Excel Addins? Robin Wei Microsoft Excel Programming 0 17th Oct 2003 04:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:08 PM.