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

Article ID Article Title Hidden
124935 Visual Basic Macros That Add or Remove Hidden Apostrophes
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
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
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
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
158543 XL97: Double-Clicking Workbook in MS Exchange Causes Error
158921 XL97: File Password Lost Moving File to an Exchange Folder
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
171280 PRB: Error Message "Cannot insert object" in Excel
171595 How to Change the ToolTip for a Custom Toolbar Control
173614 Resolving conflicts unhides previously hidden worksheet in Excel for Mac
174658 XL: "Merge Handler" Error Message Dragging Files into Briefcase
175753 DATE Function May Return #NUM! Error When Year Is 0-3