Ok, basically we have a number of expense reports that pull data from TM1 via DBRW queries per cost centre, and then another set of reports that extract matching transactions from a subledger database via MS Query into the XL sheet.
...basically the idea is to combine the two in the same sheet - now I know a VBA solution will work, but am wondering if anyone has had any success getting Print Report to refresh external data links (eg via MS Query) ? e.g. a particular combination of parameter settings in excel...?
cheers!
Matt