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.

Excel sql connection string