![]() If the command type is SQL, the SQL query used to specify the data returned is displayed. For example, if the command type is Table, the table name is displayed. If the connection is to an OLAP data source, Cube is displayed, but you cannot change the command type.Ĭommand text Specifies the data returned based on the command type. This information may be stored as plain text, and a malicious user could access the information to compromise the security of the data source.Ĭommand type Select one of the following command types: ![]() Important: Avoid saving logon information when connecting to data sources. Clear this check box to use the connection information in the Excel workbook. You can change the connection, but you cannot switch connections between the following objects:Ī non-OLAP PivotTable or PivotChart reportĪlways use connection file Select this check box to ensure that the most up-to-date version of the connection file is always used whenever the data is displayed or refreshed. Make sure that the new connection file is consistent with the object that has the data connection. You can then select the revised connection file, a different connection file, or create a new connection file by clicking New Source, which starts the Data Connection Wizard. To re-establish the link to the connection file, for example because it was updated and you want to use the new version, or to change the current connection and use a different connection file, click Browse, which displays the Select Data Source dialog box. If this field is blank, a connection file was never used, or it was used and then modified so that the link to the connection file was broken. The settings on the Definition tab control how the connection information is defined and the source of the connection information, either the workbook or a connection file.Ĭonnection type Displays the type of connection that is used, such as Office Data Connection or Microsoft Access Database.Ĭonnection file Displays the current connection file that is used to store the connection information and enables switching to a revised or new connection file. Retrieve data and errors in the Office display language when available Select or clear this check box to enable or disable the retrieval of translated data and errors, if any, from the OLAP server. Maximum number of records to retrieve Enter a number from 1 to 10,000 to specify the maximum number of records to retrieve when you expand a level of data in a hierarchy. Text Color Select or clear this check box to enable or disable text colors. Number Format Select or clear this check box to enable or disable number formatting, such as currency, date, or time.įont Style Select or clear this check box to enable or disable font styles, such as bold, italic, underline, or strike-through.įill Color Select or clear this check box to enable or disable fill colors. This check box becomes available only after you select the Refresh data when opening the file check box.Ĭontrols whether the following OLAP server formats are retrieved from the server and are displayed with the data. Clear this check box to save the query definition and data with the workbook. 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 but without the external data. Clear this check box to immediately open the workbook without refreshing external data. Refresh data when opening the file Select this check box to automatically refresh external data when you open the workbook. ![]() Clear this check box to disable automatic external data refresh. Refresh every n minutes Select this check box to enable automatic external data refresh at regular time intervals, and then enter the number of minutes between each refresh operation. Running a query in the background enables you to use Excel while the query runs. Clear this check box to run the query while you wait. The settings on the Usage tab control the way that the connection information is used in the workbook.Įnable background refresh Select this check box to run the query in the background.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |