invalid character setting

[Girri 45]

When I insert a field containing the formula 'sum above' the cell containing
that formula gives back !Invalid chracter setting. This also happens when I
copy a properly working table in a word document from another computer. I am
using Office 2003. How can this be helped

 

[Beth Melton]

Are you using '=Sum(Above)' or '=Sum above'? If the latter then you
need to include the parenthesis around 'Above'.

Additionally, Sum(Above) is not always reliable. It is recommend you
use the cell addresses instead. For example: =Sum(A1:A5).

The Sum function will not calculate correctly if you have empty cells
in the range to be calculated. Word will sum up to the first empty
cell it finds.

Here's a KB article that provides more information on this issue:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;211263

Note although the article is for Word 2000 it is applicable for Word
6 - Word 2003.
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/