Reply
 
Thread Tools Display Modes
  #1   Report Post  
Barb Reinhardt
 
Posts: n/a
Default Insert Excel Worksheets into Word Document

I have an Excel 2003 Workbook with 8 or 10 individual worksheets in it.
I'd like to put the information on the individual worksheets into a Word
2003 Document. I've tried

Insert - Object - Create from File

and I now have two specific questions:

1) The word document only accesses the first worksheet. How do I insert
the other worksheets in the file?
2) The worksheets are generally more than one page long. How do I insert
them so that they break the page in Word?

Around here, they all prefer Word for everything. I find Excel to be much
easier to use when editing tabular documents.

Thanks in advance,
Barb Reinhardt


  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

OK, I just tried copying and pasting the Excel info into Word and I got the
entire table. I would like to have the Word document automatically update
if the Excel Document is changed. Can this be done?

"Barb Reinhardt" wrote in message
...
I have an Excel 2003 Workbook with 8 or 10 individual worksheets in it.
I'd like to put the information on the individual worksheets into a Word
2003 Document. I've tried

Insert - Object - Create from File

and I now have two specific questions:

1) The word document only accesses the first worksheet. How do I insert
the other worksheets in the file?
2) The worksheets are generally more than one page long. How do I insert
them so that they break the page in Word?

Around here, they all prefer Word for everything. I find Excel to be

much
easier to use when editing tabular documents.

Thanks in advance,
Barb Reinhardt




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
How can I divide a page into three sections? Bonnie Microsoft Word Help 3 May 8th 23 02:47 AM
How do I insert and format part of a data field in a Word document Graham Blundell Microsoft Word Help 4 December 1st 04 02:51 PM
Insert more Word files into one document Kent Microsoft Word Help 1 November 24th 04 11:08 AM
How do I make a word document insert consequative dates on each p. Luvmysuv Microsoft Word Help 1 November 24th 04 12:30 AM
How do I convert a cd in word perfect to microsoft word greylady Microsoft Word Help 1 November 23rd 04 07:03 PM


All times are GMT +1. The time now is 04:56 AM.

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

About Us

"It's about Microsoft Word"