[barrie]

I have a Word 2007 template for a monthly report that includes a formatted
table. When I delete the data and try to copy and paste the updated rows and
columns from Excel 2007, it all wants to go into the top left cell. Of
course, I can copy over the data as a table but then I lose my formatting.
How should I be going about this?

[Doug Robbins - Word MVP]

If this is something that you do each month, it would be worthwhile linking
the content of each cell in the Word table to the corresponding cell in
Excel.

Then all you will need to do is select the table and press F9 to update the
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Barrie" wrote in message
news
I have a Word 2007 template for a monthly report that includes a formatted
table. When I delete the data and try to copy and paste the updated rows
and
columns from Excel 2007, it all wants to go into the top left cell. Of
course, I can copy over the data as a table but then I lose my formatting.
How should I be going about this?

[barrie]

I guess that is what I will have to do. I was hoping to avoid it. :-)

"Doug Robbins - Word MVP" wrote:

If this is something that you do each month, it would be worthwhile linking
the content of each cell in the Word table to the corresponding cell in
Excel.

Then all you will need to do is select the table and press F9 to update the
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Barrie" wrote in message
news
I have a Word 2007 template for a monthly report that includes a formatted
table. When I delete the data and try to copy and paste the updated rows
and
columns from Excel 2007, it all wants to go into the top left cell. Of
course, I can copy over the data as a table but then I lose my formatting.
How should I be going about this?

[Doug Robbins - Word MVP]

You only have to do it once.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Barrie" wrote in message
...
I guess that is what I will have to do. I was hoping to avoid it. :-)

"Doug Robbins - Word MVP" wrote:

If this is something that you do each month, it would be worthwhile
linking
the content of each cell in the Word table to the corresponding cell in
Excel.

Then all you will need to do is select the table and press F9 to update
the
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Barrie" wrote in message
news
I have a Word 2007 template for a monthly report that includes a
formatted
table. When I delete the data and try to copy and paste the updated
rows
and
columns from Excel 2007, it all wants to go into the top left cell.
Of
course, I can copy over the data as a table but then I lose my
formatting.
How should I be going about this?

[Graham Mayor]

The alternative is to format the Excel table as you have it in Word and link
the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Doug Robbins - Word MVP wrote:
You only have to do it once.


"Barrie" wrote in message
...
I guess that is what I will have to do. I was hoping to avoid it.
:-) "Doug Robbins - Word MVP" wrote:

If this is something that you do each month, it would be worthwhile
linking
the content of each cell in the Word table to the corresponding
cell in Excel.

Then all you will need to do is select the table and press F9 to
update the
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP

"Barrie" wrote in message
news I have a Word 2007 template for a monthly report that includes a
formatted
table. When I delete the data and try to copy and paste the
updated rows
and
columns from Excel 2007, it all wants to go into the top left
cell. Of
course, I can copy over the data as a table but then I lose my
formatting.
How should I be going about this?

[barrie]

Now you tell me! :-)

"Graham Mayor" wrote:

The alternative is to format the Excel table as you have it in Word and link
the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Doug Robbins - Word MVP wrote:
You only have to do it once.


"Barrie" wrote in message
...
I guess that is what I will have to do. I was hoping to avoid it.
:-) "Doug Robbins - Word MVP" wrote:

If this is something that you do each month, it would be worthwhile
linking
the content of each cell in the Word table to the corresponding
cell in Excel.

Then all you will need to do is select the table and press F9 to
update the
fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP

"Barrie" wrote in message
news I have a Word 2007 template for a monthly report that includes a
formatted
table. When I delete the data and try to copy and paste the
updated rows
and
columns from Excel 2007, it all wants to go into the top left
cell. Of
course, I can copy over the data as a table but then I lose my
formatting.
How should I be going about this?