Refresh All Order

Henn Sarv 

Query and process data with Excel and Power BI

Excel offers the option of automatically updating queries at specific time intervals or when the file is opened. This can be beneficial if the source file changes frequently and you want to make sure you always have the latest data.

On the other hand however, it can lead to disruptive delays.

So it always depends on the respective Use case depends on whether an automatic update makes sense.

If the list of queries is not visible, open it via Data - Queries and Connections.
Right click on a query and choose Properties In the Query Properties dialog you can,

for example, set the query to be updated every hour.

Or you can have it automatically update each time you open the file.

If you enable this setting, you also have the option to use the “Remove data from external data area before saving worksheet”.

This means that the table with the imported data does not match the workbook
is saved, but must always be reloaded.

This reduces the file size, especially with large tables.

Another benefit of this setting is that
Data security: In the case of sensitive source data within a company network, the file is
with the query unusable as long as the user is outside the network.

Manual updates are even faster with the key combination Ctrl + Alt + F5.

I'm not a specialist in external connections, as well as Power Queries and Power BI.

Can only handle languages ​​well and have researched this for you on the Internet.

All information without guarantee :)).
Hope this information can help you. If this is not what you are looking for please ignore it.

Thank you for your understanding and patience

Nikolino

I know I don't know anything (Socrates)