User guide

Using Excel with Datastream Advance for Office
Page 20 of 38
To select these options:
1. Choose Options from the Datastream menu.
The Options dialog is displayed.
2. Select the options you require by checking the boxes:
Request format options
These options define the default display options for data requests in Excel. They can be overridden by the
request format options on the Static Data Request, Time Series Request and Company Accounts Request
dialogs. Clicking the Default Option button on these dialogs returns the format options back to the default
settings on the Options dialog.
Changes to the settings on the Options dialog will only take effect after Excel has been re-launched, or if the
Default Option button on the request dialog is used.
The request format options are:
Row Titles - displays the series code at the head of each row for each series.
Col Titles - displays the datatype mnemonic at the top of each column.
Headings - displays a general heading for row and column titles, for example, the date of the request.