web queries

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Web queries

Web queries

resolvedResolved · Low Priority · Version 2003

Anna has attended:
Access Introduction course
Excel Advanced course

Web queries

how can i import live data from the web?

RE: web queries

Hi Anna,

Thank you for your question.

If you need to import live data from the web, then you need to go to Data, Import External Data and type the web address into the address line.

Once the page is found look for the data you want to import and select the little box that has an arrow with a yellow background which appears at the top left of the data. Then click Import.

I hope this answers your question.

Regards

Simon


 

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips


Server loaded in 0.1 secs.