User guide

Using Excel with Datastream Advance for Office
Page 33 of 38
UPLOAD LIST BUTTON
The Upload List button in the request table can be copied to a sheet that has back office codes to upload.
There are two modes that can be configured by right clicking on the button and selecting the list option.
You can create either local or mainframe lists using the Create a new list option, Click here for more details.
Or you can use the same mainframe user list (L#XXXX) each time the back office list in the spreadsheet is
amended by using the Update a Mainframe List option.
Double click the button to display the list details and to update the list.
THE SERIES NAVIGATION BUTTON
You can link the Series Navigation button to a cell in the Request Table, giving you access to the
Datastream series selection dialogs (for all series including user lists). Double click on the Series Navigation
button on the spreadsheet to select a different series.