In the Insert Function | Calculation menu there is a menu item
called "Force calculation of all functions". This menu item will force all Excel formula to recalculate.
Pressing F9 in Excel will also calculate the worksheet however if the source
data of the formula does not change Excel will not recalculate the formula. You
cannot run an Excel command to recalculate all functions. This is what selecting
this menu item will do. It will force Excel to recalculate all formulas.
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.