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
214069 XL: How to Return the First or Last Match in an Array
214070 Description of filtering and extracting a record that contains a text string in Excel
214084 XL: How to Display the File Name of a Worksheet Without Using a Macro
214091 XL: Finding the Balance of a Loan for a Given Period
214093 XL: How to Display the Current Date and Time with Text
214098 Error Message when you use the Fourier Analysis tool in Microsoft Excel: "Fourier Analysis - The Number of Input Values Must Be 4096 or Less"
214100 XL: How to Extract an Exact Match of Text from a Database
214108 XL: "Cannot Open Protected File" Error Message When You Open Password Protected WK3 or WK4 File
214113 XL: Function to Compute Interest and Growth Rate on a Single Payment
214114 Unexpected result pasting non-contiguous range from Excel into Word
214133 XL: Formula for Distance/Velocity Returned in Hours, Minutes, and Seconds
214139 XL2000: How to Break Links Between a Chart and a Worksheet
214249 How to use the Conditional Sum Wizard in Microsoft Excel
214250 Excel cannot open MultiPlan files
214259 How to use grouping for fields in a PivotTable in Excel
214263 XL: Example on Use of Solver
214264 XL: How to Perform a Case-Sensitive Lookup
214265 XL: How to Create a User-Defined Chart Format
214275 XL: Using 16-Bit and 32-Bit ODBC Drivers
214278 Row Height Changes When You Print to a Different Printer
214282 Sorting alphanumeric text as numeric values
214295 How to bypass the Text Import Wizard when you import files in Excel
214297 Window options are not saved in a workspace file in Excel
214304 XL: Minus Sign Appears Before Text in Custom Number Format
214332 XL: Text Is Truncated in Text Box on Chart in Worksheet When Printed or Previewed
214342 Error message in Excel: "Unable to save external link values"
214377 "Syntax error in FROM clause" when getting external data
214462 PRB: Error "Bound to Unknown Type" Inserting ATL Control in VBA UserForm
214797 How To Automate Excel Using Perl for Win32
215573 You receive an error message when you add a chart to a workbook in Excel
215783 XL: "Excel Could Not Save All the Data and Formatting" Error Message
215904 Changing a PivotChart removes series formatting in Excel
216657 PRB: Error Messages When Opening Word Documents or Excel Workbooks with Internet Explorer
219430 How To Create/Format an Excel Workbook Using Visual J++ Automation
221064 Nothing happens when clicking a hyperlink in an Excel Web page
221070 Decimal points in Accounting format are not aligned in browser in Excel
221493 XL: Code Module May Be Missing After Opening and Saving Workbook as Web Page
223396 How to minimize metadata in Office documents
223789 How to minimize metadata in Microsoft Excel workbooks
224925 INFO: Type Libraries for Office May Change with New Release
225029 How To Determine Which Version of Excel Wrote a Workbook
230137 Some files do not print when you use Windows Explorer to print files from Excel 2007, Excel 2002, or Excel 2000
231052 #N/A error displayed in data field of PivotTable based on OLAP data source
231614 How To Automate Excel to Create a New Workbook from Delphi
232866 The whole Excel workbook may be pasted when you paste only the copied cells into another program
234700 Differences between OLAP and non-OLAP PivotTables in Excel
236872 You receive an "I/O Error" or the subfolders are displayed as question marks or squares in Office programs
238133 How To Write a DDEML Server for Excel and Use it with NetDDE
238393 How To Use Visual C++ to Access DocumentProperties with Automation
238983 How to trap events exposed by Office applications