Adding Query To Worksheet
Once all editing is done on the query you can load it into the current worksheet. In the upper left corner click ‘Close & Load’.
Your query is returned to the current worksheet as a ‘live’ link – meaning any updates to the database will be reflected each time you open the Excel file.
