Stuart McLachlan
stuart at lexacorp.com.pg
Wed Nov 9 15:05:18 CST 2011
Or, unless you need a snapshot at one point in time. On 9 Nov 2011 at 15:26, Mark Simms wrote: > > IMHO, this approach really beats all of the others....despite the huge > hassle that Microsoft has imposed for complex queries > Every time you open the Excel workbook....boom...the latest data is just > "there". Better yet: it can be refreshed every 30/60/whatever > minutes....even when users are changing the data. >