Importing Password protected worksheets & workbook in power query to consolidate data RRS feed

  • Question

  • I have a folder containing many files from different regions. Some of the worksheets and workbooks are password protected which while using power query gives the following error:

    Unable to Connect

    We encountered an error while trying to connect.

    Details: "File contains corrupted data."

    Please provide your feedback to solve this issue.

    Tuesday, October 30, 2018 9:47 AM


All replies