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 kommentar(er)
