Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connect cell to a numbet on the Internet
Hello guys,
Somone told me is possible to connect a cell in excel to a number on the internet, and thus the value of the cell to change according to the number on the internet. Can this be done? Because i've searched the web and i did not find anything. Thank you all, Haris. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connect cell to a numbet on the Internet
Hi,
You may mean importing data, if so try this:- Select a cell and then Data|Import external data|New Web query A window pops up into which you could paste something like http://www.x-rates.com/ Click Go and you will be sent to a site that gives exchange rates. Select a table you want to import and then click import and your query will be populated to your worksheet. Rift click the query and click Data range properties to set up the refresh times. Mike "Haris" wrote: Hello guys, Somone told me is possible to connect a cell in excel to a number on the internet, and thus the value of the cell to change according to the number on the internet. Can this be done? Because i've searched the web and i did not find anything. Thank you all, Haris. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I connect a cell reference to a picture? | Excel Discussion (Misc queries) | |||
How do I connect two cells? If one cell changes the other changes | Excel Discussion (Misc queries) | |||
excell will not connect to internet | Excel Discussion (Misc queries) | |||
How can I get a postal code in a cell - from the internet? | Excel Worksheet Functions | |||
How do I connect cell color to bar chart color? | Charts and Charting in Excel |