i'm not sure if the client's settings are going to be set to auto update links
or not. in the workbook, under edit/links , i set the startup prompt to "don't
display the alert and update links". it still prompts. i tried workbook open
code:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

still get the prompt. how do i programmatically turn it off? the workbook is set
to read only recommended.

--


Gary