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
213939 XL2000: Algorithms Used in the ATP Functions
213942 XL2000: Certain ODBC Drivers Do Not Support Long File Names
213947 HOW TO: Create PivotTables from Multiple Consolidation Ranges in Excel 2000
213951 How to troubleshoot the source of the problem when you save files in Excel 2000 and they become corrupted
213953 XL2000: How Transition Formula Entry Affects Behavior in Excel
213955 XL2000: "PivotTable Field Name Is Not Valid..." Error Message When Refreshing, Creating PivotTable Report
213958 HOW TO: Add Text to the X-Axis or Y-Axis on a Chart in Excel 2000
213961 HOW TO: Use SUM Function on Only Odd or Even Rows in Excel 2000
213962 XL2000: Copying Sheets Between Workbooks Can Create Unexpected Links
213967 XL2000: AutoSelect May Detect a Double Header
213970 XL2000: Cell Linked to Text-Formatted Cell Shows Formula Not Value
213976 XL2000: Cannot Open Quattro Pro for Windows File in Excel
213980 XL2000: Data Map Charts Use Hidden Rows and Columns
213986 XL: Unable to Use Scroll Bar on Number Tab in Format Cells Dialog Box
213996 XL2000: Advanced Filter Does Not Detect Additions to List
213998 XL2000: Cannot Set Print Area or Print Titles
214001 XL2000: Left and Right-Aligned Header/Footer Text Ignores Margins
214002 XL2000: Macro Assigned to a List Box Does Not Run
214003 XL2000: Updating Incorrect Calculations on Pentium-Created Worksheet
214004 XL2000: Unexpected Number Formats Appear Under Custom Category
214005 XL2000: Detailed Solutions for Interest Rate Formulas
214006 XL2000: Error Message When You Open a Lotus 1-2-3 WK4 File
214009 HOW TO: Export Lotus 1-2-3 Linked Files to Excel 2000
214011 How to create a column chart with two Y-axes in Excel
214013 XL2000: AutoFilter Command Is Unavailable After Using the Hide All Objects Option
214014 XL2000: How to Set the Descriptive Name of an Add-in File
214015 XL2000: "File Not Loaded Completely" Error Message When Running Text Import Wizard
214018 XL2000: Error Message When You Use the Lotus File Combine Command in Macro
214021 XL2000: Data Number Formatting Is Lost After You Create a PivotTable
214023 XL2000: Linked Cells Display #REF! Error Message with Dependent Workbook
214025 XL2000: Trendlines Unavailable for Area Chart Type
214026 XL2000: Error Message: "Cannot Group that Selection"
214029 The selected Data Analysis tool uses only data from the active sheet if sheets of a workbook are grouped in Excel
214031 HOW TO: Convert Dates in Imported Files from yy/mm/dd to mm/dd/yy Format in Excel 2000
214033 Pie Chart Shows Incorrect Percentage Value in Excel
214036 XL2000: Cannot Delete Default Headers or Footers
214039 XL2000: Some Special Characters Are Changed in Imported Files
214040 HOW TO: Use Lotus 1-2-3 Commands to Attach Text Data Labels to a Chart in Excel 2000
214042 You receive an error message when you access files from a floppy disk in Excel
214043 XL2000: Paste Function Does Not Enter Formulas As Arrays
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
214050 XL2000: Basis Argument for Financial Functions
214051 XL2000: Data Sort Selects an Incorrect Range
214053 XL2000: Formula to Sum Digits of a Number
214054 XL2000: "Cannot Change Part of an Array" Error Message
214057 HOW TO: Display Data as Percentage of the Total in a PivotTable in Excel 2000
214058 Days of the week before March 1, 1900 are incorrect in Excel
214060 XL2000: All Available Toolbars Are Not Listed on the Toolbar Shortcut Menu
214064 XL2000: Fields Truncated When File Is Saved in .dbf Format
214068 XL: Date Values Earlier Than 1900 Appear as Text