Update pivot tables after running ms query

[Dkso]

Hi and thanks to anyone that manages to help me.

I have 1 psreadsheet with a number of MS queries in (on different
sheets), these are all set to run on opening the workbook and also
every 30 mins. I also have a number of pivot tables in the same work
book that get info from the MS queries but I can't get the tables to
update when the queries do!

Can this be done and if so how?

Thanks

Regards Dean
(e-mail address removed)
www.dkso.co.uk/
http://homepage.ntlworld.com/dkso

 

[Ian Mac]

Hello,

I'm assuming you're using code.

Add:

ThisWorkbook.RefreshAll

As the last line

Kind
Regards

Ian