Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Formula compounding on recalc
Hi
I have a table in Word 2003 or Word 2007 (I am testing this document in both versions) that adds a number of bookmarks in the same row {=sum (Balcon1,OPS1,Park1,Rental1,Str1)} that works well, until I choose to recalc the cell, table or the document. Each time a recalc happens the formula coumpounds itself - the intitial answer is 1,602.00. The next recalc provides the result 8,609.62, then 15,617.24 etc. Is there a way to prevent this? Thanks Heather |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Formula compounding on recalc
Hi Fev,
Your problem description suggests the cell containing the bookmark is included in one or more of the bookmarked ranges. Since you evidently know which cells to add the bookmarks to, why not simply use the cell addresses in your formula? -- Cheers macropod [MVP - Microsoft Word] "Fev" wrote in message ... Hi I have a table in Word 2003 or Word 2007 (I am testing this document in both versions) that adds a number of bookmarks in the same row {=sum (Balcon1,OPS1,Park1,Rental1,Str1)} that works well, until I choose to recalc the cell, table or the document. Each time a recalc happens the formula coumpounds itself - the intitial answer is 1,602.00. The next recalc provides the result 8,609.62, then 15,617.24 etc. Is there a way to prevent this? Thanks Heather |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Formula compounding on recalc
On Mar 12, 1:09*pm, "macropod" wrote:
Hi Fev, Your problem description suggests the cell containing the bookmark is included in one or more of the bookmarked ranges. Since you evidently know which cells to add the bookmarks to, why not simply use the cell addresses in your formula? -- Cheers macropod [MVP - Microsoft Word] "Fev" wrote in ... Hi I have a table in Word 2003 or Word 2007 (I am testing this document in both versions) that adds a number of bookmarks in the same row {=sum (Balcon1,OPS1,Park1,Rental1,Str1)} that works well, until I choose to recalc the cell, table or the document. *Each time a recalc happens the formula coumpounds itself - the intitial answer is 1,602.00. *The next recalc provides the result *8,609.62, then 15,617.24 etc. *Is there a way to prevent this? Thanks Heather- Hide quoted text - - Show quoted text - Hi Thanks for your quick response, I was using bookmarks as the values in the table are the result of a mailmerge from a large csv file and we then bookmarked all merge fields to be used in various calculations. I have tested it using the table cell references and it doesn't compound. I know I had a similar problem a while ago and after redoing the bookmarks and the formula the problem appeared to be resolved. I was just wondering where I was going wrong with the bookmark story. Is there a way to view the names and locations of all bookmarks in the document? I am viewing bookmarks so I can see the [ ] but would like to see their names as well. I know I can use Goto bookmark, but that would be rather tedious as there are over 100 bookmarks in the document. Thanks Fev |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Formula compounding on recalc
On Mar 12, 2:55*pm, Fev wrote:
On Mar 12, 1:09*pm, "macropod" wrote: Hi Fev, Your problem description suggests the cell containing the bookmark is included in one or more of the bookmarked ranges. Since you evidently know which cells to add the bookmarks to, why not simply use the cell addresses in your formula? -- Cheers macropod [MVP - Microsoft Word] "Fev" wrote in ... Hi I have a table in Word 2003 or Word 2007 (I am testing this document in both versions) that adds a number of bookmarks in the same row {=sum (Balcon1,OPS1,Park1,Rental1,Str1)} that works well, until I choose to recalc the cell, table or the document. *Each time a recalc happens the formula coumpounds itself - the intitial answer is 1,602.00. *The next recalc provides the result *8,609.62, then 15,617.24 etc. *Is there a way to prevent this? Thanks Heather- Hide quoted text - - Show quoted text - Hi Thanks for your quick response, I was using bookmarks as the values in the table are the result of a mailmerge from a large csv file and we then bookmarked all merge fields to be used in various calculations. I have tested it using the table cell references and it doesn't compound. *I know I had a similar problem a while ago and after redoing the bookmarks and the formula the problem appeared to be resolved. *I was just wondering where I was going wrong with the bookmark story. Is there a way to view the names and locations of all bookmarks in the document? *I am viewing bookmarks so I can see the [ * *] but would like to see their names as well. *I know I can use Goto bookmark, but that would be rather tedious as there are over 100 bookmarks in the document. Thanks Fev- Hide quoted text - - Show quoted text - I have just run some code that shows a message box for the bookmark that I have selected and discovered that 2 cells were being referenced by the same bookmark. I gather this created a circular reference. Thanks once again. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula | New Users | |||
Formula | Tables | |||
how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
Formula help? | Microsoft Word Help | |||
Formula help? | Page Layout |