Office XP Tips

Office XP Tips

Have corrupted Office files, Word, Excel or Access? OfficeFIX can help you recover your files, so you don't have to start over, OfficeFIX is a Software Suite that recovers damaged Ms Excel (all versions), Ms Access (95, 97, and 2000), and Ms Word documents (all versions including Word for Macintosh). When an Office file shows an error while trying to open it chances are it is corrupt. OfficeFIX extracts the information from the file and creates a new one that is trouble free. Restore your files easily in only 15 minutes. Check it out today!

FREE Computer and Internet Technical problem solving, plus ...
Free Tutorials, Free eBooks, Free Courses, Free Guestbooks, Free Autoresponders, Free help and advice, Free Newsletter, Free Affiliate program and FREE MEMBERSHIP. Wow! Did I mention it was Free? Newbies and Oldbies alike are buzzing about the NEW Newbie Club. It's the most exciting Newbie Site ever to hit the Web. Join now - it's FREE! TheNewbieClubTake firm fontrol of your PC and totally transform your internet experience with the most unique and entertaining PC learning course on the web, no technical jargon, designed from the ground up specifically for newbies, my mom loves it. :) Hey I'm a Newbie, not a Dummy, just tell me how!

Access Your PC from Anywhere - Free Download
You’re invited to try a new remote-access telework solution that CNET says could “change your life.” Gain the freedom to work from anywhere using GoToMyPC. It’s the fast, easy and secure way to access and control your PC via any Web browser — anytime, anywhere. GoToMyPC is perfect for teleworkers, travelers and after-hours access. Installs in 2 minutes – Get Your Free Download Now!


Facing 'new world of work,' Microsoft locks up Office

May 24 2005-For most of their 20 years, Word and Excel documents have had free rein within corporate walls.
In the early days, workers used an array of floppy disks to shuttle documents created with the programs from department to department. E-mail let the files become even more far-flung, easily moving them among branch offices around the globe.
But with the advent of federal record-keeping regulations such as the Sarbanes-Oxley Act and the Health Insurance Portability and Accountability Act, which impose strict rules on how companies manage and archive information, those freewheeling days are nearly at an end.
Go here for more.

OFFXP: Error 1328 When You Apply Office XP Service Pack 1

When you apply Microsoft Office XP Service Pack 1 (SP-1), you may receive an error message similar to one of the following:
Error 1328. Error applying patch to file C:\Program Files\Microsoft Office\Office10\Msaccess.exe. It has probably been updated by other means, and can no longer be modified by this patch. For more information contact your patch vendor.
NOTE: The Office program that appears in the error message may be different from Msaccess.exe.
-or-
The expected version of the product was not found on your system.
Click here for more from Microsoft.

Office XP Update: Service Pack 2 (SP2)

Office XP Update: Service Pack 2 (SP2) provides the latest updates to Microsoft Office XP. Office XP SP2 contains significant security enhancements, as well as stability and performance improvements. Some of the fixes included with SP2 have been previously released as separate updates. This service pack combines them into one update. Microsoft recommends that users install the Office XP SP2 update using the Office Product Updates site. This site will detect your Office installation, prompt you to install exactly what you need to be fully updated, and can minimize the time required to download this update.
Click here for more from Microsoft.

Microsoft Issues Second Office XP Service Pack

Yesterday, Microsoft released Microsoft Office XP Service Pack 2 (SP2), a collection of bug fixes for the company's best-selling office productivity suite. Office XP SP2 is available as a Web download, on CD-ROM, or as a special version for corporate rollouts. SP2 fixes affect the Office XP Web Components and all major Office XP applications, including Microsoft Word 2002, Excel 2002, Outlook 2002, PowerPoint 2002, Access 2002, FrontPage 2002, and Publisher 2002.
"The SP2 update contains significant security enhancements as well as stability and performance improvements," Microsoft states on its Web site. "Some of the fixes included with SP2 have been previously released as separate updates. This service pack combines them into one update."
Click here for more from wininformat.

Office XP vs. bugs, round two

Microsoft on Wednesday plans to release its second collection of bug fixes, or service pack, to Office XP, the company confirmed Tuesday. Service Pack 2, a 15MB download, is supposed to enhance Office XP's performance, security and stability, while fixing a wide range of glitches, Microsoft said. "This is a very comprehensive service pack," said Simon Marks, Office product manager. The software giant issued the first Office XP service pack in December.
Click here for more from zdnet.

