Power pivot/Power query doesn't work neither data models

Ali SEMLALI 1 Reputation point
2021-10-17T12:25:20.087+00:00

hello, I have MSFT OFFICE 365 PRO PLUS entreprise : 16.0.11328.20362 and powerpivot does not work, it gives me errors, also the data model. Lots of error messages, I don't know what to do. I can't work for now .... PLEASE HELP.

141017-erreur3.png141135-erreu1.png141114-erreur4.png141102-excelprobleme.png141103-capture2.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,235 questions
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,648 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viki Ji_MSFT 4,421 Reputation points
    2021-10-18T09:10:53.603+00:00

    Hi @Ali SEMLALI ,
    Welcome to Q&A forum!

    According to the information you provided, I want to confirm the following information with you.

    • When did this issue start? What did you perform before this issue?
    • Can you open the Excel app and other Excel files normally? If this issue only occurs with a special file, how and where did you get it?

    If it was created by an earlier version, it may be known issue, please refer to: Upgrade Power Pivot Data Models to Excel 2013 or Excel 2016.

    If the issue persists, you can also try to delete the Data Model completely, and then try to recreate it to check whether the issue can be fixed:

    1. Close the file.
    2. Open this .xlsx file with your favorite compression software.
    3. Delete the "/xl/model" folder.
    4. Open Excel again, and you will see a prompt telling you that Excel needs to repair this file.

    Note: Please back up the file before changing the file.

    Any updates, please let me know.

    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.