I have a rather large workbook that I have to update and archive every 90 days. Within my workbooks there are 50-200 tabs that are all password protected, as this is a shared workbook. I am having an issue with my links this time around. After choosing the new source to link my workbook to it usually has me put in the password for each individual tab within my workbook and once I have done this, it will tell me the source is OK and off I go, but this time around it just continuously asks for the password even after I have gotten to all of the tabs. I am not sure what to do, I spent my entire day putting passwords in and it still isn't correct.
HELP ANYONE?