"This Installation Package Cannot Be Opened" Error Message When Installing Office XP

When you try to install Office XP, you may receive an error message similar to the following:
This installation package cannot be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
This behavior may occur when there is a problem with the installation of Windows Installer.
Click here for more.

Setup Stops Running and Reports an Internal Error 2350

When you try to install Office XP, Setup may stop running, and you may receive an internal error 2350.
This issue can occur if Windows Installer is outdated.
To resolve this issue, follow these steps to update Windows Installer.
Click here for more.

ACC2002: Defragment and Compact Database to Improve Performance (Q288631)

Note: This articles talks about Microsoft Access 2002.
You can improve the performance of Microsoft Access if you periodically defragment your hard disk and compact your database.
Because the data on a hard disk will become fragmented over time, you should periodically run a disk-defragmentation utility (or defragmenter). If you make changes often within a database, portions of the database may also become fragmented. Therefore, you should also periodically run the Compact Database utility within Microsoft Access.
Click here for more.

OFFXP: Error 1328 When You Apply Office XP Service Pack 1 (Q315152)

This article describes an error that occurs in a home environment where Microsoft Office XP was installed from a CD-ROM. This article does not apply to you if you are in a corporate environment where you installed Office from a network server or a CD-ROM that was provided by your system administrator.
When you apply Microsoft Office XP Service Pack 1 (SP-1), you may receive an error message similar to one of the following:
Error 1328. Error applying patch to file C:\Program Files\Microsoft Office\Office10\Msaccess.exe. It has probably been updated by other means, and can no longer be modified by this patch. For more information contact your patch vendor.
Click here for more.

OFFXP: What Is CTFMON and What Does It Do? (Q282599)

When you run a Microsoft Office XP program, the file Ctfmon.exe (Ctfmon) runs in the background, even after you quit all Office programs.This article answers some of the frequently asked questions about the Microsoft Text Services Ctfmon.exe file, which is loaded after installing Office XP Alternative User Input features.
Unlike the Alternative User Input features, Ctfmon.exe is a system component that cannot be uninstalled. For more information about disabling Ctfmon.exe, refer to the "Can I remove the Ctfmon.exe file?" section earlier in this article. What amount of system resources is used when Ctfmon.exe is running?
Ctfmon.exe uses little of the system resources if Advanced Text Services are not running. Advanced Text Services are those input technologies (speech recognition, handwriting recognition, and Input Method Editors) that are being controlled by Ctfmon.exe via a TIP.
Click here for more.

Office .NET Revealed?

April 6 2002-Is Office NGO really the next version of Office?
A number of readers alerted me this week to a fascinating Shockwave animation that purports to demonstrate some of the online/subscription features of the next version of Microsoft Office, which will be called Office .NET. Code-named Office NGO ("Next Generation Office") in the animation, this Office version will include links to a number of of online services, including a secure My Office Web site; a consolidated email account with Web-based Inbox; Office .NET Notifications; online scheduling with a sharable calendar; Meeting Workspaces for viewing agendas, pending tasks, and related documents, SharePoint Team Services-based Team Workspace for sharing information with team members; and a set of online content such as templates, online training, communities, and the like.
So is it real? Is Office NGO really a sneak-peak at Office .NET? It's hard to say, and though some UI inconsistencies have me thinking that this is an April Fools prank, I will say this: If it is fake, it's the most elaborate fake I've ever seen. Let's take a look.
Click here for more.

OFFXP: Error 1328 When You Apply Office XP Service Pack 1 to a Workstation (Q315063)

