Recalculating
A dynamic link to your data source is maintained through your data extraction definitions. Click to update the definitions with the most recent values from your data source, and recalculate them to display the latest output.
Ensure you are connected to your data source before recalculating.
Click to recalculate all query definitions. You can also select from three recalculation options:
- : Recalculate all query definitions in your worksheet by selecting .
- : Recalculate all query definitions in your workbook by selecting .
- : Recalculate a single query definition or a selected range of definitions by highlighting the specific target cells, then selecting .
The Microsoft Excel is set to automatic when worksheets are processed in the Q&A DataLink Server. After a worksheet is recalculated the calculation mode is reset back to manual if that was the mode it was set to previously.