moving formula cells

[Paul Bean]

I would like to be able to insert or delete rows in a table where the right-most column has formulas that involve row locations. When I do this now, I have to go back and individually correct the row position in each cell. Is there a way to have the cells update automatically to their new position? I was able to do this years ago with Lotus Ami Pro, but I have never been able to get Word to do it.

 

[Suzanne S. Barnhill]

If you embed an Excel sheet, you can get Excel functionality to do this.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

I would like to be able to insert or delete rows in a table where the

right-most column has formulas that involve row locations. When I do this
now, I have to go back and individually correct the row position in each
cell. Is there a way to have the cells update automatically to their new
position? I was able to do this years ago with Lotus Ami Pro, but I have
never been able to get Word to do it.

 

[Doug Robbins - Word MVP]

Hi Paul,

There is no way to do it with a Word table. You can however do it if you
insert and Excel spreadsheet into the document and use that instead of the
Word table. Other than when you are actually entering information into the
spreadsheet, it can appear the same as a Word table.

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 would like to be able to insert or delete rows in a table where the

right-most column has formulas that involve row locations. When I do this
now, I have to go back and individually correct the row position in each
cell. Is there a way to have the cells update automatically to their new
position? I was able to do this years ago with Lotus Ami Pro, but I have
never been able to get Word to do it.

 

[Paul Bean]

Thanks Doug and Suzanne,

I will try the embedded Excel method. Doug, I apologize if I somehow posted in error. I got here through the Microsoft site and still don't quite understand how this might have been forwarded directly to you. Anyhow, thank you for your help.

Paul

 

[Doug Robbins - Word MVP]

Hi Paul,

Your message was not forwarded directly to me and you have done the right
thing by responding to the newsgroup.

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

Thanks Doug and Suzanne,

I will try the embedded Excel method. Doug, I apologize if I somehow

posted in error. I got here through the Microsoft site and still don't
quite understand how this might have been forwarded directly to you.
Anyhow, thank you for your help.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?UGF1bCBCZWFu?=,

I would like to be able to insert or delete rows in a table where the

right-most column has formulas that involve row locations. When I do this now, I
have to go back and individually correct the row position in each cell. Is there
a way to have the cells update automatically to their new position? I was able
to do this years ago with Lotus Ami Pro, but I have never been able to get Word
to do it.It can be done with a fairly complicated set of fields that makes it possible to
use relative cell references. If you're interested, look in the "Numbering"
section of my website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail