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:
Any ideas?
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:
Any ideas?