How to merge a 2nd or 3rd sheet from excel to word.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lauren Parsons - 28 Apr 2004 10:40 GMT

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

Reply to this Message

Peter Jamieson - 28 Apr 2004 22:36 GMT

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.

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Hi
> I have excel speadsheets set up with multiple pages in
[quoted text clipped - 10 lines]
> Many thanks
> Lauren Parsons

Reply to this Message

Sheryl - 29 Apr 2004 21:46 GMT

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
[quoted text clipped - 12 lines]
>Lauren Parsons
>.

Reply to this Message