User guide

Using Excel with Datastream Advance for Office
Page 18 of 38
Select, or deselect, the required format options and click the Submit button. The selected options are displayed
when you make a request.
Click the Default Option button to return the format options back to their default settings, which are made on the
Options dialog from the Datastream menu.
Select Display Data as MS Chart to chart your data using Microsoft Chart - if the embed option is selected, a
Refresh button is placed in the chart.
Format options for company accounts requests
As company accounts request formats dictate the layout of the presented data, you can only turn on/off the row
titles. For example, the company account code numbers for each item. All data is presented as if Transpose is
selected, that is, data is displayed for each item across the spreadsheet in rows.
EDITING AN EMBEDDED DATA REQUEST
There are two ways to edit data requests embedded in Excel. You can use the Request Manager to view the
details of all data requests embedded in your worksheet, edit the details, and resubmit the requests that are of
interest to you. See Using the Request Manager, for further details.
The quickest and most convenient method of editing an embedded data request in Excel is to right-click the
mouse over the top left-hand corner of the request to display the edit menu. If you originally issued the request
with the Visible format option turned on, you can right-click on the Refresh button to display the edit menu. If
the Visible option was turned off, use the Comments option from the Excel View menu to locate the top left-
hand corner of the request. For example:
When you have located the top left-hand corner of your embedded request, right-click to highlight the whole
request and display the edit menu.