Random Data Missing from Excel Data Source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amy - 13 Dec 2007 20:33 GMT

I have a mail merge document in Word 2003 connecting to a spreadsheet in
Excel 2003. As I merge the data into the document, information from one or
more columns "disappears", or shows up as zeros. The columns are all
formatted as "General", and contain a variety of text and numbers. The thing
is, data that was there yesterday may not show up today, and vice versa. I
inserted another column next to one of the ones I'm having trouble with, and
test data showed up, but copying and pasting all of the values from the
original column made it disappear again. Any suggestions?

Reply to this Message

Peter Jamieson - 13 Dec 2007 22:31 GMT

There's an explanation at http://tips.pjmsn.me.uk/t0003.htm

The DDE workaround mentioned there may be enough.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I have a mail merge document in Word 2003 connecting to a spreadsheet in
> Excel 2003. As I merge the data into the document, information from one
[quoted text clipped - 8 lines]
> test data showed up, but copying and pasting all of the values from the
> original column made it disappear again. Any suggestions?

Reply to this Message