Sharing Data
`with Other
`Applications
`
`W indows applications
`
`to work together.
`are designed
`in Microsoft Office are an excellent
`The applications
`example. These programs have a common
`look and feel, and
`sharing data among these applications
`is quite easy. This
`chapter e,'"{p]ores some ways that you can make use of other
`applications while working with Excel, as well as some ways
`that you can use Excel while working with other applications.
`
`Sharing Data with Other Windows
`Applications
`
`files, the following are the
`importing and exporting
`Besides
`three ways in which you can transfer data to and
`essential
`from other Windows applications:
`
`• Copy m1d paste, using either the Windows Clipboard or
`the Office Clipboard. Copying and pasting
`information
`creates a static copy of the data.
`
`• Create a link so that changes
`in the source data are
`reflected
`in the destination
`document.
`• Embed an entire object from one application
`another application's
`document.
`
`into
`
`The following sections discuss
`an example for each one.
`
`these
`
`techniques
`
`and present
`
`emnosUSA0017323
`
`CiM Ex. 1054 Page 1
`
`

`
`Using the Windows or Office Clipboards
`
`to the
`is running, you have access
`As you probably know, whenever Windows
`that acts as a shared
`Windows Clipboard-an
`area of your computer's memory
`holding area for information
`that you have cut or copied from an application. The
`Windows Clipboard works behind
`the scenes, and you usually aren't aware of it.
`Whenever you select data and then choose either Edit• Copy or Edit• Cut, the
`the selected data on the Windows Clipboard. Like m<)St other
`application places
`the Clipboard data if you choose
`Windows applications, Excel can then access
`(or the Edit• Paste Special command).
`the Edit• Paste command
`
`If you copy or cut information while working in an Office application, the applica(cid:173)
`tion places the copied information on both the Windows Clipboard and the Office
`Clipboard.
`
`Once you copy information to the Windows Clipboard, it remains on the Windows
`Clipboard even after you paste it, so you can use it multiple times. However,
`because the Windows Clipboard can hold only one item at a time, when you copy
`or cut something else, the
`information previously stored on the Windows
`Clipboard is replaced. The Office Clipboard, unlike the Windows Clipboard, can
`hold up to 12 separate selections. The Office Clipboard operates in all Office appli(cid:173)
`cations; for example, you can copy two selections from Word and three from Excel
`and paste any or all of them in PowerPoint.
`
`is quite easy. The
`to another
`from one Windows application
`Copying information
`is called the source
`application
`that contains
`the information
`that you're copying
`application, and the application
`to which you're copying
`the info1-rnation is called
`the destination application.
`
`to another are as
`to copy from one application
`that are required
`The general steps
`follows. These steps apply to copying from Excel to another application
`and to
`copying from another application
`to Excel.
`
`the information
`
`that you
`
`I. Activate
`the source document window that contains
`want to copy.
`2. Select the information by using the mouse or the keyboard.
`If E.'i:cel is the
`source application,
`this information can be a cell, range, chart, or drawn object.
`3. Select Edit• Copy. Excel places a copy of the information onto the Windows
`Clipboard and the Office Clipboard.
`4. Activate
`If the program
`isn't running, you can
`application.
`the destination
`it without affecting the contents of the Clipboard.
`start
`5. Move to the appropriate
`position
`in the destination
`application
`want to paste the copied material).
`6. Select Edit• Paste from the menu in the destination
`Clipboard contents
`are not appropriate
`for pasting,
`grayed
`(not available).
`
`(where you
`
`Jf the
`application.
`the Paste command
`
`is
`
`emnosUSA0017324
`
`CiM Ex. 1054 Page 2
`
`

`
`steps, you also can select Edit• Cut from the source
`ln Step 3 in the preceding
`application menu. This step erases your selection
`from the source application
`placing the selection on the Clipboard.
`
`after
`
`If you repeat Step 3 in any Office application, the Office Clipboard toolbar appears
`automatically. It continues to appear if the destination application that you activate
`in Step 4 is another Office application.
`
`In Step 6 in the preceding steps, you can sometimes select the Edit• Paste Special
`command, which displays a dialog box that presents different pasting options.
`
`image, you may have to resize or crop it. If you're
`If you're copying a graphics
`te:x1:, you may have to reformat
`it by using tools that are available
`in the
`copying
`destination
`application. The information
`that you copy from the source applica(cid:173)
`tion remains
`intact, and a copy remains on the Clipboard until you copy or cut
`something
`else. Figure 29-1 shows an embedded Excel chart. You can easily insert
`a copy of this chart
`into a Microsoft Word report. First, select
`the chart
`in Excel
`by clicking
`it once. Then, copy it to the Clipboard by choosing Edit• Copy. Next,
`activate
`the Wm·cl document
`into which you want to paste
`the copy of the chart,
`to the place where you want the chart
`to appear.
`and move the insertion point
`When you select Edit• Paste from the Word menu bar, the chart
`is pasted
`from
`the Clipbom·d and appearn
`in your document
`(see Figure 29-2).
`
`Figure 29-1: An Excel chart, ready to be copied into a Word document.
`
`emnosUSA0017325
`
`CiM Ex. 1054 Page 3
`
`

`
`Figure 29-2: The Excel chart copied to a Word document.
`
`that Windows applications vary in the way that they
`You need to understand
`respond to data that you paste from the Clipboard. If the Edit• Paste command
`is not available (is grayed on the menu) in the destination application, the appli(cid:173)
`cation can't accept the information from the Clipboard. If you copy a range of
`data from Excel to the Clipboard and paste it into Word, Word creates a table
`when you paste the data. Other applications may respond differently to Excel
`data. If you plan to do a lot of copying and pasting, I suggest that you experiment
`until you understand how the two applications handle each other's data.
`
`is static. In other words,
`technique
`that this copy-and-paste
`You should understand
`the information
`that you copy from the source application
`no link exists between
`If you're copy(cid:173)
`and the information
`that you paste into the destination
`application.
`ing from Excel to a word processing document,
`for example,
`the word p1·ocessing
`document will not reflect any subsequent
`changes
`that you make in your Excel
`worksheet or charts. Consequently, you have to repeat
`the copy-and-paste
`proce(cid:173)
`dure to update
`the destination
`document with the source document
`changes. The
`next topic presents a way to get around
`this limitation.
`
`emnosUSA0017326
`
`CiM Ex. 1054 Page 4
`
`

`
`Linking Data
`
`If you want to share data that may change,
`procedure
`the static copy-and-paste
`described
`in the preceding
`section
`isn't your best choice. Instead, create a dynamic
`link between
`the data that you copy from one Windows application
`to another.
`In
`this way, if you change
`the data in the source dot:ument, you don't also need to
`make the changes
`in the destination
`document,
`because
`the link automatically
`updates
`the destination
`document.
`
`If you generate proposals by using a
`When would you want to use this technique?
`information
`that you
`for example, you may need to refer to pricing
`word processor,
`store
`in an Excel worksheet.
`If you set up a link between your word processing
`and the t,'{cel worksheet, you can be sure that your proposals
`always
`document
`the latest prices. Not all Windows applications
`support dynamic
`linking, so
`quote
`you must make sure that the application
`to which you are copying
`is capable of
`handling such a link.
`
`Creating Links
`isn't difficult, although
`to another
`Setting up a link from one Windows application
`the process varies slightly from application
`to application. The following are the
`general steps
`to take:
`
`that contains
`
`the information
`
`in the source application
`I. Activate
`the window
`that you want to copy.
`2. Select
`If Excel is the
`by using the mouse or the keyboard.
`the information
`source application,
`you can select a cell, range, or entire chart.
`3. Select Edit• Copy from the source application's menu. The source application
`copies
`the information
`to the Windows Clipboard.
`4. Activate
`[fit isn't open, you can start
`application.
`the destination
`the contents of the Clipboard.
`affecting
`5. Move to the appropriate
`6. Select the appropriate
`in the destination
`command
`The command varies, depending on the application.
`applications,
`the command
`is Edit• Paste Special.
`7. A dialog box will probably appear,
`letting you specify the type of link that you
`want to create. The following section provides more details.
`
`position
`
`in the destination
`
`it without
`
`application.
`
`to paste a link.
`application
`In Microsoft Office
`
`More About Links
`Keep in mind the following
`information when you're using links between
`applications:
`
`two
`
`emnosUSA0017327
`
`CiM Ex. 1054 Page 5
`
`

`
`you can link from
`linking. Furthermore,
`support
`• Not all Windows applications
`but not to some programs. When in doubt, consult
`the documentation
`for the
`application with which you're dealing.
`
`• When you save an Excel file that has a link, you save the most recent values
`with the document. When you reopen
`this document, E.'i:cel asks whether you
`want to update
`the links.
`• Links can be broken rather easily. H you move the source document
`to another
`directory or save it under a different name, for example, the destination docu(cid:173)
`ment's application won't be able to update
`the link. You can usually reestablish
`if you understand
`the link manually,
`how the application manages
`the links. In
`Excel, you use the Edit• Links command, which displays
`the Links dialog box,
`in Figure 29-:l
`shown
`to break a link. After breaking a
`• You also can use the Edit• Links command
`document, but is no longer linked to
`link, the data remains
`in the destination
`the source document.
`
`If you h.'llow what you're
`in array formulas.
`links are stored
`• Jn Excel, external
`doing. you can modify a link by editing the array formula.
`
`• \,Vhen Excel is running,
`from other applications,
`to link requests
`it responds
`requests.
`unless you have disabled
`remote
`If you don't want Excel to respond
`to link-update
`requests
`from other applications,
`choose Tools• Options,
`select
`the General
`tab, and then place a check
`in the Ignore other applica(cid:173)
`tions check box.
`
`Figure 29-3: The Links dialog box lets you work with links to
`other applications.
`
`emnosUSA0017328
`
`CiM Ex. 1054 Page 6
`
`

`
`Copying Excel Data to Word
`
`and a
`is a spreadsheet
`One of the most frequently used software combinations
`word processor. This section discusses
`the types of links that you can create by
`using Microsoft Word.
`
`in this section also applies to other word processors, such as
`Most information
`Corel's WordPerfect for Windows and Lotus Word Pro. The exact techniques vary,
`however. I use Word in the examples because readers who acquired Excel as part
`of the Microsoft Office have Word installed on their systems. If you don't have a
`word processor installed on your system, you can use the WordPad application
`that comes with Windows. The manner in which WordPad handles links is very
`similar to that for Word.
`
`the Paste Special dialog box from Microsoft Word after a range of
`Figure 29-4 shows
`data has been copied from E..xcel to the Clipboard. The result that you get depends
`on whether you select the Paste or the Paste link option, and on your choice of the
`If you select the Paste link option, you can choose
`type of item to paste.
`to have the
`information pasted as an icon. If you do so, you can double-click
`this icon to
`activate
`the source worksheet.
`
`Figure 29-4: The Paste Special dialog box is where you
`specify the type of link to create.
`
`Pasting Without a Link
`if you're preparing a
`Often, you don't need a link when you copy data. For example,
`report
`in your word processor
`and you simply want to in dude a range of data from
`an Excel worksheet, you probably don't need to create a link.
`
`Table 29-1 describes
`the various paste choices when you
`the effect of choosing
`option that doesn't create a link to the source data.
`select the Paste option-the
`
`emnosUSA0017329
`
`CiM Ex. 1054 Page 7
`
`

`
`Paste Type
`
`Result
`
`Formatted Text
`(RTF)
`
`A Word table that is formatted as the original Excel range. No link to
`the source exists. This produces the same result as using Edit• Paste.
`
`Picture
`
`A picture object that retains the formatting from Excel. No link to the
`source exists. This usually produces better results than the Bitmap
`the object after you paste it enables you to edit
`option. Double-clicking
`the picture.
`
`HTML Format
`
`A table that is formatted as the original Excel range. No link to the
`source exists. Use this format when you expect to publish the docu(cid:173)
`ment as a Web page.
`
`emnosUSA0017330
`
`CiM Ex. 1054 Page 8
`
`

`
`Figure 29--5 shows how a copied range from Excel appears
`paste special formats.
`
`in Word, using each of the
`
`Figure 29-5: Data that is copied from Excel and pasted using various formats.
`
`The pasted data loohs the same regardless of whethet·
`is selected.
`
`the Paste or Paste link option
`
`text.
`to w·ord as formatted
`Some Excel formatting does not transfer when pasted
`for table cells (but you can
`For example, Word doesn't
`support vertical alignment
`use Word's paragraph
`formatting
`commands
`to apply vertical alignment).
`
`Pasting with a Link
`lf you think the data that you're copying will change, you may want to paste a link If
`you paste the data by using the Paste link option in the Paste Special dialog box, you
`can make changes
`to the sow·ce document,
`and the changes appear
`in the destina(cid:173)
`tion application
`(a few seconds of delay may occur). You can test these changes by
`displaying both applications onscreen. making changes
`to the source document,
`and
`in the destination document.
`watching for them to appear
`
`the various paste choices
`the effect of choosing
`Table 29-2 describes
`Paste Special dialog box when the Paste
`link option
`is selected.
`
`in \}\ford's
`
`emnosUSA0017331
`
`CiM Ex. 1054 Page 9
`
`

`
`Paste Type
`
`Result
`
`Formatted Text
`(RTF)
`
`A Word table that is formatted as the original Excel range. Changes in
`the source are reflected automatically.
`
`Picture
`
`A picture object that retains the formatting from Excel. Changes in the
`source are reflected automatically. This usually produces better results
`than the Bitmap option. Double-dick
`the object after pasting it to edit
`the source data in Excel.
`
`HTML Format
`
`A table that is formatted as the original Excel range. Use this format
`when you expect to publish the document as a Web page.
`
`Embedding Objects
`
`Using Object Linkirig and Embedding (OLE), you can also embed an object
`to share
`information between Windows applications. This technique
`enables you to insert
`an object from another program and use that program's
`editing tools to manipulate
`it. The OLE objects can be items such as those
`in the following
`list:
`
`• Text docu1nents
`
`from other products,
`
`such as word processors
`
`from other products
`• Drawings or pictures
`from special OLE server applications,
`
`• Information
`
`such as Microsoft Equation
`
`• Sound files
`• Video or animation
`
`files
`
`Most of the major Windows applications
`your document
`in either of two ways:
`
`support OLE. You can embed an object into
`
`emnosUSA0017332
`
`CiM Ex. 1054 Page 10
`
`

`
`(if it's available).
`• Choose Edit• Paste Special, and select the "object" choice
`If you do this, select
`the Paste option rather
`than the Paste link option.
`
`• Select Insert• Object.
`
`as those
`Some applications-such
`by dragging
`it from one application
`
`in Microsoft Office-can
`to another.
`
`also embed an object
`
`The following sections discuss
`Excel and Word.
`
`these two methods and provide a few examples using
`
`Embedding an Excel Range in a Word Document
`This example embeds
`the Excel range shown
`in Figure 29-6 in a Word document.
`
`Figure 29-6: This range will be embedded
`Word document.
`
`in a
`
`(or
`To start, select Al :D 15 and copy the range to the Clipboard. Then, activate
`start) Word, open the document
`in which you want to embed
`the range, and then
`move the insertion point to the location
`in the document where you want the
`table to appear. Choose Word's Edit• Paste Special command. Select the Paste
`the Microsoft Excel Worksheet Object format
`(not Paste link), and choose
`option
`(see Figure 29-7). Click OK, and the range appears
`in the Word document.
`
`is not a standard Word table. For example, you can't select or
`The pasted object
`format
`individual cells in the table. Furthermore,
`it's not linked to the Excel source
`range.
`If you change a value in the Excel worksheet,
`the change does not appear
`in
`the embedded object in the Word document.
`
`emnosUSA0017333
`
`CiM Ex. 1054 Page 11
`
`

`
`Figure 29-7: This operation embeds an Excel object in
`a Word document.
`
`the object, however, you notice something unusual: Word's
`If you double-click
`menus and toolbars change
`to those used by Excel. In addition,
`the embedded
`object appears with Excel's farniliar row and column borders.
`In other words, you
`can edit this object
`in place by using Excel's commands. Figure 29-8 shows how
`this looks. To return
`to Word, just click anywhere
`in the Word document.
`
`Figure 29-8: Double-dicking the embedded Excel object enables you to edit it in
`place. Note that Word now displays Excel's menus and toolbars.
`
`emnosUSA0017334
`
`CiM Ex. 1054 Page 12
`
`

`
`that no link is involved here. If you make changes
`to the embedded
`Remember
`object
`in Word, these changes do not appear
`in the original Excel worksheeL The
`embedded object
`is completely
`independent
`from the original source.
`
`to all of Excel's features while you are still in
`Using this technique, you have access
`to focus on their documents
`-
`Word. Microsoft's ultimate goal is to enable users
`not on the application
`that produces
`the document.
`
`You can accomplish the embedding previously described by selecting the range in
`Excel and then dragging it to your Word document
`In fact, you can use the
`Windows desktop as an intermediary storage location. For example, you can drag
`a range from Excel to the desktop and create a scrap. Then, you can drag this scrap
`into your Word document. The result is an embedded Excel object.
`
`Creating a New Excel Object in Word
`into a
`The preceding example embeds a range from an existing Excel worksheet
`how to create a new (empty) E.xcel
`Word document. This section demonstrates
`in Word. This may be useful if you're creating a report and need to insert a
`object
`that doesn't exist in a worksheet. You could insert a normal Word
`table of values
`table, but you can take advantage of Excel's formulas and functions
`to make this
`task much easier.
`
`Insert• Object in Word.
`choose
`in a Word document,
`To create a new Excel object
`in Figure 29-9. The Create New
`Word responds with the Object dialog box, shown
`tab lists the types of objects
`that you can create (the contents of the list depends
`on the applications
`that you have installed on your system). Choose
`the Microsoft
`E..xcel Worksheet option and click OK
`
`Figure 29-9: Word's Object dialog box enables you
`to create a new object.
`
`emnosUSA0017335
`
`CiM Ex. 1054 Page 13
`
`

`
`it for
`Word inserts an empty Excel worksheet object into the document and activates
`you, as shown in Figure 29-10. You have full access to Excel cmnrnands, so you can
`enter whatever you want into the worksheet object. After you finish, click anywhere
`in the Word document. You can, of course, double-dick
`this object at any time to
`make changes or additions.
`
`Figure 29-10: Word created an empty Excel worksheet object.
`
`the size of the object while it's activated by dragging any of the
`You can change
`sizing handles
`that appear on the borders of the object. You also can crop the
`object, so that when it isn't activated,
`the object displays only cells that contain
`in Word, select
`information. To crop an object
`the object so that you can see sizing
`handles. Then, display Word's Picture
`toolbar
`(right-dick
`any toolbar button and
`choose Picture). Click the Cropping
`tool (it looks like a pair of plus sittns) and then
`drag any sizing handle on the object.
`
`Even if you crop an Excel worksheet object in Word, when you double-click the
`object, you have access to all rows and columns in Excel. Cropping changes only
`the displayed area of the object
`
`emnosUSA0017336
`
`CiM Ex. 1054 Page 14
`
`

`
`Embedding an Existing Workbook in Word
`Yet another option
`is to embed an existing workbook
`into a Word document. Use
`In the Object dialog box, dick the tab labeled
`Word's Insert• Object command.
`Create from File (see Figure 29-ll). Click the Browse button and locate the Excel
`workbook
`that you want to embed.
`
`Figure 29-11: This dialog box enables you to locate
`a file to embed in the active document.
`
`When you use this technique, you embed a copy of the selected workbook
`in the
`Word document. You can either use it as is or double-dick
`it to make changes. Note
`that any changes
`that you make to this copy of the document
`are not reflected
`in
`the original workbook.
`
`Embedding Objects in an Excel Worksheet
`The preceding examples
`involve embedding Excel objects
`in a Word document. The
`same procedures
`can be used to embed other objects
`into an Excel worksheet.
`
`if you have an Excel workbook
`For example.
`tory text, you have several choices:
`
`that requires a great amount of explana(cid:173)
`
`the text into cells. This is tedious and doesn't allow much
`
`• You can enter
`formatting.
`• You can use a text box. This is a good alternative,
`formatting
`features.
`• You can embed a Word document
`in your worksheet. This gives you full access
`to all of Word's formatting
`features.
`
`but it doesn't offer many
`
`emnosUSA0017337
`
`CiM Ex. 1054 Page 15
`
`

`
`choose Excel's
`into an Excel worksheet,
`To embed an empty Word document
`Insert• Object command.
`In the Object dialog box, click the Create New tab and
`select Microsoft Word Document
`from the Object type list.
`
`text.
`and ready for you to enter
`activated
`is a blank Word document,
`The result
`replace Excel's menus and toolbars. You
`Notice that Word's menus and toolbars
`as you like, and the words wrap accordingly. Figure 29-12
`can resize the document
`shows an example of a Word document
`embedded
`in an Excel worksheet.
`
`Figure 29-12: A Word document that is embedded in an Excel worksheet
`
`including audio clips, video clips, MIDI
`You can embed many other types of objects,
`sequences,
`and even an entire Microsoft PowerPoint presentation.
`
`the actual video clip file in the
`store
`When you embed a video clip, Excel doesn't
`to the original file. If, for some
`E.xcel document. Rather, Excel stores a pointer
`reason, you want to embed
`the complete video clip file, you can use the Object
`Packager application. Be aware, however,
`that video clip files are typically quite
`large, and opening and saving the workbook will take a lot of time.
`
`applications
`Microsoft Office includes a few additional
`These all can be embedded
`in Excel documents:
`
`that you may find useful.
`
`in Figure 29-l].
`• Microsoft Equation: Create equations,
`such as the one shown
`• Mic1·osoft WordArt: Modify text in some interesting ways, as in Figure 29-14.
`• MS Organization Chart: Create attractive organizational
`charts, as shown
`in
`Figure 29-15.
`
`emnosUSA0017338
`
`CiM Ex. 1054 Page 16
`
`

`
`Figure 29-13: This object was created with Microsoft Equation.
`
`Figure 29-14: An example of Microsoft WordArt.
`
`Figure 29-15: An example of an embedded organizational chart.
`
`emnosUSA0017339
`
`CiM Ex. 1054 Page 17
`
`

`
`Using Office Binders
`
`If you have Microsoft Office installed, you may take advantage of its binder feature.
`A binder is a container
`that can hold documents
`from different applications: Excel,
`Word, and PowerPoint.
`
`You may find that a binder is useful when you are working on a project that involves
`from different applications. For example, you may be preparing a sales
`documents
`that uses charts and tables from Excel, reports and memos from Word,
`presentation
`and slides prepared with Power Point. You can store all the information
`in a single file.
`And, when you print the entire binder, pages are numbered sequentially.
`
`To use a binder, start the Binder application, and an empty hinder appears. You then
`can add existing documents
`to the binder or create new documents
`in the binder.
`Figure 29-16 shows a binder that contains Word, Excel, and PowerPoint documents.
`Consult the online Help for complete details on using this application.
`
`Figure 29-16: An Office binder can hold documents that are produced by
`different applications.
`
`You may need to rerun Office setup if Binder isn't installed on your computer.
`You'll find it under a category called Office Tools.
`
`emnosUSA0017340
`
`CiM Ex. 1054 Page 18
`
`

`
`Summary
`
`that enable you to use data from other applica(cid:173)
`techniques
`This chapter describes
`include standard copy-and-paste
`options using the Windows
`tions. These techniques
`and Office Clipboards, dynamic linking between applications,
`and embedding objects.
`\vith a note on Microsoft Office's binder application, which
`This chapter con dudes
`enables you to work with documents
`that are produced by different applications.
`
`emnosUSA0017341
`
`CiM Ex. 1054 Page 19
`
`

`
`CiM Ex. 1054 Page 20
`
`emnosUSA0017342
`
`CiM Ex. 1054 Page 20
`
`

`
`Excel and the
`Internet
`
`Chances are, you're already
`
`in
`in the Internet
`involved
`seems to have taken the
`some way. This technology
`the
`world by storm. The World Wide Web (Vv\A/W) is prnbably
`most exciting thing happening
`these days in the world of com(cid:173)
`puting. In fact, the Web reaches well beyond
`the computer
`community and is a pervasive
`force in our lives. It's now quite
`common
`to see Web site addresses
`listed in TV commercials,
`in magazine ads, and even on bi1lboards.
`
`Excel(cid:173)
`in Microsoft Office 2000-including
`The applications
`have all been revamped
`to put them on a better footing with
`the Internet. This chapter provides an introduction
`to the
`Internet
`(for those who have yet to discover
`this resource) and
`that are available
`in Excel 2000.
`discusses
`the Internet features
`
`What Is the Internet?
`
`The lntemet,
`that are
`is a collection of computers
`in a nutshell,
`located all around
`the world. These computers
`are all con(cid:173)
`nected
`to each other, and they can pass information back and
`forth. Strange as it may seem, the Internet
`is essentially a non(cid:173)
`commercial
`system, and no single entity "runs" the Internet.
`
`think of the Internet as a collection uf
`Most people don't
`is a resource that contains
`computers. Rather, the Inten1et
`that infor(cid:173)
`information
`-
`and you use a computer
`to access
`mation. The computers
`that are connected
`to the Internet
`simply do the grunt work of passing
`the information
`from
`point A (which could be a computer
`in Hamburg, Germany)
`to point B (which could be the computer
`in your cubicle).
`
`emnosUSA0017343
`
`CiM Ex. 1054 Page 21
`
`