IMPORTANT : This article describes an error that occurs in a corporate environment and is intended for system administrators in that environment.
This article does not apply to you if you meet any of the following qualifications:
You installed your version of Office XP from a Retail CD-ROM (showing an Office Hologram).
You attempted to update your version of Office XP to Office XP Service Pack 1 (SP-1) by using the Product Updates Web site (http://office.microsoft.com/productupdates).
If you installed your version of Office XP from a network server or a CD-ROM that was provided by your system administrator, please contact your system administrator about this issue and reference this article number. When you apply Office XP Service Pack 1 (SP-1), you may receive an error message similar to the following:
Error 1328. Error applying patch to file C:\program files\Microsoft Office\Winword.exe. It has probably been updated by other means, and can no longer be modified by this patch. For more information contact your patch vendor.
Click here for the article from Microsoft.

OFFXP: Error 1328 When You Apply Office XP Service Pack 1 (Q315152)

IMPORTANT : This article describes an error that occurs in a home environment where Microsoft Office XP was installed from a CD-ROM. This article does not apply to you if you are in a corporate environment where you installed Office from a network server or a CD-ROM that was provided by your system administrator.
When you apply Microsoft Office XP Service Pack 1 (SP-1), you may receive an error message similar to one of the following:
Error 1328. Error applying patch to file C:\Program Files\Microsoft Office\Office10\Msaccess.exe. It has probably been updated by other means, and can no longer be modified by this patch. For more information contact your patch vendor.
Click here for the article from Microsoft.

OFFXP: Overview of the Office XP Service Pack 1 (Q307843)

Microsoft Office XP Service Pack 1 (SP-1) provides the latest updates to Office XP. Office XP SP-1 contains significant security enhancements, as well as improvements in stability and performance. Some of the fixes that are included with Office XP SP-1 were released earlier as separate updates. This service pack combines the updates into one integrated package and includes a number of other changes that are designed to improve the reliability and performance of your Office XP programs.
This article describes how to download and install the Office XP SP-1.
Click here for the article from Microsoft.

Office XP security

Learn how the new security technologies in Microsoft Office XP put you in control of your Office environment. Get information on today's top desktop security threats, and learn about security practices that work in conjunction with Office features to improve your overall security posture. Get the 411 KB Word 2000 Document on Office XP security, or goto the webpage here.

Track Your Progress with Excel 2002 and Word 2002

Do you need a way to keep track of your progress on health, fitness, or well-being goals? Microsoft Office XP is the ideal software to help you achieve your health and fitness goals. For example, you can use Microsoft Word 2002 or Microsoft Excel 2002 to create logs that you can use to track your goals, either online or in printed form.
When planning to create a log, the first question you might ask yourself is, "Which application should I use?" The answer depends on how much information you want to track and how long you want to track it. Essentially, the more detailed your log is, the more you might want to use a data-driven program such as Excel instead of Word.
By using the powerful Sort, Filter, or Graphing features in Excel 2002, you can easily view larger amounts of data in different ways to track your progress. On the other hand, the Table feature in Word works very well for creating logs for daily use.
For step-by-step instructions on how to use these features, see Help in your Excel 2002 and Word 2002 programs.

Working with Multiple Undo and Redo in Access 2002

In Microsoft Access, the Undo and Redo options allow you to undo or redo one or several changes at once. However, the range of operations that you can undo or redo will always begin with the most recent operation and you may only undo or redo operations in the order in which they took place. For example, you cannot undo just the second, fourth, and eighth changes you have made to your table design.

Microsoft Word is the world's favorite word processing program If you don't have it on your computer, chances are you eventually will. And yet, like most software, its huge range of features and creative benefits remain hidden behind a wall of difficult and boring help files. But not any more! MS Word MAGIC! is the latest stunning ebooklet from The Newbie Club, and it's so full of screen captures, pictures, and Newbie-Speak exercises, you'll wonder how on earth they keep the price down to only $9.95! Read about it at TheNewbieClub. It's brilliant!
AD

Create a Family Newsletter in Word 2002

Sharing information and keeping in touch has never been easier with the advent of the Internet and Microsoft Office software such as Microsoft Word 2002. For example, you can work together with your family to build a newsletter simply by sending or routing a Word document in e-mail to gather the information you need. With all information in hand, you can then send your newsletter to family members through regular mail or e-mail, or if you have a Web site, host it online.

Deciding what to write about

When writing a family newsletter, first consider what information sections to include. Feature pieces are often driven by recent family events such as holidays, births, and graduations. Regular sections might include an upcoming events calendar, Web site links, a humorous piece, or a message from Mom.
Similar to a newspaper or magazine, and depending on how often you publish, you might have a weekly or monthly feature section followed by regular sections that provide updates on the lives of your family members. Typically one family member acts as lead organizer, ensuring all information is collected and included in the newsletter, and then sends it out.

Organizing your information

With Word 2002 you can organize your newsletter using columns, linked text boxes, or both. You can also insert a picture and format your text to wrap around it. If you choose to divide your newsletter into columns, text will snake across each page before continuing on to the next page. If you use linked text boxes, you can arrange information so that it is parallel or side-by-side down each page. To showcase a feature story on the first page but provide the remaining text on another page, you need to use linked text boxes regardless of how many pages are in your newsletter.
For step-by-step instructions to complete any of these tasks, see Help in your Word 2002 program.

Create Party Invitations, Envelopes, and Labels with Word 2002

So you're having a party, you've done all the planning, and now you need to let people know about it. When you get the final guest list together, you are ready to send out the invitations. How can Microsoft Word 2002 help you from here?
With a little help from Word 2002 and the Microsoft Office Template Gallery, you can create and print your party invitations, envelopes, and return address labels. You can also optionally perform a mail merge with the guest list (from your Microsoft OutlookŪ contacts) to print out attendees' addresses quickly.

Create your invitations

You can create your own party invitations in Word by starting with a blank document and adding text, formatting, and graphics to create the look you want. Or, to get a head start, you can use the Birthday party invitation in the Template Gallery. Open the template in Word, add the information for your party, make any design changes you want, and print your card. This template was designed to create a card that you can print on standard 8.5" x 11" paper and then fold in quarters to create a 4.25" x 5.5" card. You may choose to print your invitations on colored card stock, but make sure the paper is not too heavy since you will be folding it twice.

Create and print your envelopes

Before you create your envelope, determine whether you want to print envelopes individually or all at once. If you are inviting a small number of guests, printing the envelopes one at a time is the simplest way to go. If you are inviting a large number of guests, you might want to set up the envelopes for a mail merge to address and print all the envelopes at once.

Print envelopes one at a time

You can either print each envelope directly from the Envelopes and Labels dialog box, or you can add the envelope to your party invitation document so that you can add graphics, make changes to the envelope directly from the document, and save the envelope to use again another time.

Print all the envelopes at once

If you have stored your party guests' names in your Outlook Contacts folder, you can follow these steps to select guest names and perform a mail merge from your Contacts folder. However, you can use just about any type of data source you want (such as a list of guests' names in a Word document) to complete the mail merge. For more information about data sources you can use for a mail merge, see Microsoft Word Help.
  1. Open a new document in Word.
  2. On the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard.
  3. In the Mail Merge task pane, under Select document type, select the Envelopes option and then click Next. (Remember to click Next after each of the following steps.)
  4. In step 2 in the wizard, under Select starting document, select the Change document layout option.
  5. Under Change document layout, click the Envelope options link, select the envelope size and address font options you want, and then click OK.
  6. In step 3 in the wizard, under Select recipients, click Select from Outlook contacts.
  7. Click Choose Contacts Folder.
  8. In the Select Contacts List folder dialog box, click the contact list you want, and then click OK. All of the contacts in the folder appear in the Mail Merge Recipients dialog box.
  9. Select the names you want to include, and click OK.
  10. Complete the wizard.
