If you are comfortable with VBA , record a macro where you refresh the
web query and then refresh the pivot table - then assign the macro to a
button. From then on all you have to do is run one macro.


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=375717