`
`CiM Ex. 1054 Page 22
`
`emnosUSA0017344
`
`CiM Ex. 1054 Page 22
`
`

`
`What's Available on the Internet?
`is simply
`The amount and variety of information
`that's available on the Internet
`mind-boggling. You can think of virtually any topic in the world, and an excellent
`chance exists that at least some information on that topic can be found on the
`Internet. Not unexpectedly,
`computer-related
`information
`is especially abundant.
`
`So, where do you get this information? The following are the four primary sources
`for information on the Internet:
`
`• Web sites: The Web has rapidly become
`the most populai· part of the Internet.
`Hundreds of thousands
`of Web sites are available
`that you can access with
`your Web browser software. For example, my own Web site (The Spreadsheet
`Page) has the following URL: r1t t p: / l>t1w,fi. J -wa l k. com/ s s /
`• FfP sites: These are computers
`that have files available for download. You
`can download
`these files by using Web browser software or other software
`that is designed specifically
`to download
`files from FTP sites. The following is
`the URL for Microsoft's FTP site: ftp:/
`/ftp.
`rni crosoft.
`corn
`• Newsgroups: These are essentially
`electronic bulletin boards. People post
`messages or questions,
`and others
`respond
`to the messages or answer
`their
`for just about any topic
`questions. Thousands
`of newsgroups
`are available
`that you can think of. You need special "news reader" software
`to read or
`post messages
`to a newsgroup
`(although most Web browsers
`also include
`this feature). For more information,
`see the sidebar "Excel Newsgroups."
`• Mailing lists: If you have access to Internet e-mail, you can subscribe
`to any of
`several
`thousand mailing lists that address a broad array of topics. Subscribers
`send e-mail to the mailing list, and then every other subscriber
`to the list
`receives
`that e-mail. There are two popular mailing lists that deal with Excel
`(refer to the "Excel Mailing Lists" sidebar
`for details).
`
`How Do You Get on the Internet?
`You can access
`the Internet
`in a number of ways. He1·e are some of the most com(cid:173)
`mon ways:
`
`• Through your company: Your company may already be connected
`Internet.
`If so, just fire up your Web browser and you're
`there!
`• Through an lnte1·net Service Provider (ISP): Most communities
`have several
`companies
`that can set up an Internet account
`for you. For a small monthly
`fee (1.1stially around $20) you can have unlimited
`(or almost unlimited) access
`required on your part is a computer, a modem, and a
`to the Internet. All that's
`phone Hue.
`• 111rougb au online service:
`If you subscribe
`services, you can access
`the Internet
`through
`CompuServe, Microsoft Network, or Prodigy.
`
`to any of the following online
`that service: America Online,
`
`to the
`
`emnosUSA0017345
`
`CiM Ex. 1054 Page 23
`
`

