| | HTML is know a recognised file format for Excel | |
| | The HTML files that are currently created are rather large in comparison to the Excel file | |
| | You can now save worksheets as HTML | |
| | You cannot save any worksheets as web pages that are password protected. | |
| | You can obtain data from a web page and pull it into Excel using a web query. | |
| | An HTMl file consists of text information plus special tags that describe how the text should be formatted. | |
| | A browser interprets these special tags, and displays the text in the corresponding format. | |
| | A web query is a method that can be used to pull information from the Internet (or intranet). | |
| | A common use for web queries is to obtain stock prices, sports scores, company sales data etc. | |
| | Web queries can either prompt you for some parameters first or just get the same data every time. | |
| | It is possible to refresh the query at any time or at regular intervals. | |
| | You can also save your web query with the file extension (".iqy") so it can be easilt reused in another workbook. | |
| | To stop a web query, double click on the spinning globe and press "Stop Refresh". | |
