Examples of using External data range in English and their translations into Romanian
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Ecclesiastic
-
Computer
-
Programming
you can give other users a workbook that contains an external data range, or you can create a template.
you can give other users a workbook that contains an external data range, or you can create a report template.
you can give other people a workbook that contains an external data range, or you can create a report template.
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.
but not as an external data range.
cells directly under the external data range move down, but cells to the right of the external data range do not move.
Excel copies only those formulas that are immediately adjacent to or within the external data range.
formulas that are not part of the external data range, select the cells that contain the column labels
cells directly under the external data range move up, but cells to the right of the external data range do not move.
cells directly under the external data range are overwritten,
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 created by using the Data Connection Wizard or Microsoft Query(and not to an imported text file or Web query), an external data range converted from a Microsoft Office 2003 program, or an external data range created programmatically.
you can import the text file as an external data range(which does make a connection to the text file).
Manage external data ranges and their properties.
External data ranges from databases are named with the name of the query.
Manage external data ranges and their properties- Excel.
All external data ranges that are created by using the user interface are created as Excel tables.
Excel Services does not support external data ranges, which means that Excel Services does not support an Excel Table connected to a data source,
You can change these external data range properties by clicking Properties in the Connections group on the Data tab.
On your sheet, click the cell where you want to place the upper-left corner of the external data range, and then click OK.