excel desktop 365 does not recognize encrypted files.

Juan Henao 1 Reputation point
2022-06-12T12:09:22.353+00:00

Error: "We found a problem with some content in '****.xlsx'. Do you want us to recover as much as we can?...."
Windows 10 pro
Excel does not even prompt for a password.
But if I change the extension to 'xls' now excel will prompt for password and open the file

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,546 Reputation points
    2022-06-13T04:35:15.93+00:00

    Hi @Juan Henao

    Welcome to Q&A forum ~

    Can this .xlsx file be opened normally with Excel for Microsoft 365 Apps on other computers or other versions of Excel?

    As you can open this file after change the file extension, please check whether there is any external data, such as the table from Power Query.
    If so, it's recommended to back up the file fist, then open it and click the table > Table Design tab > External Table Data group, click Unlink. Save it as the .xlsx file to check this issue.

    I suggest also you open this file in safe mode to have a check. Safe mode can help us troubeshooting the start items and COM add-ins.

    • Please hold on Ctrl key, click or double-click Excel icon, until Excel asks you to start Excel in safe mode, then please release Ctrl key and click "Yes".
    • And then browse this .xlsx file to open.

    Any updates, welcome to post back.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.