Refresh

Created by Harry Lewis, Modified on Mon, 25 Nov at 12:27 PM by Harry Lewis

Applies to:

Velixo NX

Note: This article reflects changes introduced in Velixo NX 2024.8

Using Refresh allows you to update the data returned by the Velixo functions in your report.

Velixo retrieves data from your database via the database's OData feed. To speed up further analysis, your data is cached within the Excel workbook. In this way, as you manipulate your data to fit the needs of your report, the results are displayed instantaneously.

This is most valuable when new data is available or when new accounts or subaccounts have been added to your database and your report includes Velixo List functions to display those values.

For example, if working with a Trial Balance report for the current period, Refresh will bring in any new transactions that have been entered into your database since the last time you refreshed your report.

Because only a subset of your data is being retrieved from the database, this can be done very quickly. The local cache is updated, and you are now working with up-to-date information.

See Refresh Features for details about each of the Velixo NX Refresh capabilities.