| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Auto Update Formulas
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..... |
|
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Auto Update Formulas
Hi silentpro,
Simply set each of your Dropdown formfields' properties to 'calculate on exit'. -- Cheers macropod [Microsoft MVP - Word] "silentpro" wrote in message ... 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..... |
|
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Auto Update Formulas
I have that set & they still don't auto calculate the totals.....??....
Anything else I need to check? "macropod" wrote in message ... Hi silentpro, Simply set each of your Dropdown formfields' properties to 'calculate on exit'. -- Cheers macropod [Microsoft MVP - Word] "silentpro" wrote in message ... 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..... |
|
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Auto Update Formulas
Hi silentpro,
Are you sure your formula has the correct range references? -- Cheers macropod [Microsoft MVP - Word] "silentpro" wrote in message ... I have that set & they still don't auto calculate the totals.....??.... Anything else I need to check? "macropod" wrote in message ... Hi silentpro, Simply set each of your Dropdown formfields' properties to 'calculate on exit'. -- Cheers macropod [Microsoft MVP - Word] "silentpro" wrote in message ... 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..... |
|
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Auto Update Formulas
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? "macropod" wrote in message ... Hi silentpro, Are you sure your formula has the correct range references? -- Cheers macropod [Microsoft MVP - Word] "silentpro" wrote in message ... I have that set & they still don't auto calculate the totals.....??.... Anything else I need to check? "macropod" wrote in message ... Hi silentpro, Simply set each of your Dropdown formfields' properties to 'calculate on exit'. -- Cheers macropod [Microsoft MVP - Word] "silentpro" wrote in message ... 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..... |
|
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Auto Update Formulas
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] "silentpro" wrote in message ... 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? "macropod" wrote in message ... Hi silentpro, Are you sure your formula has the correct range references? -- Cheers macropod [Microsoft MVP - Word] "silentpro" wrote in message ... I have that set & they still don't auto calculate the totals.....??.... Anything else I need to check? "macropod" wrote in message ... Hi silentpro, Simply set each of your Dropdown formfields' properties to 'calculate on exit'. -- Cheers macropod [Microsoft MVP - Word] "silentpro" wrote in message ... 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..... |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto update | Microsoft Word Help | |||
| Update auto checked but date and time do not update when I reopen | Microsoft Word Help | |||
| Auto-Update | New Users | |||
| Auto update | Microsoft Word Help | |||
| Word should auto update Formulas in the same way Excel does | Microsoft Word Help | |||
Linear Mode
