Background queries

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