User guide

Using Excel with Datastream Advance for Office
Page 32 of 38
new row or column). If you select this option, any future processing of the Request Table will take into
account the new cell location. If you do not select this option, the data will always be inserted at the
same cell location.
If the destination reference is to a closed external workbook, you must ensure that the Display
Destination as Excel Formula check box is selected to enable the request table to open the workbook.
This is particularly important if you are scheduling the Request Table to be refreshed „out of hours‟ and
the Request Table contains references to external workbooks that will be closed when the process is
run.
12. Skip the cell column for Status as this is used by Datastream to inform you of the status of the latest
update of this request. OK indicates the update has been successful.
13. Place the cursor in the next adjacent cell, e.g., L7, and enter a short (optional) description for the request.
14. To add a chart request to the table, click the CH button. This displays all charts in open workbooks.
Select the chart required and the request string will be entered in the Series Lookup cell and the nearest
cell entered in the destination cell. Note the series used in the request string can be linked via a cell
reference.
15. From the Excel File menu, select Save to save the details of your Request Table.
The request is now ready to be processed.
REQUEST TABLE OPTIONS
The Request Table can be configured to always display the currency of the selected series and show your own
entered text (e.g, N/A) where data is not available from Datastream. The Always Include Currency option is
provided to ensure compatibility with data tables created with previous versions of the Request Table, i.e.,
DSDDE tables. Selecting this option makes it possible to use DSDDE tables where the currency is always
returned. You are also able to define which AFO Index you would like to add your table to.
To configure these options, click the Options button to display the Options dialog.
Select your Request Table options and click OK.