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 misdirection 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 CtrlF9  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  
AutoUpdate  New Users  
Auto update  Microsoft Word Help  
Word should auto update Formulas in the same way Excel does  Microsoft Word Help 