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
30567 XL: IRR Returns #DIV/0! Instead of #NUM! If No IRR Exists
30970 XL: Calculating the Future Value of a Single Cash Flow in Excel
58245 XL: Defined Names Not Sorted in Excel
59616 XL: Use of the IRR Function in Excel
60116 XL: Returning the Smallest Number Greater Than Zero
61269 XL: How to Copy Column Widths
61892 XL: PRODUCT Function Evaluates a Blank Cell as 1, Not Zero
65903 Number of significant digits MS Excel retains
66033 Hexadecimal Values Changed When Imported from .CSV File
71952 XL: How to Calculate Interest Paid for Multiple Periods
74493 XL: Macro to Place Filenames in Given Directory on Worksheet
75513 XL: How to Reverse the Order of Words in a Text String
75714 XL: Solver Limits for Constraints and Adjustable Cells
77241 Creating charts with multiple groups of stacked bars
77295 Column delimiters are missing in an Excel spreadsheet that is saved as text
79625 XL: Using Noncontiguous Ranges in Array Functions
82890 Solver Uses Generalized Reduced Gradient Algorithm
87299 XL: How to Suppress Error Values on a Worksheet
95479 XL: Method to Calculate Interpolation Step Value
95811 XL: Error Message: "Input Cell Reference Is Not Valid"
100782 XL: Method Used by Goal Seek to Find a Solution
100825 #VALUE error when you add text and values in Excel
104310 MS Excel 2.x/3.x/4.x Worksheets Take a Long Time to Open/Save
105111 XL: Sorting Feature Ignores Hidden Rows
106009 XL: Macro to Restore Tab Split Box to Default Position
108271 Calculating Depreciation with the Production Method
108278 Macros to Return Windows and System Directory Paths
108892 Cells.Find Returns Error When No Match Found
109211 Calculating Weighted Averages
109780 Branching to Other Sections of Code with GoTo and Call
110006 How to reset the Update Remote References option in Excel
110854 XL: How to Compute the Periodic Annual Interest Rate in Microsoft Excel
111941 Can't Link to Worksheet with Exclamation Point in Name
113237 Visual Basic Macro to Concatenate Columns of Data
113659 Visual Basic Nested Case Statement Example
114388 Error Message: FUNCRES.XLA Is Not a Valid Add-in
114975 Using Data Analysis Tools on Grouped Sheets
115341 Column Charts May Not Show All Data Labels
116280 Err Msg:"Cannot Find Macro" Running Macro from Object
117128 XL: Hidden Cells in a Worksheet May Become Unhidden
119083 XL: MOD() Function Returns #NUM! Error Value
119826 Macro to Remove Hidden Names in Active Workbook
120596 Text files that are larger than 65,536 rows cannot be imported to Excel 97, Excel 2000, Excel 2002 and Excel 2003
121824 Toolbar Button Capable of Alternate Action
123183 How to export data to a text file with comma and quote delimiter in Excel
123198 XL: How to Compute the Average Growth Rate of an Investment
123757 Detailed Solutions for Interest Rate Formulas
124751 Left/Right-Aligned Header/Footer Text Ignores Margins
124935 Visual Basic Macros That Add or Remove Hidden Apostrophes
130560 XL: Commands and Features Unavailable in Shared Workbook