https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Large-Query/m-p/253708#M1790 If you are working with large data sets and do ad hoc queries a lot, the add in might not be the optimal tool. Enterprise Guide or SAS Studio offers more flexibility and possibilities to optimize and control query behaviour. Wed, 02 Mar 2016 07:24:21 GMT LinusH 2016-03-02T07:24:21Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Large-Query/m-p/253672#M1789 <P>can someone explain how does the SAS Excel Add-in work as far as loading the data from a large query? &nbsp;does SAS get the data in SAS dataset format first on the server and then download and convert to Excel format and load in the worksheet? &nbsp;how to improve the speed of loading a large amount of data on Excel using SAS? &nbsp;thanks.</P> Wed, 02 Mar 2016 02:25:57 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Large-Query/m-p/253672#M1789 Grumbler 2016-03-02T02:25:57Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Large-Query/m-p/253708#M1790 If you are working with large data sets and do ad hoc queries a lot, the add in might not be the optimal tool. Enterprise Guide or SAS Studio offers more flexibility and possibilities to optimize and control query behaviour. Wed, 02 Mar 2016 07:24:21 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Large-Query/m-p/253708#M1790 LinusH 2016-03-02T07:24:21Z