Enabling a prompt before Excel is locked to write data
When this option is set, a prompt will appear when a background query is finished processing on the server. This allows you to choose to either write the data immediately or postpone the action.
- Select .
- If background queries have not yet been enabled, select Run Process in Background.
- Close the Settings window.
- Select .
- Insert a query and click Refresh All.