THIS WORKBOOKS DATA MODEL NO LONGER UNDER CONNECTIONS

Mischief63

New Member
Joined
Apr 15, 2017
Messages
21
What used to happen when you opened a workbook with a data model:

Data==>Query and Connections==> Excel would always create a robust connection to "ThisWorkbooksDataModel"

You'd close the workbook, and open it and it was always there. I noticed it disappearing before, but attributed it to perhaps my copying files from my home versus work computer.

Now you may get it to create the connection by changing the load on one of the queries, but it disappears the next time you open the workbook. I've tried all kinds of trial and error and I can't come up with a reason why it happens with some workbooks and not others. It happens when I create new workbooks. I use this feature to increase the rows that it'll show on a drill down. I'm using Office 365 Pro Plus, Version 2002, Build 12527.21104

Now it just shows this:

1603730021182.png


Any ideas?
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,122,239
Messages
5,594,996
Members
413,959
Latest member
SBM

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
Top