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?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,223,911
Messages
6,175,333
Members
452,636
Latest member
laura12345

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