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
236872 You receive an "I/O Error" or the subfolders are displayed as question marks or squares in Office programs
238133 How To Write a DDEML Server for Excel and Use it with NetDDE
238393 How To Use Visual C++ to Access DocumentProperties with Automation
238983 How to trap events exposed by Office applications
241072 Dates and times displayed as serial numbers when viewing formulas in Excel
241399 XL: History of Changes to Visual Basic for Applications
241652 FIX: Changes Made to Excel CommandBars Through Automation Are Not Saved
241861 BUG: ATL Control in Office Document Prevents Another Control's Events from Working
242375 PRB: Office 97 Automation Client Fails After Re-compilation with Office 2000 or Later Type Library
243394 HOWTO: Use MFC to Copy a DAO Recordset to Excel with Automation
243495 The Calculate message may remain in the status bar when you enter formulas that include cell references
244023 You receive different results from the ACCRINT function in Excel 97 and in Excel 2000
245089 BUG: Cannot Add Chart to Specific Worksheet using Automation to Excel
249607 FIX: Visual Basic 6 .0 UserControl in Excel Does Not Print or Display in Print Preview
253501 How to pass a COleDispatchDriver as an argument for a method expecting a VARIANT
254733 XL: Workbooks Containing User Forms Take Excessively Long Time to Save Across WAN Connections
256045 Data validation only applies to manual cell in Excel
258511 How to obtain the window handle for an Office Automation server
259137 How to determine whether a selected cell in an Excel worksheet is in a specified defined range by using a Visual Basic macro
259971 How To Dismiss a Dialog Box Displayed by an Office Application with Visual Basic
260199 The Close button is dimmed in Excel after GroupWise is installed
260239 How To Format Cell Data When You Are Creating an Excel File With an Active Server Pages Page
261997 How To Obtain the Window Handle for an Office Automation Server with MFC
263213 INFO: Excel May Change the Precision Mode of the Floating-Point Control Word
264517 XL: Linked Charts Lose Custom Colors When You Update Source Data
265311 XL: Excel 95 Auto_xxxx Defined Name Values Change When Imported into Excel 97 or 2000
265361 XL: Excel Does Not Run on Multiple Processors
266161 XL: Problems When You Use.Formula Property of a Range of Cells to Set Values in an Array
266200 XL2000: Separator in Comma Separated Value (CSV) File Is Substituted Without Warning
266318 How to retrieve the name of an Office document that contains an MFC ActiveX control
266443 XL: DDE Formulas Produce #NAME? Error in Shared Workbooks
268007 How to sort more than three columns in Excel
268016 Internet Explorer cannot open an Excel Add-In (*.xla) file
269168 How to recognize the difference among Excel 97 files, Excel 2000 files, and Excel 2002 files by using Visual C++ 6.0
270844 How to create an Excel histogram by using Automation and Analysis ToolPak
271856 Hyperlink does not work when pasted or imported
272066 Compile error in hidden module Tbrun97.xls in Excel
274531 XL: Series Order Is Reversed When Chart Type Is Changed to 3-D
277585 The LINEST function returns incorrect results in Excel
279721 How to use Dynamic Data Exchange (DDE) with Word and Excel from Visual C++
280290 How to install an Excel Add-in (XLA or XLL) with Automation
280641 The Excel 97 custom toolbars are not imported when you upgrade from Excel 97 to a later version of Excel
282855 How to create and use one-input data tables in Microsoft Excel
285347 XL: Illegal Operation Error When You Attempt to Format Cells
288616 The RTD function generates an Excel 4.0 macro warning when you open an Excel 2002 workbook in Excel 97
288839 XL: Exported Comma Separated File Ignores Regional Settings
290359 How to remove leading space for values converted to strings
292054 OFF97: Error Message: Error 429: ActiveX Component Cannot Create Object
292264 You cannot open a password-protected workbook if you forget or lose the password
294396 XL: Examples of Interest Calculations Outside the United States