Linking excel to an exchange rate

AdminMarber

Hi,

Does anyone know how to link a cell in excel to an exchange rate? I have a spreadsheet based on showing costs in pounds, euros and Indian rupes. Ideally I would like the cells showing each of these exchange rates to update automatically when I open the excel spreadsheet.

I am using excel for the mac - not sure if that makes a difference.

Thanks.

[Deleted User]

Ok.. well you can get the rupee exchange rate (as a table) here - http://www.x-rates.com/d/INR/table.html

Now, you need to find an icon called 'From Web' (in mine it's under the Data tab). This will let you enter the URL. Then, select the table of data.

You'll need to use a lookup function to grab the data you want from that

AdminMarber

That is really helpful BUT it is the 'From Web' that I am having problems finding on the webexcel. Under data there is nothing connecting to the web - just an option to get external data and then three choices - import text file; import from filemaker pro OR import from Filemaker server.

Does anyone know where to find this link in excel for the mac?

Ainsley1

Try under Data/ Import external data/New web query enter web address in dialogue box, continue and set up refresh options in property box then OK etc.

(that was from Excel 2003 so other versions may be different or you may need to ensure appropriate bits of Excel are installed. Might be the Excel version for the Mac you have has different functionality so, if that doesn't work post back with your Excel version [see under help/about] and will give links to Excel forums who may be able to help more)

AdminMarber

Hi Ainsley
I am using excel 2008 for the mac. Version 12.3.1 - there is nothing with a new web query under the data tab I have.
Thanks,
Julia

[Deleted User]

Ok, it looks a bit harder to do in Excel 2008 Mac edition, but not impossible

http://support.microsoft.com/default.aspx?scid=kb;en-us;274787