User guide
Using Excel with Datastream Advance for Office
Page 3 of 38
1 USING RIBBON BASED UI FOR AFO (IN MS-OFFICE 2007 AND ABOVE)
When you install Datastream.xlam component, Datastream is available as an Add-In tab. Datastream provides
following facilities in the form of seven separate groups.
Figure: Datastream.xlam
Note AdvanceOffice.xlam is also available in the installation folder. However, it is not the preferred
Office 2007 add-in as it does not contain links to Datastream Charting which provides extensive
interactive charting functionality.
Series Requests:
This group consists of three
buttons.
Create a one off or embedded request for a series or list and
datatype/expressions at one point in time.
Create a one off or embedded request for a series or list and
datatype/expressions over time.
Create requests for fundamentals information and view, update and edit
your embedded requests. This drop-down list contains following buttons:
1. Company Account Request: Request company fundamentals
information using a pre-specified format.
2. Request Manager: View, update and edit all requests in your
workbook.
3. Refresh Workbook: Refresh all the data and chart requests in
your workbook.
4. Resize Embedded Charts: Enable the resizing of embedded
charts in your workbook.
5. Datachannel Buttons - Hide: Hide all Datachannel buttons in your
workbook.
6. Datachannel Buttons – Show: View all Datachannel buttons in
your workbook.
7. Search for Dead Codes – Active Sheet: Search dead codes in
active sheet.
8. Search for Dead Codes – Workbook: Search dead codes in
active workbook.
Request Tables:
This group consists of three
buttons.
Open a new Request Table to create, manage and update spreadsheets
effectively with multiple Datastream requests. This drop-down list contain
following button:
1. Office 2003 Request Table: Open an Office 2003 Request Table
in Office 2007 from the New Request Table drop down.
Access a library of spreadsheets illustrating how the Datastream content
sets can be used in different range of workflows.
Upgrade spreadsheets with old DSDDE links, embedded requests or earlier
version request tables to the latest version.