[Rathish]

I have a small situation and I am not able to find a workaround for that.
I would really be grateful if you could help me on the same.
The problem is that I am trying to calculate the average of 10 rows of a
table with the help of fields.

For example, we have used cells B2 to B11 to calculate
the average, in cell B12 i have inserted the formula as €œ=Average(B2:B11)€�.
This formula correctly calculates the average value based on the cell
references given.
If i have to delete a row from in between the table. In
this case what word does is that it changes the cell references. So the
calculation cell which was B12 in table A is now referenced as B11 which
contains the formula €œ=Average(B2:B11)€�. So indirectly the average figure
present in the last row is being taken in the calculation itself because of
changes in the referencing.
Can any one help us in solving this problem. Is there any work around
available,
which will allow cell references to get updated when a row is being deleted
or if you have any other suggestion please let me know about the same.
I would be very thank full to you.

Regards
Rathish

[Graham Mayor]

Word is not Excel and unlike Excel it does not intelligently reconstruct
formulae if you add or remove cells/rows. The only ways to do this are to
re-insert the correct formula
or
Use bookmarks instead of cell references
or
do all the calculations in Excel and link the relevant part of the table
into Word.

--

Graham Mayor - Word MVP

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


Rathish wrote:
I have a small situation and I am not able to find a workaround for
that.
I would really be grateful if you could help me on the same.
The problem is that I am trying to calculate the average of 10 rows
of a table with the help of fields.

For example, we have used cells B2 to B11 to calculate
the average, in cell B12 i have inserted the formula as
"=Average(B2:B11)". This formula correctly calculates the average
value based on the cell references given.
If i have to delete a row from in between the table. In
this case what word does is that it changes the cell references. So
the calculation cell which was B12 in table A is now referenced as
B11 which contains the formula "=Average(B2:B11)". So indirectly the
average figure present in the last row is being taken in the
calculation itself because of changes in the referencing.
Can any one help us in solving this problem. Is there any work around
available,
which will allow cell references to get updated when a row is being
deleted or if you have any other suggestion please let me know about
the same.
I would be very thank full to you.

Regards
Rathish

[Rathish]

Thanks for the early reply, is their any Macros for the same

"Graham Mayor" wrote:

Word is not Excel and unlike Excel it does not intelligently reconstruct
formulae if you add or remove cells/rows. The only ways to do this are to
re-insert the correct formula
or
Use bookmarks instead of cell references
or
do all the calculations in Excel and link the relevant part of the table
into Word.

--

Graham Mayor - Word MVP

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


Rathish wrote:
I have a small situation and I am not able to find a workaround for
that.
I would really be grateful if you could help me on the same.
The problem is that I am trying to calculate the average of 10 rows
of a table with the help of fields.

For example, we have used cells B2 to B11 to calculate
the average, in cell B12 i have inserted the formula as
"=Average(B2:B11)". This formula correctly calculates the average
value based on the cell references given.
If i have to delete a row from in between the table. In
this case what word does is that it changes the cell references. So
the calculation cell which was B12 in table A is now referenced as
B11 which contains the formula "=Average(B2:B11)". So indirectly the
average figure present in the last row is being taken in the
calculation itself because of changes in the referencing.
Can any one help us in solving this problem. Is there any work around
available,
which will allow cell references to get updated when a row is being
deleted or if you have any other suggestion please let me know about
the same.
I would be very thank full to you.

Regards
Rathish

[Rathish]

Can any one help me to resolve to get out this situation of calculating the
Average? Is their any macro that i can use ? please help me out.

"Rathish" wrote:

Thanks for the early reply, is their any Macros for the same

"Graham Mayor" wrote:

Word is not Excel and unlike Excel it does not intelligently reconstruct
formulae if you add or remove cells/rows. The only ways to do this are to
re-insert the correct formula
or
Use bookmarks instead of cell references
or
do all the calculations in Excel and link the relevant part of the table
into Word.

--

Graham Mayor - Word MVP

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


Rathish wrote:
I have a small situation and I am not able to find a workaround for
that.
I would really be grateful if you could help me on the same.
The problem is that I am trying to calculate the average of 10 rows
of a table with the help of fields.

For example, we have used cells B2 to B11 to calculate
the average, in cell B12 i have inserted the formula as
"=Average(B2:B11)". This formula correctly calculates the average
value based on the cell references given.
If i have to delete a row from in between the table. In
this case what word does is that it changes the cell references. So
the calculation cell which was B12 in table A is now referenced as
B11 which contains the formula "=Average(B2:B11)". So indirectly the
average figure present in the last row is being taken in the
calculation itself because of changes in the referencing.
Can any one help us in solving this problem. Is there any work around
available,
which will allow cell references to get updated when a row is being
deleted or if you have any other suggestion please let me know about
the same.
I would be very thank full to you.

Regards
Rathish

[Rathish]

Dear Sir,
As suggested by you i tried two options out of three the third option that
is to link excel with word can you please suggest the way to do it. I would
be very thankfull to you.

"Graham Mayor" wrote:

