I’ve seen it said that you cannot linked password protected workbooks but I’m hoping the person that posted that, just didn’t know how to do it.
I have three workbooks used by different teams in the same department. The ‘Master’ workbook pulls back data a2 through r400 from WB ‘Raw Data’ and s2 through w400 from WB ‘Review.’
All three of these workbooks are used by different teams (Quality for Master, Accounts for Raw Data, Review for Review) which is why they’re password protected.
Is there anyway to NOT have to put in the password for the fields on Master to automatically update?