Merging Excel into a Word Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BigBuck98 - 26 Mar 2004 15:39 GMT

I have an application in word and a database in excel. I want to merge the
database into my application. I have rows in Excel with 22 columns that I am
merging into word. It will merge the numbers in 21 of the columns but does
not merge the numbers in the 22nd column. This last column shows the total
of the other 21 cells in each row. Is there a reason that this last column
does not merge into my document?

Thanks,
Gordon

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 27 Mar 2004 00:31 GMT

Use Copy>Paste Special>Values to convert the formula in the last column to a
value and see if that solves the problem.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I have an application in word and a database in excel. I want to merge the
> database into my application. I have rows in Excel with 22 columns that I
[quoted text clipped - 7 lines]
> Thanks,
> Gordon

Reply to this Message

BigBuck98 - 28 Mar 2004 13:37 GMT

Thanks Doug for your reply, I found what my problem was. My spreadsheet
contained 22 columns, 11 columns pertained to one class of product that we
were selling and 10 columns pertained to another class of product, the 22nd
column was my total. I had these two classes separated with a column that
had a column width of 2.0. I had names in the 21 columns that had our
products and the Total column, but the column that separated the two
products was unnamed. When I merged the database to word the products in the
columns to the left of the unnamed column merged OK, but the columns to the
right moved everything down one when it merged to word, therefore there was
no place to put the total. After I gave the column that separated the two
products a name everything worked OK.

Gordon

> Use Copy>Paste Special>Values to convert the formula in the last column to a
> value and see if that solves the problem.
[quoted text clipped - 10 lines]
> > Thanks,
> > Gordon

Reply to this Message