Share via

Excel error when updating Pivot Tables / An issue with the Data Model is preventing Microsoft Excel from opening this workbook. Try restarting Microsoft Excel

Anonymous
2023-10-10T21:49:14+00:00

Hi team,

I am from IT Department of an organization.

One of the customers sent me a file and the pivot tables cannot be refreshed.

When we tried to refresh the pivot table, it will get stuck with "Loading Data Model..."

And get this error message:

There are several connections, but not queries if I open "Queries & Connections".

And I get the same error if I want to delete any of it or check its properties.

What I have done here:

  1. Reboot
  2. Repair Office
  3. Try a different machine
  4. Open in Safe Mode
  5. Refresh anyway
  6. Use Sharepoint to open (Excel Online)
  7. Uncheck/Check this option as I found it on the Internet

None of the above helps.

And I tried to change it to zip file.

  1. I tried to delete xl/model folder. Well, I don't see the error message because the tables are no longer considered as pivot tables.
  2. I tried to delete connections.xml and it cannot be opened. I got prompt that the file is corrupted.

Please help with this. Thanks.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-10-11T01:50:49+00:00

    Could you share us that file (without sensitive information) to reproduce your issue? Then we may help you find the cause of it.

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2023-10-11T16:20:32+00:00

    You file link needs to be approved. You may share it as attachment in private message.

    0 comments
  4. Anonymous
    2023-10-11T16:28:18+00:00

    Please try again.

    0 comments
  5. Anonymous
    2023-10-11T17:22:41+00:00

    I have tried open data model to check what happened on it. But I cannot open the data model. It could be something corrupt in your file.

    I also checked most of the povit tables. It seems there is no need to use data model.

    The quickest way I think is to recreate entire workbook. Since your workbook contains much information in it, I'd suggest you raise a ticket to Microsoft.

    Create a support ticket via Microsoft 365 Admin Center> Support> New service request. That support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

    0 comments