Note By default in the Mail Merge wizard, your return address is omitted. If you want to print your return address on the envelope, add your return address to your envelope document in step 4 or step 5 of the Mail Merge wizard.

Print your return address labels

If you want to print labels with a "party" theme, use the party return address labels template in the Office Template gallery. (This template works with Avery labels 5167, 5267, 6467, 8167, and 8667. To create return address labels from scratch on label sheets other than these, on the Tools menu, point to Letters and Mailings, point to Envelopes and Labels, and then click the Labels tab in the Envelopes and Labels dialog box.)
  1. Open the Return address labels for a party template in Word.
  2. In the first table cell, replace the boilerplate text with your name and address, being careful not to delete the graphic.
  3. Apply any formatting you want to your return address text. You can also replace or remove the graphic.
  4. When the first table cell looks the way you want all your labels to look, make sure the cursor is in this cell, point to Select on the Table menu, and then click Cell.
  5. On the Edit menu, click Copy.
  6. Press TAB twice to select the contents of the next table cell that contains label text.
  7. On the Edit menu, click Paste Cells.
  8. Repeat steps 6 and 7 until all the labels on the page have your name and address and the formatting you want. Note When you select the last cell in a row, press TAB only once to select the contents of the next table cell (the first cell in the next row).
  9. Insert the labels into your printer's manual feeder, and then click Print on the File menu.


Computer or software acting up? Need low cost Technical Help? Want FREE help to learn a program? Printer or CD Writer broken? The Newbie Club now has 90 FULL TIME trained technicians on hand to advise you - at 8 cents a day. Their new site is now bigger and better than ever with so many Free Tutorials, Courses eBooks and Expert Articles, it will make your head shake in disbelief. And Membership is TOTALLY FREE. Go see what they're offering at TheNewbieClub You just won't believe it!
AD

Using the Task Pane Feature in FrontPage 2002

The Task Panes in Microsoft FrontPage version 2002, allow you to have easy access to frequently used commands like Open Page, new Empty Web, Web Site Templates, and Add Network Place.
The Task Pane opens whenever you choose New and then Page or Web from the File menu or you can open the Task Pane in FrontPage 2002, by doing the following:
  1. On the View menu, select Task Pane. The Task Pane will appear as a window on the right side of your screen.
  2. Choose from Open a page, New, New from existing page, New from template or access Microsoft FrontPage Help.
  3. To Close the Task Pane, click the X in the upper right corner of the Task Pane.
Tip: As you use different commands such as adding the Frequently Asked Questions page template, these commands are automatically added to the New Page or Web Task Pane.

Accessing Clipboard and Search Task Panes in FrontPage 2002

Multiple Task Panes in Microsoft FrontPage version 2002, allow you to quickly switch between different task areas including adding new templates and pages to your Web, Search, and special paste features of the Office Clipboard.
To use these Task Panes in FrontPage 2002, do the following:
  1. From the View menu, select Task Pane. The Task Pane will appear as a window on the right hand side of your screen.
  2. To switch between Task Panes, click the down arrow in the upper right hand corner of the Task Pane and select another pane.
  3. To Close the Task Pane, click the X in the upper right hand corner of the Task Pane.
Tip: To quickly display the Office Clipboard Task Pane use the following keyboard shortcut: hold down the Ctrl key and press the C key twice (Ctrl+C+C). You can then switch to Search or New Page or Web.

Exchanging Data between Excel and Access with AccessLinks

If you're working in Microsoft Excel and Microsoft Access, you can use several Access features to maintain your Excel data with the AccessLinks add-in program.
If the Convert to MS Access, MS Access Report or MS Access Form commands are not available from the Data menu, you need to load the AccessLinks add-in. The AccessLinks add-in program is available from the Microsoft Excel Download Web site.

Using Access to manage Excel data

Convert an Excel list to an Access database If you have a large Excel list and you want to take advantage of the Access data management capabilities, security, or multiuser capabilities, you can convert the data from Excel to an Access database. Use this method when you want to move the data from Excel into Access and use and maintain the data in Access from then on.
Create an Access report from Excel data If you are familiar with designing Access reports and want to summarize and organize your Excel data this way, you can create an Access report from the data in your Excel list. For more information about designing and using Access reports, refer to Microsoft Access Help.
Use an Access form to enter Excel data If you want to use a customized form to enter, find, or delete data in an Excel list (a series of worksheet rows that contain related data), you can create an Access form for your list. For example, you can create an Access form that lets you type the entries for an Excel list in a different order from the order of the columns on your worksheet. Use this method if you want the specific features available in Access forms. For more information about designing and using Access forms, refer to Microsoft Access Help.

Convert Excel data to an Access database

  1. Make sure the Microsoft Excel data is in list format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list.
  2. Click the Excel list.
  3. On the Data menu, click Convert to MS Access.
  4. Click New database.
  5. Click OK, and then follow the directions in the Access Import Spreadsheet Wizard.
For more information about this wizard, see Microsoft Access Help.

Create an Access report from Excel data

  1. Make sure the Microsoft Excel data is in list format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list.
  2. Click the Excel list.
  3. On the Data menu, click MS Access Report.
  4. If prompted, save the workbook by clicking Save on the File menu, and then click MS Access Report again.
  5. In Microsoft Access, do one of the following: To create the report in a new Access database, click New database. To create the report in an existing Access database, click Existing database, and then type the path to the database in the box under Existing database. To look for the database on your hard disk or network, click Browse.
  6. Click OK, and then follow the instructions in the Access Report Wizard. Do not change the names that the wizard proposes for the table and report.
For more information about this wizard and Access reports, see Microsoft Access Help.

View or update an existing report

To view the report again in Microsoft Excel, click the View MS Access Report button on the worksheet to the right of your list. If you've added data or changed the data in the list since you created or viewed the report, the report is updated with the changes.
For more information about the report, see Microsoft Access Help.

Enter data into Excel with an Access form

Create a new Microsoft Access form
  1. Make sure the existing data on the Microsoft Excel worksheet is in list format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list.
  2. Click a cell in the list.
  3. On the Data menu, click MS Access Form. If prompted, save the workbook by clicking Save on the File menu. Then click MS Access Form again.
  4. In Microsoft Access, do one of the following: To create the form in a new Access database, click New database. To create the form in an existing Access database, click Existing database, and then type the path to the database in the box under Existing database. To look for the database on your system or network, click Browse.
  5. Click OK, and then follow the instructions in the Access Form Wizard. Do not change the names that the wizard supplies for the table and form. For more information about the wizard, see Microsoft Access Help.
  6. When you complete the steps in the wizard, enter data using the form that appears. Click the new record button at the bottom of the form to start entering new data. Each time you enter a new record, Access updates the Excel list. For more information about using an Access form to enter data see Microsoft Access Help.
  7. When you're finished entering data close the form.
Reuse an existing Access form To use the form again in Microsoft Excel, click the View MS Access Form button on the worksheet to the right of the list.
If Microsoft Excel can't find the form, the Create Microsoft Access Form dialog box appears. To look for the Access .mdb file that contains the form, click Browse.

Saving a Text File to a Web Server in Excel 2002

When working with text files in Microsoft Excel that are located on a Web server, you cannot use the Save command to save a text file to the Web server when that file was opened from the Web server. There is, however, a simple solution to this problem. This article describes how to save a text file to a Web server, how to open a text file from a Web server, and how to save a text file that was opened from a Web server back to that Web server.

Saving a text file to a Web server

  1. Create a new workbook or open a previously saved workbook.
  2. Click Save (File menu) for a new workbook, or Save as (File menu) for a previously saved workbook.
  3. In the File name box, type the Web server address and the file name for the workbook.
  4. Under Save as type, click Text (Tab delimited).
  5. Click Save.
  6. If you have created a new workbook with multiple sheets, click OK in the first dialog box that asks you to verify that you want to save only the active sheet in Text (Tab delimited) format. Click Yes in the next dialog box that asks you if you want to keep your file in this format.
  7. If you have opened a previously saved workbook or created a new workbook containing only one worksheet, click Yes in the dialog box that asks you if you want to keep your file in this format.
Note When you close a file saved in this format, Excel prompts you again to save changes made to the file and to verify that the file should be saved in this format.

Opening a text file from a Web server

  1. Click Open on the File menu.
  2. In the File name box, type the Web server address and the file name for the workbook.
  3. Click Open.
  4. Follow the instructions in the Text Import Wizard.

Saving a text file opened from a Web server back to that Web server

Clicking Save after making changes to the file opened from the Web server brings up a message that states "The file could not be accessed." In order to save the text file back to the Web server, do the following:
  1. Click Save as on the File menu.
  2. In the File name box, type the Web server address and the file name for the workbook.
  3. Click Save.
Note Clicking Save again after getting the message displays the Save as dialog box, and you can proceed from step 2 above.

Inserting References into Online Discussions in Excel 2002

Why can't you create a discussion at a specific location in Excel?

When you create discussions in Microsoft Excel 2002, you cannot create a discussion at a specific location within the document because Excel allows for hundreds of worksheets in a workbook, and several thousand cells for each worksheet. Because of this complex design, Web Discussions cannot apply to each worksheet or cell in a given workbook.

What's the solution?

When you post your discussion, put the worksheet and/or cell reference in the subject line of the discussion. That way others who use your document can easily reference the worksheet or cell you're describing in the text.

Easily insert the latest stock quote into a worksheet with Excel 2002

In previous versions of Excel, obtaining an up-to-date stock quote required the use of a Web query. But in Office XP, you can now get a stock quote inserted directly into your worksheet and have it updated on a regular basis with the help of a Smart Tag. To use this feature you must be connected to the Internet.
To add a stock quote to your worksheet, enter the stock ticker symbol for the company in a cell, such as MSFT for Microsoft. Note that you must type the symbol in all capital letters. Then, point to the triangle in the lower-right corner of that cell to display the Smart Tag icon and click on it. From the Financial Symbol menu, select Insert Refreshable Stock Price. Then select where you want the stock price to be displayed. You can choose either On A New Sheet or Starting At Cell, which puts the stock price in the cell you specify. To have the price update automatically on a regular basis, right-click in the worksheet and choose Data Range Properties from the shortcut menu. Then, set the Refresh Every n Minutes setting to how often you want Excel to update the stock quote and click OK.