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: Force calculcation of all functions

Force calculation of all functions


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.

See also:

SQL*XL ribbon in Excel