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 2000 Standard Edition

Article ID Article Title Hidden
214254 XL2000: Blank Cells in Input Range of Regression Tool Return Error Message
214258 HOW TO: Create Multiple Views, Create and Print a Report in Excel 2000
214259 How to use grouping for fields in a PivotTable in Excel
214260 HOW TO: Create Functions to Calculate Light Years in Excel 2000
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
214266 XL2000: Error Message: The Command You Chose Cannot Be Performed with Multiple Selections
214271 XL2000: MOD Function and Mod Operator Return Different Values
214273 XL2000: Custom Scientific Number Format Is Displayed Incorrectly
214274 XL2000: Errors Saving File to Earlier Formats
214275 XL: Using 16-Bit and 32-Bit ODBC Drivers
214276 XL2000: Some List Elements Ignored When You Create Custom Lists
214278 Row Height Changes When You Print to a Different Printer
214279 XL2000: Formula Returns Unexpected Positive Value
214280 XL2000: Cell That Contains Formula Assumes Formatting of First Cell in Reference Range
214282 Sorting alphanumeric text as numeric values
214283 XL2000: Consolidated Labels Use Name of Workbook Instead of Sheet Name
214285 XL2000: Can't Use Find/Replace on Text with Leading Apostrophe
214287 XL2000: AutoFilter List Hides Rows Even After Information Is Cleared
214288 XL2000: AutoSave Command Recorded in Subroutine or Macro
214289 Description of ODBC add-in functions and arguments in Excel 2000
214290 XL2000: Column Charts May Not Show All Data Labels
214292 HOW TO: Add a Series to an XY (Scatter) Chart with a Second X-Axis in Excel 2000
214293 XL2000: Area Charts Ignore "Empty Cells Plotted As" Setting
214294 XL2000: Can't Link to Worksheet with Exclamation Point in Name
214295 How to bypass the Text Import Wizard when you import files in Excel
214296 XL2000: Can't Link Value of Control to Function
214297 Window options are not saved in a workspace file in Excel
214298 HOW TO: Create an Add-in Application Name and Description in Excel 2000
214299 XL2000: Can't Hide/Unhide Sheets If Workbook Contents Protected
214300 HOW TO: Use the "Most Recently Used" Category in the Function Wizard in Excel 2000
214302 XL2000: PivotTable Wizard Does Not Automatically Refresh Data
214304 XL: Minus Sign Appears Before Text in Custom Number Format
214305 XL2000: Linked References Not Updated in Closed Worksheet
214306 XL2000: Cannot Drag, Cut, or Copy AutoFilter Drop-down List
214307 XL2000: Financial or Accounting AutoFormats Change Number Formats
214311 XL2000: VLOOKUP()/HLOOKUP() Functions Return Incorrect Value with TFE
214312 XL2000: Cannot Change Series Colors on a Surface Chart
214314 HOW TO: Open a Document Linked to Password-Protected Sheet in Excel 2000
214315 XL2000: Calculating the Number of Days Between Two Dates
214316 XL2000: Order of Operations Performed in Formulas
214317 XL2000: Moving Average Period Reduced by 256 After You Save the File
214318 XL2000: Series Data Orientation Not Saved in Custom Chart Type
214319 XL2000: Dates Truncated When You Save Worksheet as PRN File
214321 XL2000: OFFSET Accepts Negative Values for Height and Width
214322 XL2000: COUNTA Function Returns 1 with Invalid Reference Argument
214323 XL2000: Custom Date Appears or Date Is Missing in AutoFilter List
214324 HOW TO: Use Advanced Filter to Exclude Records in Excel 2000
214327 XL2000: Wrong Date Returned When You Enter Month and Digits