Background queries

Background queries allow you to continue using Microsoft Excel while the query processes on the server.
Note: When the background query is writing queried data to the Excel worksheet, you will not be able to work in Excel. When Excel is closed, all unwritten query data is purged.