Data Model Problem

[QB]

Hi, 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 was unaware that I had used the data model in this workbook.

Is there any way to remove the DM or do I need to rebuild the large and complex workbook? I cannot open the Manage Data Model dialogue.

Many thanks for any responses. QB

 

[JLGWhiz]

It is more than I can answer in a few words so go to this link and read it for yourself.

How to Fix “An issue with the data model is preventing Microsoft Excel from launching workbook”

Users face several issues on various devices, especially while trying to open MS Excel files. One of such error is “Data model restricting MS Excel Files to launch Workbook.” This error usually occurs while using earlier editions of MS Excel. Some users face issues “We couldn’t load the data...

miaminton.wixsite.com