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 consultants - New Web Query.
excel consultants - New Web Query.
Resolved · Low Priority · Version Standard
Tue 23 Jan 2007, 07:57Delegate Stephen said...
Stephen has attended:
Excel Intermediate course
New Web Query.
Hi,
I would like to import a web query on a website which streams live prices of the FTSE markets and other UK markets.
Is there some way in which I can import this data and have it refresh in real time when the market moves?
Thanks very much for your help.
Stephen.
Tue 23 Jan 2007, 12:14Trainer Richard said...
RE: New Web Query.
Copy and paste static data or a refreshable query
You can use familiar copy and paste commands to bring the data from a Web page into an Excel worksheet. When you paste Web page data into Excel, you can keep the data static or make it refreshable by clicking Paste Options and clicking Create Refreshable Web Query.
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:Toggle Formulas and ResultsCtrl + 'The key above Tab with the |
