Updating formulas
 

Can I create a button to refresh all the formulas. The IF statements
don't update when new information is input.


--
craftcenter
------------------------------------------------------------------------
craftcenter's Profile: http://www.excelforum.com/member.php...o&userid=33001
View this thread: http://www.excelforum.com/showthread...hreadid=528318

Updating formulas
 

Maybe Tools Options Calculation Check automatic calc

HTH
Regards,
Howard

"craftcenter"
wrote in message
...

Can I create a button to refresh all the formulas. The IF statements
don't update when new information is input.


--
craftcenter
------------------------------------------------------------------------
craftcenter's Profile:
http://www.excelforum.com/member.php...o&userid=33001
View this thread: http://www.excelforum.com/showthread...hreadid=528318

Updating formulas
 

see Calculate and Recalculation
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#calc

normally you can use F9 to recalculate,
Shift+F9 Calculate the active worksheet.
Ctrl+Alt+F9 Recalculates all cells on all worksheets in all open workbooks.

But asHoward indicates you definitely want to have calculation
set to automatic unless you have some really bad stuff.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"L. Howard Kittle" wrote in message ...
Maybe Tools Options Calculation Check automatic calc

HTH
Regards,
Howard

"craftcenter"
wrote in message
...

Can I create a button to refresh all the formulas. The IF statements
don't update when new information is input.


--
craftcenter
------------------------------------------------------------------------
craftcenter's Profile:
http://www.excelforum.com/member.php...o&userid=33001
View this thread: http://www.excelforum.com/showthread...hreadid=528318

Updating formulas
 

You could make sure that Tools?OptionsCalculation is set to Automatic.

To refresh you can hit F9 or CTRL + F9


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 15:52:17 -0600, craftcenter
wrote:


Can I create a button to refresh all the formulas. The IF statements
don't update when new information is input.