Hi All,
I had the same problem as some of you above and I have a solution to this submitted which can be found in BOB’s Downloads that will allow you to refresh Live Office queries via a macro in newer versions of Microsoft Office (post 2003).
See here for the link :-
Cheers, Gary
gary_scott (BOB member since 2004-12-17)