`
`. * groups, you can
`excel
`public.
`If your ISP doesn't carry the mi crosoft.
`access them directly from Microsoft's news server. You need to configure your
`newsreader software or Web browser to access Microsoft's news server, which is
`rnsnews.rnicrosoft.com.
`
`emnosUSA0017346
`
`CiM Ex. 1054 Page 24
`
`

`
`Where to Find Out More About the Internet
`Internet.
`The best place to find out more about the Internet
`is -you
`guessed
`it-the
`A good starting place is the IDG Books Web site. To access
`it, open the following URL
`in your Web browser: http:/
`/vJVt;J. -i dgboo ks. corn.
`
`Internet books for users of all levels, and
`IDG Books Worldwide publishes numerous
`you can find these Hsted and described
`on the IDG Web site.
`
`Excel's Internet Tools
`
`The remainder of this chapter describes
`Excel 2000. These features
`include:
`
`the Internet-related
`
`features available
`
`in
`
`• Using HTML as a native file format (instead of the XLS file format).
`
`• Saving a worksheet
`
`as an interactive Web page.
`
`• Using Excel's Web toolbar.
`
`• Inserting hyperlinks
`
`into a worksheet.
`
`emnosUSA0017347
`
`CiM Ex. 1054 Page 25
`
`

`
`• Creating and using Web queries.
`
`• Scheduling and conducting online meetings.
`
`• Creating discussion groups.
`
`l
`
`Using HTML As a Native File Format
`Excel's standard file format is, of course, an XLS file. Excel 2000, however, has the
`ability to use HTML as a native file format. This means that you can create a work(cid:173)
`book and save it in HTML format. Then, you can reopen the file without
`losing any
`information.
`In other words, your Excel-specific information
`(such as formulas,
`charts, pivot tables, and macros) survive the translation to HTML.
`
`in Excel 97, you probably know that the
`If you've used the "save as HTML" feature
`but if you reopen
`the file in
`HTML file that's created works fine in Web brnwsers-
`features) will be gone.
`Excel, all of your formulas
`(as well as other Excel-specific
`With Excel 2000, this problem no longer e.xists, because
`the HTML file contains
`lots
`of proprietary
`tags that are ignored by browsers but that enable