In the Insert Function | Calculation menu there is a menu item
called "Calculate SQL*XL Functions". Selecting this menu item will force all SQL*XL formula to be recalculated.
You may want to use this function instead of using the Volatile versions of
the SQL*XL functions provided. Volatile functions will always be recalculated by
Excel, therefore they can potentially slow down the worksheet calculation.
This menu item therefore offers the possibility to manually refresh all your
SQL*XL functions so you don't have to use Volatile functions.
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.