Power Query Warning: External Data Connections have been disabled

Occasional Visitor

Hi,

 

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?

 

Your input is highly appreciated!

 

0 Replies