Q. How can I access the Datastream Excel plugin?
-
Browse:
- All
-
Topics
- 1Advertising
- 3Assistive Technology Room
- 1Bikes
- 4Book recommendation
- 8Books
- 9Borrowing, returning and renewals
- 2Building maintenance
- 34Cafe/Catering
- 3Cleaning
- 1Collections
- 5Complaint
- 49Compliment
- 1Contact information
- 2Copyright
- 9Customer service
- 3DVD collection
- 23E-Resources
- 2Economics & Finance
- 1Exams
- 6Finding resources
- 1Fines
- 10Food & Drink
- 18Furniture
- 4Group Study Rooms
- 2Hand-dryers
- 14Heating
- 1ID Card
- 17Inter-library loans
- 14IT
- 7Journals
- 1King James Library
- 1Library Account
- 1Library Collections
- 20Library environment
- 9Library equipment
- 25Library Facilities
- 2Library Search
- 11Library staff
- 1Lighting
- 1Lockers
- 93Main Library
- 1Management
- 2March/April 2020
- 25Martyrs
- 3Membership
- 4More Books
- 3Newspapers
- 14Noise
- 3Off-campus access
- 1Open Access
- 13Opening hours
- 1Parking ticket
- 1Password
- 1Photographic Collection
- 5Power sockets
- 3Pure
- 15Reading lists
- 1Recall
- 7Recycling
- 2Referencing
- 5Referencing software
- 3Research Information System
- 10Scan
- 3Searching
- 3Semester 2 2021-22
- 1Short loan
- 6Signage
- 8Smoking
- 1Special Collections
- 7St Mary's Library
- 6Stationery
- 27Study space availability
- 9Summer 2022
- 3Temperature
- 1Theses
- 19Toilets
- 3Vacation
- 6Vending machines
Answered By: Hilda McNae Last Updated: Apr 15, 2022 Views: 12
In order to access the Datastream Excel plugin you first need to have an account for Refinitiv Workspace, see How do I access Refinitiv Workspace
PC users
Installing the Refinitiv App will also install a Refinitiv toolbar in Excel from which you can access both Workspace and Datastream.
Mac users
Installing the Refinitiv App will also install the Refinitiv 365 plugin for Excel. You can use this to access data on Workspace but Refinitiv have not made the Datastream plugin to work with Excel on a Mac. If the data in Workspace isn't adequate for your needs and you also need Datastream then follow the instructions below.
- Contact library@st-andrews.ac.uk asking for access to Datastream via your Mac. Library staff will log a call with IT Services for you to be set up with alternative access. Once this has been completed:
- Go to Apps Anywhere
- Login when prompted and so it validates you
- Scroll through the Apps and find the one for Refinitiv Workspace
- Click on the arrow to the right of the green button and choose the first option in the drop down list - Workspace Excel Remote Reference Workspace.
- You may get a screen with a Redirect button on, if so click this and open up parallels software
- This will take several minutes but will then open up Excel (this is not the version of Excel on your own machine)
- Choose the tab along the Excel toolbar which says Refinitiv. If no buttons show then click on Sign in at the left hand side.
- At this stage it will automatically log you in with your University credentials
- Once the screen downloads it will look like this:. The Datastream options are on the right hand side of the Toolbar (starting with the Datastream Formula button)
- Once you have finished save your worksheet and close down the version of Excel you have been working in.
- If Parallels Client still shows as being open on your Mac then go to Sessions > Log Out All RAS sessions and then quit the application
Was this helpful? 0 0
Comments (0)
Related Topics
Chat with us
Tools
Navigation
Contact us
University of St Andrews Library
North Street
St Andrews
KY16 9TR
Service Desk: +44 (0)1334 46 2331