Tips and Tricks¶

• Formulae that you add in columns immediately after the last column in a query will be automatically copies for each row in the result set when the query is refreshed

• When you are designing a spreadsheet it is better to create the query table and then delete all but a small representative sample of rows so that as you refine the formulae you need, the spreadsheet does not spend unnecessary time recalculating. Once you have got the formulae working to your satisfaction you can Refresh All to pull back the full data set with the formulae copied correctly.