Hi
try the following macro
sub foo()
activeworkbook.refreshall
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

"JL1981" schrieb im Newsbeitrag
...
...within a file or workbook to be refreshed with a single click.