Examples of using External data range in English and their translations into Greek
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Financial
-
Official/political
-
Computer
An external data range(also called a query table)
An external data range(also called a query table)
Note: If the external data range expands when you refresh,
There are several data objects(such as an external data range and PivotTable report)
The only exception to this is a PivotTable report that is connected to a data source- a PivotTable report does not use an external data range.
you can require that users enter the password before they can refresh the external data range.
which does not create an external data range.
you can require that users enter the password before they can refresh the external data range.
You can change the properties of an external data range to control data that has been imported into a worksheet through a connection to an external data source,
You can change these external data range properties by clicking Properties in the Connections group on the Data tab,
then click the name of the external data range from which you want to remove the data connection.
An external data range has additional properties(not to be confused with connection properties)
An external data range has additional properties(not to be confused with connection properties)
Remove data from the external data range before saving the workbook Select this check box if you want to save the workbook with the query definition
you can give other users a workbook that contains an external data range, or you can create a template.
Note: This check box is only available for an external data range that is converted from a Microsoft Office 2003 program, or to an external data range that is created programmatically.
you can require that the password is entered each time the external data range is refreshed.
Note: The following procedure applies only to an external data range that is converted from a Microsoft Office 2003 program, or to an external data range that is created programmatically.
Note: The following procedure applies only to an external data range that is created by using the Data Connection Wizard
External data ranges from databases are named with the name of the query.