See Chip Pearson's page on Application.OnTime

http://www.cpearson.com/excel/ontime.htm

from help on UpdateLink:

This example updates all links in the active workbook.

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

I don't see what role pastespecial has to play. Perhaps you could use the
macro recorder to figure out that code.

--
Regards,
Tom Ogilvy


"flyboy0204" wrote in message
...
I need what I think would be a simple macro to an advanced user. It needs
to
start when the book is opened and update all external links (paste
specials)
every 20 secconds. I have no idea what commands are needed to do this and
have no idea where to look for information to make it myself. Im using
excel
2003. Please help.

Thank you,
Flyboy