The Preferences icon will allow you to turn off both the History and Chart tooltip and the historical data refresh in addition to setting a timezone and hlighiting symbol cells of inactive or settled instruments.
Update the timezone in which the ‘Timestamp’, ‘Last Time (Available)’ and ‘VolumeTimestamp’ fields display by selecting Exchange, Local or GMT. Note, the data will require an update (tick) or a restart of excel to take effect.
Disable the History and Chart tooltip modal by turn off this preference. The tooltip is highlighted in red to the left below.
Disable Barchart for Excel’s auto refresh of historical data by turning the Historical Data Refresh off. When disabled, a sheet that contains historical data will not pick up the most recent data and will require a manual refresh.
Opt to Highlight the ‘Symbol’ cell for instruments that are currently settled or have not traded in their current open session.