Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
KRK KRK is offline
external usenet poster
 
Posts: 9
Default insert excel spreadsheet

Hello

I have a Word document into which I want to insert an Excel spreadsheet. I
want to be able to update the spreadsheet and have the word document update
at the same time. I also want to be able to print the word document with the
excel data shown as a table.

I think this is possible, but I cannot find the route.

I have excel 2007 and word 2007

Thanks

KK

  #2   Report Post  
Posted to microsoft.public.word.newusers
Amish Amish is offline
external usenet poster
 
Posts: 35
Default insert excel spreadsheet

Copy your Excel data
Paste into Word using the Paste Special/Paste Link option

On Mar 22, 9:46*am, "KRK"
wrote:
Hello

I have a Word document into which I want to insert an Excel spreadsheet. I
want to be able to update the spreadsheet and have the word document update
at the same time. I also want to be able to print the word document with the
excel data shown as a table.

I think this is possible, but I cannot find the route.

I have excel 2007 and word 2007

Thanks

KK


  #3   Report Post  
Posted to microsoft.public.word.newusers
Brandon G[_2_] Brandon G[_2_] is offline
external usenet poster
 
Posts: 1
Default insert excel spreadsheet

Hi KRK,

This is possible so all you have to do is open both the excel and word
documents. Select the range of cells you want to show in the word document,
then copy the selected cells and then in the word document and place your
cursor where you want to put the data. In the menu bar select Edit- Paste
Special. After you do that a dialog box shows up and you just click the paste
button and select Excel worksheet object from the list, and then hit OK.

To update the spreadsheet and word document at the same time all you have to
do is copy and paste the data from excel to word. After you paste there
should be a paste options button in the lower right hand corner of your data,
click the down arrow and select Match Destination Table Style and Link to
Excel link and that's it.

Hope this Helps!

Brandon G.

"KRK" wrote:

Hello

I have a Word document into which I want to insert an Excel spreadsheet. I
want to be able to update the spreadsheet and have the word document update
at the same time. I also want to be able to print the word document with the
excel data shown as a table.

I think this is possible, but I cannot find the route.

I have excel 2007 and word 2007

Thanks

KK

.

  #4   Report Post  
Posted to microsoft.public.word.newusers
Terry Farrell Terry Farrell is offline
external usenet poster
 
Posts: 2,904
Default insert excel spreadsheet

And note that you MUST insert the link IN LINE or the link will not update.

--
Terry Farrell - MSWord MVP

"KRK" wrote in message
...
Hello

I have a Word document into which I want to insert an Excel spreadsheet. I
want to be able to update the spreadsheet and have the word document
update at the same time. I also want to be able to print the word document
with the excel data shown as a table.

I think this is possible, but I cannot find the route.

I have excel 2007 and word 2007

Thanks

KK


  #5   Report Post  
Posted to microsoft.public.word.newusers
KRK KRK is offline
external usenet poster
 
Posts: 9
Default insert excel spreadsheet _ Thanks all

Thanks for the help,

KK


"KRK" wrote in message
...
Hello

I have a Word document into which I want to insert an Excel spreadsheet. I
want to be able to update the spreadsheet and have the word document
update at the same time. I also want to be able to print the word document
with the excel data shown as a table.

I think this is possible, but I cannot find the route.

I have excel 2007 and word 2007

Thanks

KK


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert 'Landscape' Excel Spreadsheet into 'Portrait' Word Document Phil Page Layout 1 May 17th 09 12:30 PM
Excel spreadsheet in Word John King Microsoft Word Help 4 January 8th 08 02:04 PM
excel spreadsheet to word doc Leticia Microsoft Word Help 1 June 6th 06 06:00 PM
How do I insert an excel spreadsheet in Word? evh5150 Microsoft Word Help 1 January 17th 06 07:16 PM
embedded Excel spreadsheet rightsidekick Microsoft Word Help 3 September 4th 05 08:51 PM


All times are GMT +1. The time now is 11:43 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"