Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Workbook into Word 2003
If I go into Word, and choose Insert/Object/Create From File, Browse, and
find my existing Excel Workbook, only the first Worksheet is inserted into my Word document. If I go into Word, and choose Insert/File, and find my Excel Workbook, I get pages of garbage. Are both of these behaviours normal for Excel and Word 2003? Is there any way I can insert a Workbook (with multiple Worksheets) into a Word document as separate pages? I did end up selecting the area in each Excel Worksheet within the Workbook, holding down the SHFT key down and choosing Edit/Copy Picture and pasting into Word, but I'm curious to see if there's an easier way to get the entire workbook in a Word document in one fell swoop. Thanks. Brenda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Workbook into Word 2003
I just tried it out and got a multi-tab workbook to show up in Word 2003.
Here's what I did: 1) Insert--Object 2) Select "Create from File" tab 3) Navigate to the .xls document 4) Click OK. Is that what you're looking for? Dave -- Brevity is the soul of wit. "B. Levien" wrote: If I go into Word, and choose Insert/Object/Create From File, Browse, and find my existing Excel Workbook, only the first Worksheet is inserted into my Word document. If I go into Word, and choose Insert/File, and find my Excel Workbook, I get pages of garbage. Are both of these behaviours normal for Excel and Word 2003? Is there any way I can insert a Workbook (with multiple Worksheets) into a Word document as separate pages? I did end up selecting the area in each Excel Worksheet within the Workbook, holding down the SHFT key down and choosing Edit/Copy Picture and pasting into Word, but I'm curious to see if there's an easier way to get the entire workbook in a Word document in one fell swoop. Thanks. Brenda |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Workbook into Word 2003
Yes, that's what I mean, but if I do the same thing, I only get the first tab
.... I don't get any of the others. "Dave F" wrote: I just tried it out and got a multi-tab workbook to show up in Word 2003. Here's what I did: 1) Insert--Object 2) Select "Create from File" tab 3) Navigate to the .xls document 4) Click OK. Is that what you're looking for? Dave -- Brevity is the soul of wit. "B. Levien" wrote: If I go into Word, and choose Insert/Object/Create From File, Browse, and find my existing Excel Workbook, only the first Worksheet is inserted into my Word document. If I go into Word, and choose Insert/File, and find my Excel Workbook, I get pages of garbage. Are both of these behaviours normal for Excel and Word 2003? Is there any way I can insert a Workbook (with multiple Worksheets) into a Word document as separate pages? I did end up selecting the area in each Excel Worksheet within the Workbook, holding down the SHFT key down and choosing Edit/Copy Picture and pasting into Word, but I'm curious to see if there's an easier way to get the entire workbook in a Word document in one fell swoop. Thanks. Brenda |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Workbook into Word 2003
Double click on your embedded Excel object and then select the tab you want
to display. -- Kevin Backmann "B. Levien" wrote: Yes, that's what I mean, but if I do the same thing, I only get the first tab ... I don't get any of the others. "Dave F" wrote: I just tried it out and got a multi-tab workbook to show up in Word 2003. Here's what I did: 1) Insert--Object 2) Select "Create from File" tab 3) Navigate to the .xls document 4) Click OK. Is that what you're looking for? Dave -- Brevity is the soul of wit. "B. Levien" wrote: If I go into Word, and choose Insert/Object/Create From File, Browse, and find my existing Excel Workbook, only the first Worksheet is inserted into my Word document. If I go into Word, and choose Insert/File, and find my Excel Workbook, I get pages of garbage. Are both of these behaviours normal for Excel and Word 2003? Is there any way I can insert a Workbook (with multiple Worksheets) into a Word document as separate pages? I did end up selecting the area in each Excel Worksheet within the Workbook, holding down the SHFT key down and choosing Edit/Copy Picture and pasting into Word, but I'm curious to see if there's an easier way to get the entire workbook in a Word document in one fell swoop. Thanks. Brenda |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Workbook into Word 2003
Thank you very much! I was NOT aware that you could access the other sheets
(which will actually be quite helpful in future situations, unfortunately not in this one). What I was looking for was a way to import an entire workbook, but have each worksheet import onto a different page. I think the Edit/Copy picture will have to do for this instance. Thanks again for the very quick reply! Brenda "Kevin B" wrote: Double click on your embedded Excel object and then select the tab you want to display. -- Kevin Backmann "B. Levien" wrote: Yes, that's what I mean, but if I do the same thing, I only get the first tab ... I don't get any of the others. "Dave F" wrote: I just tried it out and got a multi-tab workbook to show up in Word 2003. Here's what I did: 1) Insert--Object 2) Select "Create from File" tab 3) Navigate to the .xls document 4) Click OK. Is that what you're looking for? Dave -- Brevity is the soul of wit. "B. Levien" wrote: If I go into Word, and choose Insert/Object/Create From File, Browse, and find my existing Excel Workbook, only the first Worksheet is inserted into my Word document. If I go into Word, and choose Insert/File, and find my Excel Workbook, I get pages of garbage. Are both of these behaviours normal for Excel and Word 2003? Is there any way I can insert a Workbook (with multiple Worksheets) into a Word document as separate pages? I did end up selecting the area in each Excel Worksheet within the Workbook, holding down the SHFT key down and choosing Edit/Copy Picture and pasting into Word, but I'm curious to see if there's an easier way to get the entire workbook in a Word document in one fell swoop. Thanks. Brenda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I just convert to Word 2003 and Excel 2003? | Excel Discussion (Misc queries) | |||
Saving a workbook in Excel 2003 | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Add a word document to an Excel workbook | Excel Discussion (Misc queries) |