Word is not Excel and unlike Excel it does not intelligently reconstruct
formulae if you add or remove cells/rows. The only ways to do this are to
re-insert the correct formula
or
Use bookmarks instead of cell references
or
do all the calculations in Excel and link the relevant part of the table
into Word.

--

Graham Mayor - Word MVP

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


Rathish wrote:
I have a small situation and I am not able to find a workaround for
that.
I would really be grateful if you could help me on the same.
The problem is that I am trying to calculate the average of 10 rows
of a table with the help of fields.

For example, we have used cells B2 to B11 to calculate
the average, in cell B12 i have inserted the formula as
"=Average(B2:B11)". This formula correctly calculates the average
value based on the cell references given.
If i have to delete a row from in between the table. In
this case what word does is that it changes the cell references. So
the calculation cell which was B12 in table A is now referenced as
B11 which contains the formula "=Average(B2:B11)". So indirectly the
average figure present in the last row is being taken in the
calculation itself because of changes in the referencing.
Can any one help us in solving this problem. Is there any work around
available,
which will allow cell references to get updated when a row is being
deleted or if you have any other suggestion please let me know about
the same.
I would be very thank full to you.

Regards
Rathish

[Graham Mayor]

Reproduce your table in Excel. Select the table and copy to the clipboard.
Edit Paste special as a link into Word. Use Excel to make the calculations
and Word simply as a vehicle to display and print.

--

Graham Mayor - Word MVP

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


Rathish wrote:
Dear Sir,
As suggested by you i tried two options out of three the third option
that is to link excel with word can you please suggest the way to do
it. I would be very thankfull to you.

"Graham Mayor" wrote:

Word is not Excel and unlike Excel it does not intelligently
reconstruct formulae if you add or remove cells/rows. The only ways
to do this are to re-insert the correct formula
or
Use bookmarks instead of cell references
or
do all the calculations in Excel and link the relevant part of the
table into Word.

--

Graham Mayor - Word MVP

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


Rathish wrote:
I have a small situation and I am not able to find a workaround for
that.
I would really be grateful if you could help me on the same.
The problem is that I am trying to calculate the average of 10 rows
of a table with the help of fields.

For example, we have used cells B2 to B11 to calculate
the average, in cell B12 i have inserted the formula as
"=Average(B2:B11)". This formula correctly calculates the average
value based on the cell references given.
If i have to delete a row from in between the table. In
this case what word does is that it changes the cell references. So
the calculation cell which was B12 in table A is now referenced as
B11 which contains the formula "=Average(B2:B11)". So indirectly the
average figure present in the last row is being taken in the
calculation itself because of changes in the referencing.
Can any one help us in solving this problem. Is there any work
around available,
which will allow cell references to get updated when a row is being
deleted or if you have any other suggestion please let me know about
the same.
I would be very thank full to you.

Regards
Rathish

[Rathish]

Dear Sir,

Thanks a lot for your suggestion. I will try this out and let you know if it
worked or not. I hope if i required any help in future i can come to you.

Thanks & Regards
Rathish

"Rathish" wrote:

I have a small situation and I am not able to find a workaround for that.
I would really be grateful if you could help me on the same.
The problem is that I am trying to calculate the average of 10 rows of a
table with the help of fields.

For example, we have used cells B2 to B11 to calculate
the average, in cell B12 i have inserted the formula as €œ=Average(B2:B11)€�.
This formula correctly calculates the average value based on the cell
references given.
If i have to delete a row from in between the table. In
this case what word does is that it changes the cell references. So the
calculation cell which was B12 in table A is now referenced as B11 which
contains the formula €œ=Average(B2:B11)€�. So indirectly the average figure
present in the last row is being taken in the calculation itself because of
changes in the referencing.
Can any one help us in solving this problem. Is there any work around
available,
which will allow cell references to get updated when a row is being deleted
or if you have any other suggestion please let me know about the same.
I would be very thank full to you.

Regards
Rathish

[Graham Mayor]

There are always people ready to help (if they can) in this forum.

--

Graham Mayor - Word MVP

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


Rathish wrote:
Dear Sir,

Thanks a lot for your suggestion. I will try this out and let you
know if it worked or not. I hope if i required any help in future i
can come to you.

Thanks & Regards
Rathish

"Rathish" wrote:

I have a small situation and I am not able to find a workaround for
that. I would really be grateful if you could help me on the same.
The problem is that I am trying to calculate the average of 10 rows
of a table with the help of fields.

For example, we have used cells B2 to B11 to calculate
the average, in cell B12 i have inserted the formula as
"=Average(B2:B11)". This formula correctly calculates the average
value based on the cell references given.
If i have to delete a row from in between the table. In
this case what word does is that it changes the cell references. So
the calculation cell which was B12 in table A is now referenced as
B11 which contains the formula "=Average(B2:B11)". So indirectly the
average figure present in the last row is being taken in the
calculation itself because of changes in the referencing.
Can any one help us in solving this problem. Is there any work around
available,
which will allow cell references to get updated when a row is being
deleted or if you have any other suggestion please let me know about
the same.
I would be very thank full to you.

Regards
Rathish