Hi - I have 5 staff members that each have an individual workbook with pivot tables linked to data held another MASTER workbook that is password protected.
I need VBA code that will automatically refresh all the pivot tables in the Staff workbook when it is opened - but without opening the MASTER workbook as it is far too large.
And the password to the MASTER workbook needs to remain unseen by the Staff user.
I just need their workbooks to auto update when they open it. Please can someone help me?
I need VBA code that will automatically refresh all the pivot tables in the Staff workbook when it is opened - but without opening the MASTER workbook as it is far too large.
And the password to the MASTER workbook needs to remain unseen by the Staff user.
I just need their workbooks to auto update when they open it. Please can someone help me?
