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
124751 Left/Right-Aligned Header/Footer Text Ignores Margins
124935 Visual Basic Macros That Add or Remove Hidden Apostrophes
129276 You receive a "This file is locked" error message when you try to save or close a shared file
129795 PRB: Excel Doesn't Use Container's Name for Embedded Objects
130494 XL2000: "This File Has Been Locked" Error Message Saving Shared Workbook
130560 XL: Commands and Features Unavailable in Shared Workbook
131290 ActivatePrevious Method Uses Z-Order Defined by User
131384 XL: EVALUATE() Function with INDIRECT() Returns #REF! Error
131731 Data Map Charts Use Hidden Rows and Columns
131929 XL: Zip Codes in Data Map Must Be Formatted with Zip Code Style
133139 Range Command in Macro Selects Cells from Entire Range
133198 Macro to Import a Text File into Existing Worksheet
134913 XL: GetCustomListNum Returns Unexpected List Number
136314 Copying Sheets Between Workbooks Can Create Unexpected Links
137807 XL: Goto Method Fails When Custom Dialog Box Visible
138010 OFF: Office Only Runs on Intel-Based Computers
139402 How to Use DAO to Create a New Microsoft Excel Workbook
141282 Macro to Open All Linked Workbooks
141692 Visual Basic Example to Retrieve Value from Last Cell
141759 SAMPLE: XLCLIENT: Automation Client for Excel
141762 XL: How to Use Looping Structures in Visual Basic for Applications
141765 Unexpected behavior with numbers formatted as text
142387 How To Create Excel Chart w/OLE Automation from Visual Basic
142588 How to compare two cells and ignore leading and trailing spaces by using the TRIM worksheet function
145759 "User-Defined Type Not Defined" Error Message Using DAO
146197 XL: How to Find Technical Information About Microsoft Excel
147392 How to Force Macro Code to Wait for Outside Procedure
147637 XL: How to Create a Map with Microsoft Data Map
147640 How to Hide Records with Duplicate Cell Entries
147742 XL: How to Close All Workbooks but One with Visual Basic Macro
147942 Microsoft Excel's Internal Format Table Doc Has Errors
149235 How to help prevent file corruption in Excel
149831 How to Populate an Array with a Discontiguous Range
151337 Increment Relative References by More Than One Cell in VBA
151364 Glossary of charting terminology in Excel
154876 You receive an error message when you use right bracket in text file name in Excel 2003 and earlier versions
157035 Date Returned in a Macro Is Four Years Too Early
158071 Problems vith Statistical Functions and Large Numbers in Excel
159960 Drawing Objects Behave Differently When Clicked
162028 Formatting is not retained in PivotTable in Excel
162814 Sample macros to return ID for a CommandBar control
163109 Works: How to import and export Works spreadsheets to Excel
164317 How to sum a range of cells based on a number format in Excel
164383 No Tables Appear in Add Tables Dialog Box
165866 XL: How to Use File DSNs and DSN-less Connections
166880 XL: Most Recently Used List Is Not Updated
168437 XL: Unable to Select Defined Names by Using Function Wizard
169033 Only first worksheet prints duplexed
169101 Text Is Cut Off When Cell Uses Bottom Alignment
170230 Unexpected results when using AutoFilter with numeric data