in the document I am currently working on, I have several tables which act as the sources for Power Query queries. All of these tables are included in the very file I am working on.
However, when I open the file, I get the warning, that external data connections have been disabled.
While I would like to keep external data sources disabled (I am only using the tables in the file via Excel.CurrentWorkbook()), I would expect all the "internal" data sources to be enabled. However non of my queries is executed until I enable external data sources.
Is it possible to enable internal data sources, while keeping external data sources disabled and how can I possible tell Excel how so distinguish between internal and external data sources?