AX1763

Opening an Axiom file without refreshing data

When troubleshooting Axiom spreadsheet files, it can be helpful to open the file without performing any data queries. This allows you to review the file in its initial state, before any queries are run. It also allows you to open the file quickly, especially in cases where the file is configured to run many queries on open (or when one or more of the queries is time-consuming to run).

To open an Axiom spreadsheet file without refreshing data, use the Open Without Refresh feature. This feature is available on the right-click menu in the following locations:

• Axiom Explorer dialog
• Explorer task pane
• Open Plan Files dialog
• Reports Library dialog

NOTE: Open Without Refresh is only available to administrators.

Example Open Without Refresh option in the Open Plan Files dialog

When you open a file using Open Without Refresh, the following "file open" processes do not occur:

• Axiom queries set to Refresh on file open are not run.

• Data lookups listed in DataLookups to run on open are not run. However, data lookups using the reserved name AxRefreshOnOpen are still run.

• The option Refresh all Axiom functions on open is ignored (functions are not refreshed).

• If the file is configured to show a refresh dialog on open (using Refresh Forms Run Behavior), the refresh dialog does not display.

• The option Downgrade to read-only on open is ignored.