If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to merge a 2nd or 3rd sheet from excel to word.
Hi
I have excel speadsheets set up with multiple pages in each file. I am havuing difficulty trying to merge from either a second or third sheet. Whenever I try I only get the data from sheet 1 in my merge. I am using Micrsoft Word 2000 and have tried naming the different sheets but the only option I ever get when I choose to open data source is 'entire speadsheet'. I'd be very grateful if you could shed somelight on this one. Many thanks Lauren Parsons |
#2
|
|||
|
|||
How to merge a 2nd or 3rd sheet from excel to word.
The default connection method (DDE) only sees the first sheet in the
spreadsheet, When you select the .xls file in the Open Data Source dialog box, check the "Choose method" box, then select "Excel via ODBC". In the subsequent dialog box, click the Options button and check all the boxes to ensure you can see all the worksheet names and range names (if any), and make sure the Excel file selected in the drop-down at the bottom of the dialog box is for the .xls you selected in the Open Data Source dialog. You will probably find that you need to use formatting switches in your Word Mergefield fields to display the dates and any currency amounts correctly. -- Peter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ "Lauren Parsons" wrote in message ... Hi I have excel speadsheets set up with multiple pages in each file. I am havuing difficulty trying to merge from either a second or third sheet. Whenever I try I only get the data from sheet 1 in my merge. I am using Micrsoft Word 2000 and have tried naming the different sheets but the only option I ever get when I choose to open data source is 'entire speadsheet'. I'd be very grateful if you could shed somelight on this one. Many thanks Lauren Parsons |
#3
|
|||
|
|||
How to merge a 2nd or 3rd sheet from excel to word.
Hello Lauren.
I was having the same problem so I experimented and hide the pages that I didnot want in the merge and wah lah, it worked. Give it a try and let me know if it works for you too. Sheryl -----Original Message----- Hi I have excel speadsheets set up with multiple pages in each file. I am havuing difficulty trying to merge from either a second or third sheet. Whenever I try I only get the data from sheet 1 in my merge. I am using Micrsoft Word 2000 and have tried naming the different sheets but the only option I ever get when I choose to open data source is 'entire speadsheet'. I'd be very grateful if you could shed somelight on this one. Many thanks Lauren Parsons . |
Thread Tools | |
Display Modes | |
|
|