You can edit external data range properties that control how the Trillium data and metadata displays in a worksheet, including how Excel refreshes data.
To edit usage properties
-
In Excel, on the Data tab, click Existing Connections. The Existing Connections window opens.
-
Select the connection with which you want to work.
-
Click Open and then click Properties. The Connection Properties window opens.
-
Select the Usage tab for the refresh options. The default settings are loaded.
-
Modify the Refresh control properties as needed to manage when and how the query is refreshed.
Note: (OLE DB only) Each time data is refreshed, the data connection is used, and a license token is consumed against the client system. -
Modify the OLAP Server Formatting, OLAP Drill Through, and Language properties as needed.
-
Click OK to save the settings and close the window.