Good Day,

I have two excel workbooks that have a password to open them. They are linked to each other. The issue I am having is when I open the one with the links and say yes to update, it doesn't update and gives me N/A# in the fields? If I open the linked workbook and do the update it works. If I remove the passwords to open, it works.

Does anyone have suggestions on why it won't update? I have also recreated the links and it still doesn't work without either having the other workbook open or removing the passwords.

Thanks