Microsoft KB Archive Search

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.

  1. Home
  2. Products
  3. Microsoft Excel 2002 Standard Edition

Articles for product: Microsoft Excel 2002 Standard Edition

Article ID Article Title Hidden
212144 Hyphens and apostrophes are sorted after alphabetic letters in Excel
212147 XL: Workbook Protected or Saved with a Password Is Saved Very Slowly
212250 Cannot add a data table to some charts in Excel
212366 Rotated text in an Excel worksheet is displayed horizontally when you view the text in a browser
212746 Cell fill color bleeds into adjacent cells in Excel when the file is viewed in Web browser
213181 Run-time error using FormulaArray property
213189 Stop Recording Toolbar is not displayed when you record a macro
213203 XL2000: Run-Time Error Message Occurs When Using SpecialCells Method with Protection
213243 Odd refresh behavior after you specify a conditional format in Excel
213343 XL: How to Put Folder Contents into a Worksheet
213413 Visual Basic macro to show active cell's range names in Excel
213438 How to programmatically select every nth row in a range in Excel
213447 XL: Visual Basic Module to Create a Gantt Chart
213476 XL: Unexpected Results with Mixed Text and Numbers in Lookup Table
213489 Add-ins do not load when using the CreateObject command in Excel
213495 How to use a formula in Excel to calculate the average of a data sample without the highest and lowest values
213507 XL: How to Count Cells That Contain Formulas, Text, or Numbers
213528 XL: Contents of the Samples.xls Workbook
213548 "255 characters in cell" error when copying worksheet
213598 You cannot use the PrintOut method when the custom dialog box is visible
213630 How to use the IF THEN ELSE statement and the SELECT CASE statement in examples written in Visual Basic for Excel
213638 How to create a macro that counts comments
213650 Error opening file that refers to shortcut
213654 XL: All PageSetup Settings Are Recorded into Macro
213689 Compile error occurs running a recorded macro that uses the Solver add-in
213719 Description of the Value2 property for the Range object in Excel
213740 How to record a macro using relative cell references in Excel
213754 How to customize a custom toolbar button
213772 How to use system, user, and file data source names (DSN) in Excel 2000 or Excel 2002
213773 How to create data validation circles for printing in Excel
213798 Sample Visual Basic macros for working with arrays in Excel
213800 In Office programs, you receive a "Specified COMMAND search directory had too many parameters" error message when you try to use an MS-DOS core command from the Shell function
213801 Sample Visual Basic code to create a color index table in Excel
213823 Macro that changes cell dimensions on multiple sheets does not run as expected
213826 XL2000: Visual Basic Macro to List Circular References
213836 Update remote references check box is usually selected in Excel 2003 and in earlier versions of Excel
213837 How to run subroutines and macros from Visual Basic in Excel 2000 or Excel 2002
213841 Passed strings longer than 255 characters are truncated in Excel
213886 The AutoFilter status bar displays the "Filter Mode" message in Excel
213901 XL: General Number Format Applied to Improper Time Entry
213915 How to create a Gantt chart using hours as the scale
213923 How to use AutoFilter to filter records based on cell formatting in Excel
213986 XL: Unable to Use Scroll Bar on Number Tab in Format Cells Dialog Box
214011 How to create a column chart with two Y-axes in Excel
214029 The selected Data Analysis tool uses only data from the active sheet if sheets of a workbook are grouped in Excel
214033 Pie Chart Shows Incorrect Percentage Value in Excel
214042 You receive an error message when you access files from a floppy disk in Excel
214048 You receive a "This file is not in a recognizable format" error message when you try to open a file in Works 3.0 or 4.0 format in Excel 2000 or Excel 2002
214058 Days of the week before March 1, 1900 are incorrect in Excel
214068 XL: Date Values Earlier Than 1900 Appear as Text