View Single Post
  #1   Report Post  
Posted to microsoft.public.word.tables
Jack_Feeman Jack_Feeman is offline
external usenet poster
 
Posts: 8
Default Caculation Field error - !Index Too Large

I read the previous thread with this error cited but could not apply the
answers to fix my problem. Nothing complex:

I have a financial seection of a Word form. There are three calculation
(formula)fields in this section. The first two work fine now that I finally
figured out the way to go (recognizing the split table I have does not make
the normal process any simplier) was to assign unique book marks to each text
entry box in the calculation and refer to the book marks in the formula. As I
mention this worked great in the first two calcuation fields. The third
however, did not fair so good. the formular looks like this (modeled after
the working ones):

=SUM(TM1,TM2,TM3,TM4,TM5,TM6,TM7,TM8,TM9,TM10,TM11 )

where TM* are the unique bookmarks assign to the text boxes in each cell of
the table referenced in the formula. Based on the prior thread, I verified
that each text box was configured for number and format for currency. I
filled in values for each text box and made the cell which houses the formula
big enough to handle 10 digit numbers.

However, I still get the "!Index Too Large" syntax error (only on this one,
not on the otehrs). The bookmarks are for text boxes that are in different
locations in the table (not contingent cells).

Appreciate it if anyone can shed light on this as it is the last thing
keeping this project open. Thanks Jack