Hi,

i've a worksheet which is linked to the other sheet/workbook in the same
folder. All those worksheet are password protected but the workbook is not
password protected. When the linked worksheet is open as default featue it
ased whether to update data or not, i chose options as appropriate at
different time.

Problem is (some time not all the time) when i choose "Update" option but
the data didn't update when i try to manually update (EditLinkUpdate Value)
then it give a msg that from the sheet i want to update value are passworrd
protected so i have to unprotect the sheet and then update value.

Can anyone help me with any Macro, so that link data of protected sheet are
automatically updated. Maximum no of file linked is 16 to that sheet.