1 Reply Latest reply on May 31, 2013 9:50 AM by Toby Erkson

    Speeding up worksheet data pulls: One big dataset for the workbook or individual ones per sheet?

    Toby Erkson

      Is the best thing to do is only pull data that is necessary for the worksheet?  Since a workbook can have multiple connections to data sources, in one worksheet could one connect to the data source and pull just the necessary fields but on the next worksheet there would be a connection to the same data source but with a different connection name and thus pull a different set of data?

       

      I'm pretty sure this will help speed up live connections to data sources.  Am I correct?