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
213814 XL2000: Macro to Extract Data from a Chart
213815 XL2000: How to Change the Paper Source Using the SendKeys Command
213816 XL2000: Macro to Import a Text File into an Existing Worksheet
213817 XL2000: How to Open a Copy of a Template in Microsoft Excel 2000
213818 XL2000: How to Use a Visual Basic Macro to Sort Arrays in Excel
213820 XL2000: How to Use Data Access Objects to Join Tables of Different Formats
213823 Macro that changes cell dimensions on multiple sheets does not run as expected
213825 XL2000: "Overflow" Error Message Running Procedure with Math Calculation
213826 XL2000: Visual Basic Macro to List Circular References
213828 XL2000: Cannot Specify Number of Digits with FIX() or INT() Functions
213830 XL2000: Error Using For Each...Next Statement with OLE Object Type
213831 XL2000: Macro to Check for Page Breaks on a Worksheet
213832 XL2000: How to Hide Button Controls with Visual Basic for Applications
213833 XL2000: Creating Macros for Different Language Versions
213834 XL2000: Inconsistent Formatting When You Use VBA Borders Method
213835 XL2000: ShowDataForm Method Fails if Data Cannot Be Found
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
213879 You receive the "Unable to read file. Unexpected file lock" error message in Excel 2000
213880 HOW TO: Use Microsoft Map to Display Specific States and Nations in Excel 2000
213881 HOW TO: Change the Chart Type of a Series in a Combination Chart in Excel 2000
213882 HOW TO: Use Microsoft Map to Display Postal Code Centers in Excel 2000
213884 HOW TO: Hide Gridlines in a Selected Area of a Worksheet in Excel 2000
213886 The AutoFilter status bar displays the "Filter Mode" message in Excel
213887 HOW TO: Find the Secant, Cosecant, or Cotangent of an Angle in Excel 2000
213888 XL2000: Data Labels on Chart Appear Outside the Plot Area
213890 XL2000: Error Message When You Create a Worksheet with New Office Document Option
213891 XL2000: Excel Help Example Returns Incorrect Result for ERROR.TYPE Function
213893 XL2000: Line Object Is Missing in Print Preview or When Printed
213894 XL2000: Source Data for PivotTable Is Displayed As Number Signs
213897 XL2000: PivotTable Report Created on New Worksheet Despite Setting in Wizard
213899 XL2000: Wrap Text Format Causes Text to Move Closer to Top of Cell
213900 XL2000: Error Message: Your Formula Contains an Invalid External Reference to a Worksheet
213901 XL: General Number Format Applied to Improper Time Entry
213903 XL2000: How to Help Protect Visual Basic Code in Excel
213909 XL2000: Cell References in Copied Formula Are Incorrect
213913 HOW TO: Preserve Formulas If You Save a Document As a Text File in Excel 2000
213914 HOW TO: Use STDEV or STDEVP with a PivotTable in Excel 2000
213915 How to create a Gantt chart using hours as the scale
213916 HOW TO: Rank Duplicate Values Sequentially in Excel 2000
213917 XL2000: Using the OFFSET, MATCH, and MAX Worksheet Functions to Return the Last Value in a Range
213920 HOW TO: Analyze a Questionnaire or Survey with a PivotTable in Excel 2000
213921 HOW TO: Add Totals to a Stacked Column Chart in Excel 2000
213922 HOW TO: Index Data in a PivotTable in Excel 2000
213923 How to use AutoFilter to filter records based on cell formatting in Excel
213926 XL2000: Currency Style Button Applies Accounting Number Format
213928 HOW TO: Create Two Pie Charts in One in Excel 2000
213929 HOW TO: Create a Single Stacked Column Chart or Single Bar Chart in Excel 2000
213937 XL2000: Error When Inserting a Map Object