Power Query and access to a folder with lots of pasword protected xlsx files

Power Query
1

I had problems in getting data from a folder that has a lot of xlsx files each of them has cells that are protected and the file itself is pasword protected.

Each month the template is sent to subsidiaries ( 9 ) this template is protected to prevent overwritting

is there a solution for this problem?

thanks in advance

Roger

2

Hi @Roger ,

you can check Data Mentor response: