Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: Microsoft Excel 2002 Standard Edition

Article ID Article Title Hidden
240794 How to Determine the Path for an Office Application
241072 Dates and times displayed as serial numbers when viewing formulas in Excel
241861 BUG: ATL Control in Office Document Prevents Another Control's Events from Working
242237 Worksheet may not recalculate completely when you repeatedly press F9
242375 PRB: Office 97 Automation Client Fails After Re-compilation with Office 2000 or Later Type Library
242404 Files take longer to open in Excel 2000 and later versions than Excel for Windows 95 Files
243394 HOWTO: Use MFC to Copy a DAO Recordset to Excel with Automation
243495 The Calculate message may remain in the status bar when you enter formulas that include cell references
246501 INFO: Use an Explicit Locale Identifier (LCID) When Automating Excel to Set Currency Formats
248204 You are prompted to enable automatic refresh when you open a workbook in Excel
248822 How to use custom functions with the Spreadsheet component
253501 How to pass a COleDispatchDriver as an argument for a method expecting a VARIANT
254006 INFO: Access Data Retrieval Sample Add-In Available for Download
254008 Gantt Chart Sample Add-In is available for download
258511 How to obtain the window handle for an Office Automation server
258781 You receive an error message when you try to open multiple documents in Excel
259137 How to determine whether a selected cell in an Excel worksheet is in a specified defined range by using a Visual Basic macro
259971 How To Dismiss a Dialog Box Displayed by an Office Application with Visual Basic
260199 The Close button is dimmed in Excel after GroupWise is installed
261997 How To Obtain the Window Handle for an Office Automation Server with MFC
263213 INFO: Excel May Change the Precision Mode of the Floating-Point Control Word
263498 Add method of QueryTables with Excel automation generates run-time error message "5"
265361 XL: Excel Does Not Run on Multiple Processors
266161 XL: Problems When You Use.Formula Property of a Range of Cells to Set Values in an Array
266318 How to retrieve the name of an Office document that contains an MFC ActiveX control
268007 How to sort more than three columns in Excel
268016 Internet Explorer cannot open an Excel Add-In (*.xla) file
268470 SAMPLE: FramerEx.exe Is an MDI ActiveX Document Container Sample Written in Visual C++
269168 How to recognize the difference among Excel 97 files, Excel 2000 files, and Excel 2002 files by using Visual C++ 6.0
270844 How to create an Excel histogram by using Automation and Analysis ToolPak
271736 How to add Excel LinkedCell support to your ATL ActiveX control
271856 Hyperlink does not work when pasted or imported
272066 Compile error in hidden module Tbrun97.xls in Excel
272729 How to import data with more than 256 fields or columns into Excel
274500 "Save changes in <filename>" prompt even if no changes are made
274680 How to use MFC to retrieve a list of macro names in an Office document
277576 Error message when you try to e-mail a worksheet:"A sheet in the workbook you are trying to save is password protected"
277577 XL2002: Error Message: Run-Time Error 1004: Unable to Set the LineStyle Property of the Border Class
277581 You can use keyboard shortcuts to select border styles in Excel
277582 Error message when you use the Lookup Wizard in Excel: "Run-time error '1004' Application-defined or object-defined error"
277583 XL2002: Unable to Save File as Excel Add-In Unless Active Sheet Is a Worksheet
277585 The LINEST function returns incorrect results in Excel
277587 You may receive an error message when you open a DQY file in Excel
277589 XL2002: Argument in the Insert Function Dialog Box Looks Like a Hyperlink but Does Not Work
277593 XL2002: Scatter Chart Series Lines and Trendlines Are Not Printed Correctly
277598 XL2002: Spelling Checker Does Not Correct to the Suggested Spelling
277599 XL2002: <Projectname.Classname> Is Not a Valid Add-in
277605 Incorrect value is calculated when the thousand separator is the same as the decimal separator in Excel
277606 Microsoft Map removed from the computer when you upgrade to Excel 2002 or to Excel 2003
277612 Table markers do not appear when you perform a Web Query in Excel on a secure Web site