Stephen L. Nelson

Most of the earlier sections of this chapter presuppose you use Excel to create data you then pass along to other programs and people. While many people are very likely to use Excel in this way, you may use Excel to retrieve data created or stored by some other program. In the final pages of this … [Read more...] about Retrieving External Data with Excel

Excel 2000 provides a special command—the File menu’s Save As Web Page command— for creating a web page version of an Excel workbook. You can also use the Save As Web Page command for creating interactive spreadsheet components for web pages. The paragraphs that follow describe how you do both of … [Read more...] about Sharing Excel Data Over the Web

Excel provides several useful tools for sharing your actual workbooks, rather than just the information they contain. You can tell Excel to save or open workbooks in formats accept- able to other spreadsheet programs. You can direct Excel to save your workbooks on a net- work drive and then make the … [Read more...] about Sharing Workbook Files in Excel

Microsoft Windows itself provides a powerful and easy-to-use tool for sharing data known as OLE, or Object Linking and Embedding. With OLE, you can transfer data between Excel and other Windows’ programs, as described in the paragraphs that follow. How OLE Works In order to make sense of OLE, it’s … [Read more...] about Using OLE with Excel