View Single Post
  #1   Report Post  
Posted to microsoft.public.word.tables
Fev Fev is offline
external usenet poster
 
Posts: 11
Default 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