98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Excel
excel courses - Excel
Resolved · Low Priority · Version Standard
Mon 2 Jul 2007, 13:50Delegate Himani said...
Himani has attended:
Excel Introduction course
Excel
How do I link Reuters 3000 to a spreadsheet to obtain live rates?
Thu 5 Jul 2007, 15:54Trainer Amanda said...
RE: Excel
Hi Himani
Thank you for your question.
I'm not familiar with Reuters 3000, but if this is a web based service, you should be able to use Data - Import External Data - New Web Query then navigate to the web page and select the table showing the rates. Then click OK. At the bottom of the dialogue box showing on your screen, you should see a Properties button where you can adjust the Refresh control and say if you want the data to be replaced when it is refreshed etc. Then click OK, select where the data is to start from in your spreadsheet and click OK.
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:New to Excel 2010 - Sparklines!Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting. |
