Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Menu items

Buy now

Download now

SQL*XL online help

SQL*XL: Calculate SQL*XL Functions

Calculate SQL*XL Functions


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.

See also:

SQL*XL ribbon in Excel