Working with Calculations in Word

[WordNovice]

I have a simple Word form that we use to capture costs by year. It is a
protected document with fields that are for input and fields that are locked.
We use a table for the user to enter costs by year. The table is 3 years
(wide) and 5 rows (tall) with row and column totals. The totals are
protected so the user can't edit. The totalling seems to work fine for most
however there are a few individuals where the totals are blank no matter
what. We guide users to use tab/shift-tab through this table in order to
trigger the calculations. Again, this works for most. If the totals work on
one pc and the saved doc is sent to a pc where it does not work then the
totals disappear as soon as that user presses the tab/shift-tab. First guess
is that this is an application setting somewhere in Word that I can't pin
down. Has anyone seen/resolved this type of behavior? Regards.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?V29yZE5vdmljZQ==?=,

My best guess would be that the form fields specify numeric formatting? And that
these number formats are perhaps not exactly the same as the number formats
defined in the Windows Control Panel's regional settings? So Word would be
seeing the numbers it should be totalling as text, rather than numbers...

I have a simple Word form that we use to capture costs by year. It is a
protected document with fields that are for input and fields that are locked.
We use a table for the user to enter costs by year. The table is 3 years
(wide) and 5 rows (tall) with row and column totals. The totals are
protected so the user can't edit. The totalling seems to work fine for most
however there are a few individuals where the totals are blank no matter
what. We guide users to use tab/shift-tab through this table in order to
trigger the calculations. Again, this works for most. If the totals work on
one pc and the saved doc is sent to a pc where it does not work then the
totals disappear as soon as that user presses the tab/shift-tab. First guess
is that this is an application setting somewhere in Word that I can't pin
down. Has anyone seen/resolved this type of behavior?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail