I have 10 excel files that contain a table with many columns and many rows and that need to be updated frequently with new data. In order to have a faster record of some data from these files, I created a separate excel file that centralizes them all 10 files by external pivot table data and with automatic refresh when it is opened. The problem came when I encrypted the 10 files by password so I can access them only. When I open the pivot table file it gives me an error because it cannot find the source files anymore. Can anyone help me please?