Reply
 
Thread Tools Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.word.tables
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Caculation Field error - !Index Too Large

I don't know which previous thread you are referring to (maybe you could
point it out), but...
a. If your bookmarks are inside text boxes, you could be in trouble...
b. if you are creating the bookmark names and "TM" does not refer to a cell
address within a table, avoid two-letter prefixes such as TM (e.g. use TAM1,
TAM2 etc.) Word may get confused, assume that TM is a cell address, and
return a null result.

Peter Jamieson

"Jack_Feeman" wrote in message
news
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


  #3   Report Post  
Margaret9121 Margaret9121 is offline
Junior Member
 
Posts: 19
Default Saca

When choosing the best ergonomic gaming chair, it's important to consider your budget and specific needs. Some chairs have additional features such as built-in speakers, massage functions, and footrests, while others focus solely on comfort and support. It's also important to look for chairs that have a weight capacity that can support your body type. see it here
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Index on large doc loops twice... Salty Microsoft Word Help 1 November 14th 06 09:32 AM
Create Index for large doucment Clinton Frederick Microsoft Word Help 2 June 8th 06 05:00 AM
Error processing large tables PromisedOyster Tables 0 November 13th 05 02:34 AM
Error processing large tables PromisedOyster Tables 0 November 13th 05 02:34 AM
index error V. Crocco Microsoft Word Help 1 March 29th 05 04:05 PM


All times are GMT +1. The time now is 06:18 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"