Hi,

We're writing a macro that opens a number of workbooks and creates
links to their cells in a master data sheet, and then closes them. The
issue arises when the sheet we are opening contains links to external
sheets. The "This workbook contains one or more links that cannot be
updated." "Continue" or "Edit Links" dialog box comes up. At this point
the user has to click Continue for the macro to keep functioning.

Naturally this defeats the purpose of the macro, does anyone know the
way around this ?

Thanks,
Rob.