Auto Update Formulas

[silentpro]

Ok... I think I got the formulas to calculate a table in word '07, but now I
have to right click & update the cells that "total" my calculations.

How can I make the cells auto calculate once a change is made in another
cell?

Example:

B2:B36, has a drop down of 1 or 0. B37 will show the total of "1's". But
I have to r click on B37 & select Update to show the new value....

Plz help.....

 

[macropod]

Hi silentpro,

Simply set each of your Dropdown formfields' properties to 'calculate on exit'.

 

[silentpro]

I have that set & they still don't auto calculate the totals.....??....

Anything else I need to check?

Hi silentpro,

Simply set each of your Dropdown formfields' properties to 'calculate on
exit'.

--
Cheers
macropod
[Microsoft MVP - Word]

Ok... I think I got the formulas to calculate a table in word '07, but
now I have to right click & update the cells that "total" my
calculations.

How can I make the cells auto calculate once a change is made in another
cell?

Example:

B2:B36, has a drop down of 1 or 0. B37 will show the total of "1's".
But I have to r click on B37 & select Update to show the new value....

Plz help.....

 

[macropod]

Hi silentpro,

Are you sure your formula has the correct range references?

--
Cheers
macropod
[Microsoft MVP - Word]

I have that set & they still don't auto calculate the totals.....??....

Anything else I need to check?

Hi silentpro,

Simply set each of your Dropdown formfields' properties to 'calculate on
exit'.

--
Cheers
macropod
[Microsoft MVP - Word]

Ok... I think I got the formulas to calculate a table in word '07, but
now I have to right click & update the cells that "total" my
calculations.

How can I make the cells auto calculate once a change is made in another
cell?

Example:

B2:B36, has a drop down of 1 or 0. B37 will show the total of "1's".
But I have to r click on B37 & select Update to show the new value....

Plz help.....

 

[silentpro]

Yes I am, & I even double checked it just to make sure I was answering
truthfully.

Is there possibly an option I have turned off?

Hi silentpro,

Are you sure your formula has the correct range references?

--
Cheers
macropod
[Microsoft MVP - Word]

I have that set & they still don't auto calculate the totals.....??....

Anything else I need to check?

Hi silentpro,

Simply set each of your Dropdown formfields' properties to 'calculate on
exit'.

--
Cheers
macropod
[Microsoft MVP - Word]


Ok... I think I got the formulas to calculate a table in word '07, but
now I have to right click & update the cells that "total" my
calculations.

How can I make the cells auto calculate once a change is made in
another cell?

Example:

B2:B36, has a drop down of 1 or 0. B37 will show the total of "1's".
But I have to r click on B37 & select Update to show the new value....

Plz help.....

 

[macropod]

Hi silentpro,

I'm sorry, but it seems I've gave you a bit of mis-direction in the other thread - you can't use {=SUM(C2:C36)}
Instead, you'll need to use:
{={REF Dropdown1}+{REF Dropdown2}... +{REF Dropdown34}+{REF Dropdown35}}
where Dropdown1 ... Dropdown35 are the Dropdown field bookmark names.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[Microsoft MVP - Word]

Yes I am, & I even double checked it just to make sure I was answering truthfully.

Is there possibly an option I have turned off?

Hi silentpro,

Are you sure your formula has the correct range references?

--
Cheers
macropod
[Microsoft MVP - Word]

I have that set & they still don't auto calculate the totals.....??....

Anything else I need to check?



Hi silentpro,

Simply set each of your Dropdown formfields' properties to 'calculate on exit'.

--
Cheers
macropod
[Microsoft MVP - Word]


Ok... I think I got the formulas to calculate a table in word '07, but now I have to right click & update the cells that
"total" my calculations.

How can I make the cells auto calculate once a change is made in another cell?

Example:

B2:B36, has a drop down of 1 or 0. B37 will show the total of "1's". But I have to r click on B37 & select Update to show the
new value....

Plz help.....