Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel courses - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Excel

excel courses - Excel

ResolvedVersion Standard

Himani has attended:
Excel Introduction course

Excel

How do I link Reuters 3000 to a spreadsheet to obtain live rates?

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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.