Data Model Error - Effecting all versions of the same workbook

Rollnation3

New Member
Joined
Aug 26, 2024
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
When I try to save or modify a pivot table in an open workbook, I keep getting this error message "An issue with the Data Model is preventing Microsoft Excel from opening this workbook. Try restarting Microsoft Excel".
I have tried previous versions of the same template that have always worked perfectly and get the same error.

It happened the day after duplicated the simple pivot table - a VERY simple data model that performs a distinct count of names in a data set. I then sent the workbook to a colleague via email.
Ever since I duplicated the pivot table I cannot refresh or work in the workbook without getting this error. This is happening throughout all versions of the same workbook.

Also tried to delete the pivot table and recreate it and still receive the same error.
I re-installed excel and still get the error.

I am using Excel 2016 professional plus, researching answers on the internet provide solutions for newer versions.
Any advice would be extremely valuable!

Thanks!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,880
Messages
6,175,154
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top