I have multiple password protected files and a separate data compilation file which I am using to sum the data from the individual password protected files. I have created links and a pivot on the data compilation file. I am needing a macro to update the data from the password protected files so the data can be "live" when the macro is ran.