• ▼MSDN Library - April 2000
    • ▶Welcome to the MSDN Library
    • ▶Visual Studio 6.0 Documentation
    • ▶Office Developer Documentation
    • ▶Windows CE Documentation
    • ▶Platform SDK
    • ▶SDK Documentation
    • ▶DDK Documentation
    • ▶Windows Resource Kits
    • ▼Knowledge Base
      • About the Microsoft Knowledge Base
      • ▶ACME Setup Program
      • ▶BackOffice
      • ▶Data Access
      • ▶Exchange
      • ▶Fortran Compiler
      • ▶FoxPro
      • ▶Hardware
      • ▶Internet Explorer
      • ▶Internet Development
      • ▶Macro Assembler
      • ▶Messaging
      • ▶Microsoft Developer Network
      • ▶Microsoft Mastering Series
      • ▶Microsoft Systems Journal
      • ▶NetShow
      • ▼Office
        • ▶Access
        • ▶Access 2000
        • ▶Access Distribution Kit
        • ▶Excel
        • ▶Excel 2000
        • ▼Excel 97
          • Excel: Calculating the nth Root of a Number
          • Excel: Finding the nth Value That Meets a Condition
          • Query97: 'Invalid Bracketing' Error Adding Field to MS Query
          • Query97: 'Syntax Error (Missing Operator)...' Error Querying
          • Query97: Cannot Save a Query's Result Set as a Table
          • Query97: MSQuery Uses 1900 Date When Two Digits Used for Year
          • Query97: Query Returns More Records Than You Specify
          • Returning the Second Minimum or Maximum in a Range
          • SBFM: MS Visual C++ Run-Time Errors Importing Quickbooks Data
          • SBFM97 ErrMsg: Illegal Operation Updating Quickbooks Data
          • SBFM97: 'Setup Could Not Find Microsoft Excel' Error Message
          • SBFM97: 'Run Time Error 13' Caused by Incorrect DAO Files
          • SBFM97: 'Run-time Error 13' Using Buy vs. Lease Analysis
          • SBFM97: Axis Labels Missing on Profitability Chart
          • SBFM97: Beginning Balances in Report Are Incorrect
          • SBFM97: Currency Changes Sign in Profitability Analysis
          • SBFM97: Error Message Appears When Importing QuickBooks Data
          • SBFM97: Error Message When Running Wizards Under MS Windows NT
          • SBFM97: Error Updating Accounting Data
          • SBFM97: Error Updating Database After Creating Report
          • SBFM97: List of Supported Accounting Programs
          • SBFM97: Quickbooks 3.1 Filter Fails Under Windows NT
          • SBFM97: Quickbooks 4.0 Filter Fails Under Windows NT 4.0
          • SBFM97: Quickbooks Version 5.0 Filter Is Available
          • SBFM97: Resolving Problems with the QuickBooks Accounting Filter
          • SBFM97: Restore Wizard Values Does Not Recalculate Worksheet
          • SBFM97: Setup Could Not Find Microsoft Excel Installed
          • SBFM97: Total Monthly Payments Calculation Is Incorrect
          • SBFM97: Trial Balance with Scenarios Out of Balance
          • SBFM97: What-If Scenario Name Does Not Appear in Overview
          • VBE: User-Defined Functions Are Calculated Incorrectly
          • XL97: Errors Saving When Transition Formula Evaluation Enabled
          • XL97: '
          • XL97: 'am/pm' Changed to 'AM/PM' in Custom Number Format
          • XL97: 'Auto_Open_xlquery_DClick' Error Appears Opening File
          • XL97: 'Before You Save...' Error When Quitting Program
          • XL97: 'Cannot Convert' Error Saving File in Earlier Format
          • XL97: 'Cannot Empty the Clipboard' Err Msg When Dragging Cells
          • XL97: 'Cannot Find the Mainxl.hlp File' When Using Help
          • XL97: 'Cannot Open Specified File' Clicking Hyperlink
          • XL97: 'Cannot Quit' After Using Visual Basic Editor
          • XL97: 'Cannot Shift Objects Off Sheet' Error Hiding Columns
          • XL97: 'Compile error: Expected function or variable' w/ FindFile
          • XL97: 'Couldn't Decrypt File' Error with Password Protected File
          • XL97: 'Create Hyperlink Here' Does Not Work in Unsaved File
          • XL97: 'Exit Design Mode' Deactivates Visual Basic Editor
          • XL97: 'Features Not Supported' Error Message Saving Workbook
          • XL97: 'File Format Not Valid' Appears Opening Routed Workbook
          • XL97: 'File not Found' Error Activating Excel Object
          • XL97: 'FrontPage Cannot Be Found on Your Machine' in Wizards
          • XL97: 'Help Topic Does Not Exist' Error in Function Wizard
          • XL97: 'Help Topic Does Not Exist' Error with Data Analysis Tools
          • XL97: 'Illegal Operation' Opening a Non-Microsoft Excel File
          • XL97: 'Insert Copied Cells' Menu Item Missing After Copy
          • XL97: 'Invalid Data Format' Error Opening Workbook
          • XL97: 'Invalid rows to scan' Error Creating Excel Data Source
          • XL97: 'Later Version' Error Message Appears Opening a Workbook
          • XL97: 'Method 'Delete' of object...' Running Sample Code in Help
          • XL97: 'Microsoft Excel Cannot Access...' Opening File from Web
          • XL97: 'Missing or Illegal Field Name' Using Advanced Filter
          • XL97: 'Not Enough Memory' Error Adding Chart to Workbook
          • XL97: 'Not Enough Memory' Error Using Linking Formulas
          • XL97: 'Numeric Value Out of Range' Error in Parameter Query
          • XL97: 'Out of Virtual Memory' Opening Many Workbooks w/ Controls
          • XL97: 'PivotTable Is Not Valid' Error Working with PivotTable
          • XL97: 'Project Is Unviewable' Message Trying to View Project
          • XL97: 'Reference Is not Valid' Error Clicking Hyperlink
          • XL97: 'Run-Time Error '1004': ATPVBAEN.XLA Could Not Be Found'
          • XL97: 'Save As HTML' Does Not Create Some Tags
          • XL97: 'System Error ? Message Opening Add-In
          • XL97: 'That Command Cannot Be Used' Inserting Columns or Rows
          • XL97: 'The Disk Is Full' Error Copying Very Large Worksheet
          • XL97: 'Unable to Open' Error Performing Web Query
          • XL97: 'Unable to Record' Message When Recording a Macro
          • XL97: 'Xlquery.xla Could Not Be Found' Error Opening File
          • XL97: #NAME? Error After Linking or Updating Data
          • XL97: #NAME? Error in Formula After Copying into Data Range
          • XL97: #REF! Error Recalculating Worksheet with Defined Name
          • XL97: #VALUE! Appears When Function Is Recalculated
          • XL97: ;;; Number Format Fails to Hide Cell Contents
          • XL97: 3-D Surface Chart Lines May Not Follow Slope of Data
          • XL97: Access Violation or Page Fault Closing Worksheet Object
          • XL97: AccessLinks Add-in Fails with Large Number of Rows
          • XL97: Active Cell Moves Using RefreshTable Method
          • XL97: ActiveMenuBar.Index Different Than Earlier Versions
          • XL97: ActiveX Controls May Be Inadvertently Cropped
          • XL97: ActiveX Image Control on a Worksheet Cannot Be Edited
          • XL97: Add to List Button Dimmed in Advanced Find
          • XL97: Additional Controls Dialog Box Disappears
          • XL97: Additional Controls Dialog may not use Long Filenames
          • XL97: Advanced Filter Doesn't Return Any Data
          • XL97: Alert for Previous Version Displays Using OnSave Property
          • XL97: All Input Messages Appear in the Same Location
          • XL97: All Views Listed in Custom Views and Report Manager
          • XL97: ALT Key Stuck On After Running Macro with Copy Method
          • XL97: ALT+DOWN ARROW Doesn't Invoke AutoComplete
          • XL97: Always Create Backup Fails on Internet FTP Location
          • XL97: Application Error Updating OLE Link
          • XL97: Array Formula Using Merged Cells Calculated Incorrectly
          • XL97: Attached Toolbar Is Not Saved in 5.0/95 File Format
          • XL97: Auditing Tools Clear Undo/Redo Stack
          • XL97: Auto_Close Macros Run When You Use Application.Quit
          • XL97: AutoCalculate Is Inconsistent with Hidden Rows or Columns
          • XL97: AutoComplete Fails After 102 Rows Past Last Occurrence
          • XL97: AutoComplete May Not Work
          • XL97: AutoCorrect May Not Capitalize First Word in Sentence
          • XL97: AutoCorrect Stops After 255 Characters
          • XL97: AutoFill Limited to 255 Characters
          • XL97: AutoFill Not Working with 11 or More Characters
          • XL97: Automatic Styles and Apply Styles Do Not Apply Format
          • XL97: Automation Example with MS Word and MS Outlook
          • XL97: AutoReturn Moves the Active Cell in a Multicolumn List
          • XL97: AutoShapes Change Location After You Enter Text
          • XL97: Background Turns Black Pasting Object in 3-D Chart Floor
          • XL97: Binder: Virus Warning May Appear More Than Once
          • XL97: Bitmap Image Shrinks When Pasted on a Toolbar Button
          • XL97: Black and White Printer Prints Colored Lines as Grayscale
          • XL97: Blank Workbook Remains Open Using Custom (Book.xlt)
          • XL97: Border Color of Lines Returns Incorrect RGB Value
          • XL97: Borders Appear in Printed Workbook Using Track Changes
          • XL97: Borders Below Row 65536 Do Not Print
          • XL97: Borders Near Hidden Cells May Not Be Displayed or Printed
          • XL97: Borders Printed Black with 'Black and White' Selected
          • XL97: Borders Removed When You Remove Hyperlink from a Cell
          • XL97: Both Diagonal Cell Borders Use Same Line Style
          • XL97: BottomRightCell/TopLeftCell Incorrect with Merged Cell
          • XL97: Button Format Carries Over to MS Excel 5 Dialog Sheet
          • XL97: Calculate Message Remains If 65,536 Formula References
          • XL97: Calculating Worksheet Causes Crash After Running Module
          • XL97: Calculation of Formula in Formula Bar Returns #VALUE!
          • XL97: Calculation Stops at Zero Percent or Occurs Very Slowly
          • XL97: Callout Adjustment Handle Disappears When Moved
          • XL97: Can't Drag Graphics from Internet Explorer
          • XL97: Can't Move to Partially Hidden Merged Cells with Keyboard
          • XL97: Can't Select Cells When Using Netscape Navigator
          • XL97: Cannot Activate a Worksheet While Inserting Control
          • XL97: Cannot Add a Data Table to Some Charts
          • XL97: Cannot AutoFit Rows/Columns That Contain Merged Cells
          • XL97: Cannot Change Fill Color for Walls or Floor on 3-D Chart
          • XL97: Cannot Change Gridlines on Surface Chart
          • XL97: Cannot Change Value for Form Control on a Worksheet
          • XL97: Cannot Clear 'Sort by' List in Query Wizard
          • XL97: Cannot Click Once to Create Arrows and Lines
          • XL97: Cannot Drag Cells When You Use AutoFilter
          • XL97: Cannot Drag Drawing Objects Between Worksheets
          • XL97: Cannot Drag Drawing Objects onto Windows Desktop
          • XL97: Cannot Drag Page Breaks in Page Break Preview
          • XL97: Cannot Drag UserForm Control onto a Worksheet
          • XL97: Cannot Edit Automation Objects in Microsoft Excel Viewer
          • XL97: Cannot Modify or Delete Custom Menus
          • XL97: Cannot Open File After Pasting More Than 2000 Characters
          • XL97: Cannot Paste Drawing Object from Microsoft Excel Viewer
          • XL97: Cannot Paste Picture into UserForm
          • XL97: Cannot Record External Data Range Properties
          • XL97: Cannot Rename Worksheet to History
          • XL97: Cannot Reset a Column to the Standard Width
          • XL97: Cannot Save Workbook After Losing Network Connection
          • XL97: Cannot Scroll to Last Item in a List Box
          • XL97: Cannot Show Scenario That Includes Merged Cells
          • XL97: Cannot Shut Down Windows While Excel Viewer is Running
          • XL97: Cannot Stop Macro After Switching to Other Program
          • XL97: Cannot Undo Background in Text Box on a Chart Object
          • XL97: Cannot Use Edit Query Button on Sheet With Web Query
          • XL97: Cannot Use External References with Data Validation
          • XL97: Cannot Use Form on FrontPage Personal Web Server
          • XL97: Cannot Use Object Box When Multiple Controls Are Selected
          • XL97: Cannot Use User-Defined Function in Demand-Loaded Add-in
          • XL97: Cannot Use Web Data Source as PivotTable Data
          • XL97: Cannot Use xlDisplayShapes with DisplayDrawingObjects
          • XL97: Cell Displays Zero with Angled Text and Small Row Height
          • XL97: CELL Function with 'filename' No Longer Volatile
          • XL97: Cells in Protected Worksheet May Be Unmerged
          • XL97: Cells That Contain User-Defined Functions Not Recalculated
          • XL97: Certain Functions Calculate Differently in Early Versions
          • XL97: Change Event for ActiveX Control Runs Unexpectedly
          • XL97: Change in ADD.MENU Macro Position Argument
          • XL97: Changes May Be Lost When Shared Workbook on FTP Server
          • XL97: Changes Not Saved When Workbook Is Opened in MS Outlook
          • XL97: Changes to Menu Bar May be Lost After Closing a Workbook
          • XL97: Changing Alignment and Indent Causes Text to Disappear
          • XL97: Changing Chart Type Changes X-Axis
          • XL97: Characters Lost Saving to Excel 5.0/95 File Format
          • XL97: Chart Activation with Macro Changes Selection
          • XL97: Chart Axis Changes Scale Opening Earlier Version Workbook
          • XL97: Chart Border Is Too Large or Small After Using Paste Link
          • XL97: Chart Data Labels Linked to Formulas Are Not Updated
          • XL97: Chart Data Range Disappears After Changing Series
          • XL97: Chart Display Options Change According to Page Setup
          • XL97: Chart Elements Are Resized When Workbook Is Saved
          • XL97: Chart Embedded on Chart Sheet Does Not Preview
          • XL97: Chart Exported as a Graphic File May Be Truncated
          • XL97: Chart in Worksheet Resized After Pasting into Word
          • XL97: Chart Is Reduced to a Small Size After Formatting Legend
          • XL97: Chart Series Doesn't Use Removed Secondary Axis Scale
          • XL97: Chart Titles with Multiple Lines Display Only One Line
          • XL97: Chart Trendline Formula Is Inaccurate
          • XL97: Chart Truncated After Performing Paste Link Operation
          • XL97: Clicking Exit Design Mode Switches to Microsoft Excel
          • XL97: Clicking Microsoft Excel on Taskbar Does Not Work
          • XL97: Clicking Row or Column Divider Causes Recalculation
          • XL97: Clicking Undo Last May Cause Error
          • XL97: Close Button Is Dimmed After Groupwise Is Installed
          • XL97: Cloud Callout Is Not Printed Correctly on HP Printer
          • XL97: Column and Area Chart Y Axis Is Scaled in Excel 97
          • XL97: Columns Are Transparent When Printed in Black and White
          • XL97: Columns Missing from Chart on Printout
          • XL97: Comment Changes Are Not Saved in Shared Workbook
          • XL97: Comment Formatting May Be Lost When You Share a Workbook
          • XL97: Comments Are Resized Unexpectedly
          • XL97: Comments May Be Obscured by Freeze Panes
          • XL97: Comments May Not Be Printed as Expected
          • XL97: Comparison Value Changed from Fraction to Serial Number
          • XL97: Conditional Compilation Code Lost With 5.0/95 Format
          • XL97: Conditional Format Applies Format for First Condition
          • XL97: Conditional Format Reapplied After Inserting Cut Cells
          • XL97: Conditional Formats May Not Work on Rich Text Cells
          • XL97: Conditional Formatting Not Saved When Saving as HTML
          • XL97: Conditional Formatting Unexpectedly Applied to Text
          • XL97: Conditional Number Format Not Shifted in Group Edit Mode
          • XL97: Constrained Line or Arrow Pastes Incorrectly in NT 4.0
          • XL97: Context-Sensitive Help Not Available for Some Controls
          • XL97: Control in Linked File Is Not Updated When Changed
          • XL97: Control Toolbox Toolbar Disappears
          • XL97: Controlling Events in an Automation Server
          • XL97: Convert to MS Access Menu Command May Work Incorrectly
          • XL97: Converting Microsoft Excel 5.0 or 7.0 Dialogs to Excel 97
          • XL97: Copied and Pasted Dates Are Changed by 100 Years
          • XL97: Copy and Paste from Access to Excel May Generate Errors
          • XL97: Copy From Object Browser May Not Copy Named Arguments
          • XL97: Copy Picture Loses Lower-Right Pixel of Gridline
          • XL97: Copying ActiveX Control Loses Code Behind Control
          • XL97: Copying and Pasting Noncontiguous Range Loses Formulas
          • XL97: Copying Shapes Cancels Selection of Shape
          • XL97: Copying Shared Workbook Causes Multiple Users to Be Listed
          • XL97: Copying Sheet Does Not Preserve Drawing Object Numbers
          • XL97: Copying Worksheet into Workbook Deletes Defined Name
          • XL97: COUNTA Function Changed to COUNT
          • XL97: Countif Function May Not Work with Blank Cells
          • XL97: Crash Inserting Wang Image Control on Alpha-based Computer
          • XL97: Crash on Exit After Terminating DDE Connection
          • XL97: Crash Opening Password Protected 5.0/95 File
          • XL97: Crash Saving Workbook If Module Name Contains Equal Sign
          • XL97: Crash When Chart Gallery File Is Password Protected
          • XL97: Created Date Is Not Updated When Saving as a New File
          • XL97: CTRL + Autofill Does not Increment Values
          • XL97: CTRL+ALT+TAB Does Not Insert Tab into Active Cell
          • XL97: CTRL+SHIFT+' Keyboard Shortcut Limited to 1,024 Characters
          • XL97: Cursor and Cell Disappear Editing Text in Cell
          • XL97: Custom Chart Types May Appear Distorted
          • XL97: Custom Function Is Not Recalculated with Intersection
          • XL97: Custom Function May Not Calculate Expected Value
          • XL97: Custom Function Returns #VALUE! If Returning Large Array
          • XL97: Custom Toolbars Are Lost After Uninstalling Add-In
          • XL97: Customize Command Is Not Available in Customize Dialog Box
          • XL97: Customize Dialog Stays Behind Toolbars When Clicked
          • XL97: Customizing Menus and Toolbars Without Customize Dialog
          • XL97: Cutting and Pasting Cells Causes Invalid Page Fault
          • XL97: DAO Error in Step 3 of Web Form Wizard
          • XL97: Dashed Series Lines Appear Solid in Excel 97
          • XL97: Data in Hidden Columns Is Not Deleted
          • XL97: Data Labels Appear on Axis and Not Inside Chart
          • XL97: Data Not Returned from Query Using ORACLE Data Source
          • XL97: Data Overwritten Copying More Than 31,737 Characters
          • XL97: Data Returned from Only One Table Using Query Wizard
          • XL97: Data Table May Not Be Recalculated
          • XL97: Data Truncated to 255 Characters with Excel ODBC Driver
          • XL97: Data Validation Is Only Accurate with Manual Entry
          • XL97: Data Validation Message May Not Disappear
          • XL97: Date Format Is Not Retained in Parameters Dialog Box
          • XL97: Dates Made Consecutive When Charting in Microsoft Excel
          • XL97: Deactivate Event Doesn't Occur After Moving Sheet
          • XL97: Defined Name Formula Is Not Updated After Sort
          • XL97: Defined Name Is Used by Form Created in Web Form Wizard
          • XL97: Defined Names Display #REF! After Clicking Undo
          • XL97: Defined Names Saved Incorrectly in Lotus 1-2-3 Format
          • XL97: Delete Links Wizard Available
          • XL97: Deleted 4.0 Macro Function Appears in Function Wizard
          • XL97: Deleting Cells with a For Each...Next Loop
          • XL97: Deleting Sheet and Closing Workbook Causes Crash
          • XL97: Description and Examples of Data Validation
          • XL97: Destructor for ActiveX Control Is Not Called on Exit
          • XL97: DFunctions Return Errors When Database Has Too Many Rows
          • XL97: Diagonal Border Disappears with Rotated Text
          • XL97: Diagonal Gradient Fill May Not Be Printed Correctly
          • XL97: Display Becomes Garbled When Scrolling Through Workbook
          • XL97: Document Disappears After Clicking Hyperlink
          • XL97: Double-Clicking Hyperlink May Activate Edit Mode
          • XL97: Double-Clicking in Explorer Doesn't Open Workbook
          • XL97: Double-clicking Link Formula Doesn't Open Workbook
          • XL97: Double-Clicking Workbook in MS Exchange Causes Error
          • XL97: Dr. Watson Error Inserting Map into Worksheet
          • XL97: Drawing Object Names Increment Incorrectly
          • XL97: Drawing Objects and AutoShapes Printed Incorrectly
          • XL97: Drawing Objects Are Not Saved on User-Defined Chart
          • XL97: Duplicate Toolbars Listed in Customize Dialog Box
          • XL97: Editing Chart Object Causes Illegal Operation
          • XL97: Ejecting Removable Media Causes Excel Page Fault
          • XL97: Embedded Chart Changes Size When Copied and Pasted
          • XL97: Embedded Links to Other Workbooks Cause Error When Exiting
          • XL97: Embedded Object May Be Deleted from the Worksheet
          • XL97: Embedded Worksheet Object Stops After Running Macro
          • XL97: Entire Text File Appears In a Merged Cell
          • XL97: Err Msg: Solver: An Unexpected Internal Error Occurred
          • XL97: ErrMsg to Fix Formula When Comma Is Decimal Separator
          • XL97: ErrMsg: '
          • XL97: ErrMsg: '? Is an Invalid Key' When Opening a File
          • XL97: Error '32813' When Creating Reference to Solver Add- in
          • XL97: Error 2015 or Type Mismatch Using Evaluate with Dates
          • XL97: Error Activating Chart Not on the Active Worksheet
          • XL97: Error Activating Worksheet That Contains Controls
          • XL97: Error Adding Field to Query Using Query Wizard
          • XL97: Error Appears or View Not Retained Printing Reports
          • XL97: Error Appears When Changing Chart Location with a Macro
          • XL97: Error Clicking Macro Button in Internet Browser
          • XL97: Error Clicking Pick From List in Cell with Many Characters
          • XL97: Error Clicking Save As HTML
          • XL97: Error Closing Workbooks That Contain DDE Links
          • XL97: Error Creating Circular References Between Instances
          • XL97: Error Creating Hyperlink with Chart Sheet in Workbook
          • XL97: Error Creating Web Page with Option Base 1 Setting
          • XL97: Error Dragging Excel File into Internet Explorer
          • XL97: Error Dragging Merged Cell Over Another Merged Cell
          • XL97: Error Editing Chart Linked to Closed Workbook
          • XL97: Error Evaluating Natural Language Formula
          • XL97: Error Filling Large Numbers of Array Formulas
          • XL97: Error Formatting Cells on WinBook XP5 Laptop Computer
          • XL97: Error Formatting Chart Data Label Border
          • XL97: Error Inserting ActiveX Object in a Worksheet
          • XL97: Error Inserting or Deleting Rows or Columns After Undo
          • XL97: Error Looping Through Add-ins in a Custom Function.
          • XL97: Error Message Appears After You Edit an Embedded File
          • XL97: Error Message Appears Creating Custom Chart Type
          • XL97: Error Message Appears Formatting Chart Data Labels
          • XL97: Error Message Appears Setting Zoom Below 50%
          • XL97: Error Message Appears Sorting a Field in a PivotTable
          • XL97: Error Message Calculating Custom Function in Formula Bar
          • XL97: Error Message Running Recorded Macro That Resizes a Line
          • XL97: Error Messages Appear Clicking Options on Tools Menu
          • XL97: Error Opening File from MS Internet Explorer Address Bar
          • XL97: Error Opening Password-Protected File with Merged Cells
          • XL97: Error Opening Workbook That Contains MS Access Table
          • XL97: Error Opening Workbook That Contains Very Long Strings
          • XL97: Error Opening Workbook That Is Modified By Using DAO
          • XL97: Error or Chart Disappears When You Open a Lotus WK4 File
          • XL97: Error Pressing TAB with Transition Navigation Keys Option
          • XL97: Error Printing Microsoft Excel Section in a Binder
          • XL97: Error Printing Page Number Greater Than 32,767
          • XL97: Error Quitting WordPad Document That Contains Worksheet
          • XL97: Error Rolling Wheel on Mouse While Editing Formula
          • XL97: Error Running Macro That Inserts Control into UserForm
          • XL97: Error Running Macro To Modify Cell Comments
          • XL97: Error Running Macro to Modify Shape Text
          • XL97: Error Running Wizard When a Control Is Active
          • XL97: Error Saving or Closing Files with Defined Names
          • XL97: Error Saving to FTP Site Using Wizards
          • XL97: Error Sending Workbook If Mail Program Is Offline
          • XL97: Error Setting AxisGroup Property of Series Class
          • XL97: Error Submitting Data by Using Web Form Wizard Worksheet
          • XL97: Error Updating Link to Web Document
          • XL97: Error Updating or Modifying Link to DDE Server Program
          • XL97: Error Using ActiveX Control on Web Form
          • XL97: Error Using Add-In Function in Conditional Formatting
          • XL97: Error Using Canon MultiPASS C2500 or Bitware Fax Driver
          • XL97: Error Using Evaluate and User-Defined Add-In Function
          • XL97: Error Using Natural Language Formula in a Macro
          • XL97: Error Using Virus Search Add-In on Alpha-based PC
          • XL97: Error Viewing a Web Page Containing an Excel Workbook
          • XL97: Error Viewing Properties of Visual Components Control
          • XL97: Error When Dragging Embedded Chart into Microsoft Word
          • XL97: Error When Inserting Portfolio 7.0 Object into Worksheet
          • XL97: Error When Sorting a Range Containing Merged Cells
          • XL97: Error When Using Validation Drop-Down List Box
          • XL97: Error When You Display Form Created by Web Form Wizard
          • XL97: Errors Activating Embedded Object Containing PivotTable
          • XL97: Errors After Copying Worksheet with Auditing Arrows
          • XL97: Errors Appear When Opening Web Query File on FTP Server
          • XL97: Errors Appear When Using an ODBC Text Data Source (DSN)
          • XL97: Errors If Module Contains Duplicate Subroutine Names
          • XL97: Errors in Web Form Wizard Saving Form to FrontPage
          • XL97: Errors Opening Workbook from Windows Explorer
          • XL97: Errors Printing Filled AutoShapes to PostScript Printer
          • XL97: Errors Using Quit Method with Virus Search Add-in Loaded
          • XL97: Euro Currency Character Is Not Displayed Correctly
          • XL97: Euro Symbols Deleted After File Saved in Excel 98
          • XL97: Excel Articles Available by E-Mail: Components
          • XL97: Excel Articles Available by E-Mail: Functionality
          • XL97: Excel Articles Available by E-Mail: User Interface
          • XL97: Excel Articles Available by E-Mail: VBA
          • XL97: Excel Crashes When Using ActiveX Control That Fires Events
          • XL97: Excel File Deleted from Server When Logging Off Windows NT
          • XL97: Excel File Is Deleted from Server When Logging Off NT
          • XL97: Excel Hangs Opening Scenario Manager on a Protected Sheet
          • XL97: Excel Object Is Not Closed After Running Macro
          • XL97: Excel Objects Appear Truncated
          • XL97: Excel Quits When You Scroll in Workbook on IBM 770 Laptop
          • XL97: Exchange Folder Tool Doesn't Appear After Dragging
          • XL97: Exploded Slice of 3-D Pie Chart Appears Incorrectly
          • XL97: Export Method Code Example in Help Is Incorrect
          • XL97: Extended Characters in Text or Property Inaccurate
          • XL97: External Data Range Property Not Saved with Workbook
          • XL97: F1 in Custom XLM Dialog Box Displays Office Assistant
          • XL97: F4 Key Does Not Change Cell Formula Reference
          • XL97: File Conversion Wizard Included with MS Excel 97
          • XL97: File may not Open From the Favorites Menu
          • XL97: File Name in Formula Doesn't Appear Correctly
          • XL97: File Password Lost Moving File to an Exchange Folder
          • XL97: File Size Increases After Launching Visual Basic Editor
          • XL97: File Size Increases When You Save the File in 97 Format
          • XL97: File with Many Cell Notes Opens Slowly
          • XL97: Files Installed with the Stand-Alone Version of MS Excel
          • XL97: Fill Colors May Be Saved Incorrectly with WK3 File
          • XL97: Fill Is Printed Outside Object on Canon BJC Printers
          • XL97: Fill Values Fills Series with Merge Cells Formatting
          • XL97: Financial Functions Return #NUM! If Dates After Year 2078
          • XL97: FindPrevious Method Does Not Support Discontiguous Range
          • XL97: Floating Toolbars Disable Animation Feedback
          • XL97: Foreign Object Library Files (.olb) for MS Excel Available
          • XL97: Format Cells Sample May Display Number Signs
          • XL97: Format not Applied on Grouped Sheet with Merge Cells
          • XL97: Formats May Not Be Applied to Pasted Merged Cell
          • XL97: Formatting and Cells May Be Lost When Pasting Merged Cells
          • XL97: Formula AutoCorrect Inserts Wrong R1C1 Reference
          • XL97: Formula Errors Appear After Updating PivotTable
          • XL97: Formula Is Not Recalculated After Paste Special Operation
          • XL97: Formulas Not Displayed Properly with Data Table in Sheet
          • XL97: Formulas Not Recalculated After Moving Worksheet
          • XL97: Formulas Not Refreshed After Data Consolidation
          • XL97: Formulas with Range-Style Cell Reference Are Not Updated
          • XL97: Forward and Back Buttons May Not Work with Hyperlinks
          • XL97: Forward Button on Web Toolbar May Not Be Available
          • XL97: Four-Digit Years May Display Only Two Digits
          • XL97: Functions in Filled Formulas May Not Be Recalculated
          • XL97: General ODBC Error Running Macro from Excel for Macintosh
          • XL97: GET.DOCUMENT Function Returns Incorrect Document Name
          • XL97: Gridlines Are Displayed Incorrectly in Print Preview
          • XL97: Group Name in Name Box Does Not Update
          • XL97: Grouping ActiveX Option Buttons on a Worksheet
          • XL97: Hang While Editing Formula Directly in a Cell
          • XL97: Hidden or Blank Rows or Columns Are Displayed in HTML File
          • XL97: How to Change the Depth of a 3-D Surface Chart
          • XL97: How to Change the Font in a Comment
          • XL97: How to Control Object Placement in Microsoft Excel 97
          • XL97: How to Convert an Add-in File into a Workbook
          • XL97: How to Create a Conditional Format to Hide Errors
          • XL97: How to Create a Pie Of Pie Chart or a Bar Of Pie Chart
          • XL97: How to Create a Report Template
          • XL97: How to Create an Add-in File in Microsoft Excel 97
          • XL97: How to Delete, Restore, and Edit Menu Items Manually
          • XL97: How To Display a Progress Bar with a UserForm
          • XL97: How to Import Web Page Tables into Microsoft Excel
          • XL97: How to Link to a Particular Worksheet from a Web Page
          • XL97: How to Minimize Metadata in Excel Workbooks
          • XL97: How to Modify the Number of Undo Levels
          • XL97: How to Obtain and Install the SYLK File Security Update
          • XL97: How to Obtain the Excel 97 Auto Recalculation Patch
          • XL97: How to Plot Values Against a Recommended Range
          • XL97: How to Programmatically Change the Project Name Property
          • XL97: How to Programmatically Perform a Web Query
          • XL97: How to Programmatically Save a Worksheet as HTML
          • XL97: How to Remove Individual AutoFilter Drop-Down Lists
          • XL97: How to Rename a Chart Using Name Box
          • XL97: How to Restrict Numeric Entry to Only One Cell in a Range
          • XL97: How to Save Files in Other Formats
          • XL97: How to Sort Cells Without Sorting Linked Cells
          • XL97: How to Specify Dynamic Web Query Parameters
          • XL97: How to Use a Toolbar Settings File from a Network Share
          • XL97: How to Use a Web Data Source for a PivotTable
          • XL97: How to Use Custom Toolbars in Excel5.xlb
          • XL97: How to Use Data Validation to Prevent Duplicate Entries
          • XL97: How to Use Natural Language Formulas
          • XL97: How to Use the ApplyCustomType Method to Format Charts
          • XL97: How to Use the GetPivotData Worksheet Function
          • XL97: How to Use the Internet Assistant Wizard
          • XL97: How to Use the PivotTable AutoSort Feature
          • XL97: How to Use Wildcards in Parameter Queries
          • XL97: How to View Sample Chart with the Keyboard
          • XL97: Html.xla Add-in May Delete All Files in a Folder
          • XL97: Hyperlink Does Not Work or Open in Separate Window
          • XL97: HYPERLINK Doesn't Work If Second Argument Returns Error
          • XL97: Hyperlinks to Charts Fail After Saving to FrontPage Web
          • XL97: Hyphens and Apostrophes Sorted After Alphabetic Letters
          • XL97: Identical Patterns May Be Printed Differently
          • XL97: Illegal Operation Closing File When VBE Is Visible
          • XL97: Illegal Operation Error Using ListBox Control
          • XL97: Illegal Operation Occurs While Recalculating Workbook
          • XL97: Illegal Operation Refreshing Data in PivotTable
          • XL97: Illegal Operation Saving Workbook
          • XL97: Illegal Operation Using Chart Wizard
          • XL97: Image Control on UserForm Is Not Updated with Click Event
          • XL97: Implicitly Setting Value of Range Object Crashes Excel
          • XL97: Imported Toolbox Page Loses Caption and Tip Text
          • XL97: Inconsistent Results Using Natural Language Formulas
          • XL97: Incorrect Cell Range Selected When Activating Excel Object
          • XL97: Incorrect Definitions Displayed in Object Browser
          • XL97: Incorrect Field Names Appear in PivotTable Field Dialog
          • XL97: Incorrect Formula Using FormulaR1C1 When Chart Active
          • XL97: Incorrect Printer May Be Used When Printing from Macro
          • XL97: Incorrect Printout on HP Color LaserJet PostScript
          • XL97: Incorrect Workbook Saved from Visual Basic Editor
          • XL97: Indent Option Not Available with General Alignment
          • XL97: Indexes for Methods and Collections Are Rounded
          • XL97: Input Range Error Using Anova Analysis Tool
          • XL97: Insert and Delete Methods of Characters Class May Fail
          • XL97: Inserted Objects on Charts Are Not Redrawn Correctly
          • XL97: Insertion Code for Internet Assistant Is Case Sensitive
          • XL97: IntelliMouse Cannot Zoom Beyond 100%
          • XL97: Internet Assistant Update Does Not Include XLHTML.DLL
          • XL97: Internet Assistant Wizard Doesn't Recognize All Files
          • XL97: Invalid Page Fault After Pasting Control
          • XL97: Invalid Page Fault Closing WK4 File
          • XL97: Invalid Page Fault in Msqry32.exe with Long File DSN Name
          • XL97: Invalid Page Fault Occurs When You Use Auto Outline
          • XL97: Invalid Page Fault Opening Workbook Sent in E-mail
          • XL97: Invalid Page Fault Saving a Workbook or Add-In
          • XL97: Invalid Page Fault When Opening Template File
          • XL97: Invalid Page Fault When Selecting Shared Workbook Feature
          • XL97: Invalid Page Fault When You Assign Macro to Custom Menu
          • XL97: Invalid Site Error Using Relative Hyperlink Path
          • XL97: January 1 May Appear as February 1 in a Date
          • XL97: Keyboard Input for RichTextBox Is Entered in a Cell
          • XL97: Left, Top Sides of Chart Missing After Pasting Bitmap
          • XL97: Len Function Returns Only 1024 Characters in Cell
          • XL97: Letters Available as Keyboard Shortcuts for Macros
          • XL97: Limit of Natural Language Formulas per Worksheet
          • XL97: Limits of PivotTables in Microsoft Excel 97
          • XL97: Line and Border Are Not Aligned When Printed or Viewed
          • XL97: Line Chart with Smoothed Line Selected May Cause Error
          • XL97: Link in Merged Cell Is Not Recalculated on Copied Sheet
          • XL97: Link to File on Network Is Not Updated Correctly
          • XL97: Linked Cell Changes Before Sheet Is Completely Calculated
          • XL97: Linked Files Updated More Slowly Than in Earlier Versions
          • XL97: Linked Formula May Return a Maximum of 255 Characters
          • XL97: Linked Picture of Cells Changes Size with Print Quality
          • XL97: Links In Microsoft Excel 4.0 Workbooks Are Incorrect
          • XL97: Links in Shared Workbook Return #REF! Error
          • XL97: Links to Excel 4.0 Macro Sheets Do Not Update
          • XL97: List Box Click Event May Not Occur
          • XL97: List Box Doesn't Work Correctly When Workbook Is Hidden
          • XL97: List of Errors That Formula AutoCorrect Detects
          • XL97: List of Fixed Problems in MS Excel 97 for Windows, SR-1
          • XL97: ListBox Control Is Resized with Zero Column Width
          • XL97: LOOKUP Returns Incorrect Value When Source File Is Closed
          • XL97: Lotus 1-2-3 Dates Are Converted to Number
          • XL97: Lotus 1-2-3 Version 5.0 File wth Bitmap Hangs MS Excel 97
          • XL97: Lotus Macro Interpreter Menus May Not Work as Expected
          • XL97: Macro Command Menubars(xlWorkBook) Is Not Valid
          • XL97: Macro Doesn't Recognize OLEObject Name Property
          • XL97: Macro Error Creating Custom Shortcut Menu Item
          • XL97: Macro Error Using Show Method with AutoShape Selected
          • XL97: Macro Error When You Use GET.TOOLBAR Command
          • XL97: Macro Performance Slow When Page Breaks Are Visible
          • XL97: Macro Recorder Doesn't Record Some Menu Commands
          • XL97: Macro That Inserts Formula Returns #NAME?
          • XL97: Macro to Tile Windows Does Not Work with Minimized Window
          • XL97: Macro Virus Warning Appears Opening File Without Macro
          • XL97: Macro Virus Warning Appears Opening File Without Macros
          • XL97: Macro Virus Warning Does Not Appear Opening SYLK File
          • XL97: Macro97.exe File Available on Online Services
          • XL97: Making the Active Row Bold Using SelectionChange Event
          • XL97: Manual Page Break Does Not Move in Excel 5.0/95 File
          • XL97: Maximum Array Size in Microsoft Excel 97
          • XL97: Memory Errors Appear When You Calculate a Custom Function
          • XL97: Menu Editor and Make Add-In Dialog Boxes Cause Error
          • XL97: Merge Workbooks Not Same as Lotus 1-2-3 '/File Combine'
          • XL97: Microsoft Excel 97 Viewer Cannot Open Lotus Files
          • XL97: Microsoft Excel Inserts a Defined Name in Formula
          • XL97: Microsoft Excel Toolbars Appear in the Visual Basic Editor
          • XL97: Microsoft Graph Object Displayed Differently in Excel 97
          • XL97: Microsoft Query 97 Does Not Support User and System DSNs
          • XL97: Missing Totals When Using Multilevel Subtotals
          • XL97: Module Sheet Tab Visible After Saving in 5.0/95 Format
          • XL97: Most Recently Used List Is Not Updated
          • XL97: MRU Displays UNC Path to File on Mapped Drive
          • XL97: MS Excel Does Not Resume Calculation After Halting
          • XL97: MS Excel Hangs with UserForm Displayed in Binder
          • XL97: MS Map May Hang When You Insert Canadian Postal Codes
          • XL97: Must Restart to Change the Format Painter Mouse Pointer
          • XL97: Name Box Functionality Has Changed
          • XL97: Named Locations in Hyperlinks Missing After Saving as HTML
          • XL97: Natural Language Formula Returns Incorrect Results
          • XL97: Natural Language Formula Returns Zero Value
          • XL97: Natural Language Formulas Return Error
          • XL97: Negative Number Times Null or Zero Produces Negative Zero
          • XL97: New A Functions in Microsoft Excel 97
          • XL97: New Database Query (.dqy) File Format
          • XL97: New Text Box Created When Text Box in Chart Linked to Cell
          • XL97: New UsedRange Property Behavior
          • XL97: NewSheet Event Not Triggered with Sheet.xlt
          • XL97: NLFs that use Restricted Labels Return #VALUE! Error
          • XL97: No 'Center Across Columns' Toolbar Button
          • XL97: No Combination List-Edit Control for UserForms
          • XL97: No Help on Link for Formatting Can't Be Converted to HTML
          • XL97: No Info Window in Microsoft Excel 97
          • XL97: No Warning with Incorrect Data Validation Setting
          • XL97: No WorkGroup Toolbar in Microsoft Excel 97
          • XL97: Not All Menu Items Appear for Other Users
          • XL97: Not All Workbooks Print When Printing from Explorer
          • XL97: Number Formats Lost Error Opening HTML File
          • XL97: Number Signs (###) Displayed in Cells of a Worksheet
          • XL97: Number Signs (#) May Appear in Recorded Macros
          • XL97: Objects Are Printed Incorrectly on HP DeskJet 1600c
          • XL97: Objects in Chart May Not Appear in Sample Chart
          • XL97: Objects May Not Appear After Copying Worksheet
          • XL97: Objects or Borders Are Not Printed Correctly
          • XL97: Odd Behavior Using Format Painter and Merged Cells
          • XL97: Offset of Nonadjacent Range Returns Incorrect Results
          • XL97: Only 1,024 Characters Are Displayed in a Cell
          • XL97: Only One Character Is Returned from a Declared Function
          • XL97: OnSave Property Doesn't Run Using Save As Command
          • XL97: Open Event Macro May Not Activate a Worksheet
          • XL97: Opening Excel File on MAPI Folder Updates Modify Date
          • XL97: Opening Lotus 1-2-3 File May Run Macro Without Warning
          • XL97: Opening Workbook in Internet Explorer Does Not Open Viewer
          • XL97: Option Button Link to Cell Is Lost After Copy and Paste
          • XL97: Options Not Available in Macro Options Dialog Box
          • XL97: Overlapping Formatted Cell Border Behavior
          • XL97: Overview and History of Excel Patches
          • XL97: Overview of the Built-In Chart Types
          • XL97: Page Break Button on Main Toolbar Causes Excel to Crash
          • XL97: Page Fault Adding Shadow to Series in Surface Chart
          • XL97: Page Fault After Saving Microsoft Excel 4.0 Worksheet
          • XL97: Page Fault Clicking Sheet Tab When Formula Bar Is Active
          • XL97: Page Fault Copying Shared Formulas and Opening Workbook
          • XL97: Page Fault Copying Worksheet That Contains a Chart
          • XL97: Page Fault Creating RealAudio ActiveX Control Object
          • XL97: Page Fault Deleting a Record with the Data Form
          • XL97: Page Fault Displaying Macro Options Dialog Box in Macro
          • XL97: Page Fault Editing Formula That Returns #NULL! Error
          • XL97: Page Fault Occurs After Filling Formatting and Saving
          • XL97: Page Fault Occurs Pasting Input Cells for a Data Table
          • XL97: Page Fault Opening Workbook with a Merged Column
          • XL97: Page Fault or Violation Clicking Options on the Tools Menu
          • XL97: Page Fault Pasting Array Formula Between Workbooks
          • XL97: Page Fault Pressing ENTER After Clicking Camera Tool
          • XL97: Page Fault Pressing HOME with Transition Navigation Keys
          • XL97: Page Fault Printing to Generic / Text Only Printer
          • XL97: Page Fault Setting ProtectGoalSeek Property of Chart
          • XL97: Page Fault Starting MS Excel After installing Add-in
          • XL97: Page Fault Using Formula Containing Boolean Functions
          • XL97: Page Fault Viewing Chart in Print Preview
          • XL97: Page Fault When Formatting a Series in a Chart
          • XL97: Page Numbers in 'Now Printing' Dialog May Skip Numbers
          • XL97: Parameter Query Is Case Sensitive
          • XL97: Paste Function Buttons Missing in Formula Palette
          • XL97: Pasting Entire Column Is Slower than in Earlier Versions
          • XL97: Pasting in Merged Cell Duplicates Copied Cells
          • XL97: Patch Available for Excel 97 Virus Warning Vulnerabilities
          • XL97: Patch Available for Excel CALL Vulnerability
          • XL97: Picture Linked to Cell Does Not Immediately Update
          • XL97: Pie Chart Slices Don't Match Legend in Printout
          • XL97: PivotTable Appears Incorrect If Data Contains Merged Cell
          • XL97: PivotTable Items Missing When Fields Are Pivoted
          • XL97: PivotTable Report Unavailable with Parameter Query
          • XL97: Pointer Does Not Change into Hand with ActiveX Controls
          • XL97: Pointer Not Changed to Format Painter Pointer
          • XL97: Pressing ALT+F11 May Not Start the Visual Basic Editor
          • XL97: Preview Available on Blank Sheet with Merged Cells
          • XL97: Print Area in Custom View from Earlier Version Is Lost
          • XL97: Print Area with Merged Cells May Be Set Incorrectly
          • XL97: Print Preview of Sheet with GIF Causes Invalid Page Fault
          • XL97: Print Titles with Merged Cells Add Columns or Rows
          • XL97: Printer Unavailable Error on Print or Page Setup
          • XL97: Printing After Deleting ActiveX Control Causes IPF
          • XL97: Printing at Non-Square Resolution Distorts AutoShapes
          • XL97: Printing Formatted Text from a RichTextBox Control
          • XL97: Printing or Faxing Entire Workbook Sends Multiple Jobs
          • XL97: Printing Problem When Print Titles Contain Borders
          • XL97: Problem with ActiveX Control After Moving Sheet
          • XL97: Problems Importing Files from Quattro Pro 7.0
          • XL97: Problems Printing Unicode (Extended) Characters
          • XL97: Problems Setting Column Headings in ListBox Control
          • XL97: Problems Using ColorIndex to Set Color of Borders
          • XL97: Problems Using Inserted Control in Another Window
          • XL97: Problems Using Office Assistant in Netscape Navigator
          • XL97: Problems Using TripleState Property for OptionButton
          • XL97: Problems When AutoFilling Very Large Time Frames
          • XL97: Problems When Macro Opens/Saves Text Files with Dates
          • XL97: Problems When Selecting Error Bars With a Macro
          • XL97: Problems When Using Different Print Quality for Sheets
          • XL97: Problems When you AutoFormat an Entire Worksheet
          • XL97: Problems with Arguments of PasteSpecial Method
          • XL97: Products That Qualify for the Microsoft Excel Upgrade
          • XL97: Protected Worksheet Allows You to Paste Data into Cells
          • XL97: Purpose of the PivotTable Optimize Memory Option
          • XL97: Queries No Longer Work After Upgrading Oracle ODBC Driver
          • XL97: Query Is Not Executed in the Background
          • XL97: Query Is Not Updated When File Is Opened
          • XL97: Query Wizard May Not Appear When Editing Query
          • XL97: Question Marks Appear After Deactivating Worksheet Object
          • XL97: Range of Pasted Hyperlinks May Not Be Sorted Correctly
          • XL97: Read-Only Recommended Opening 97
          • XL97: Read/Write Permission Required for Customized Toolbars
          • XL97: Recalculating Displays Values from Another Workbook
          • XL97: Recorded Macro Contains DrawingObjects Method
          • XL97: Redo Toolbar Button Does Not Repeat Formatting
          • XL97: Redraw Problems Applying Page Setup in Many Sheets
          • XL97: Reference Incorrectly Listed as 'MISSING' in MS Excel 97
          • XL97: Referenced Workbooks and Add-Ins Are Automatically Opened
          • XL97: Refreshing PivotTable Causes Excel to Quit Unexpectedly
          • XL97: Regression Err: 'Cannot Add Chart to a Shared Workbook'
          • XL97: Remove Page Break Menu Item May Not Remove Page Break
          • XL97: REPT Function Limited to 32,767 Characters
          • XL97: Resolving Conflicts Unhides Previously Hidden Worksheet
          • XL97: Rotated Cells Incorrectly Display Zeros
          • XL97: Rotated Text May Not Be Visible
          • XL97: ROW And COLUMN Functions Are Not Recalculated
          • XL97: Row and Column Submenus Missing in Excel Viewer
          • XL97: ROW or COLUMN Formula Is Not Updated After Cut and Paste
          • XL97: Run-time Error '1004' Accessing Locally Defined Name
          • XL97: Run-time Error '1004' Saving Workbook as Text
          • XL97: Run-Time Error 438 If Macro Uses ControlFormat Object
          • XL97: Run-Time Error 9 When Using a Macro to Remove Page Break
          • XL97: Run-time Error Evaluating Immediate Window Expression
          • XL97: Run-Time Error in Macro Assigned to Control
          • XL97: Run-time Error Using Location Method to Change Chart
          • XL97: Run-Time Error Using Macro to Add Custom List
          • XL97: Run-Time Error Using SpecialCells Method with Protection
          • XL97: Sample Macro to Remove User Name from Comment
          • XL97: Scroll Bar Missing If Control Text Is Too Long
          • XL97: Scrolling in Chart Causes Text Boxes to Disappear
          • XL97: Scrolling Through Worksheet Causes MS Excel to Pause
          • XL97: SendKeys Slower When Compared to MS Excel 7.0
          • XL97: Separate Jobs Sent When Printing/Faxing Multiple Copies
          • XL97: Setting Default and User-Defined Chart Types
          • XL97: Setting Zoom to 39% or Less Changes Worksheet Appearance
          • XL97: Shadows and 3-D Effects Fail to Print Across Page Breaks
          • XL97: Shadows on Drawing Objects may not Appear Correctly
          • XL97: Show Method Fails with Passed Arguments
          • XL97: Show Pages Does Not Use Sheet.xlt for Worksheets
          • XL97: Size of a Picture Is Larger in Microsoft Excel 97
          • XL97: Size of Scaled Picture Is Incorrect When Cropped
          • XL97: Small Business Financial Manager 97/98 Year 2000 Update
          • XL97: Solver Returns Incorrect Result
          • XL97: Some Commands Are Not Listed in the Customize Dialog Box
          • XL97: Some Formulas Not Refreshed with Data Table in Workbook
          • XL97: Some On Events Are Not Displayed in Object Browser
          • XL97: Some Page Breaks May Not Be Removed in Group Edit Mode
          • XL97: Some Values Not Recalculated When Using Multiple Formulas
          • XL97: Some Worksheet Properties not Preserved
          • XL97: Startup Switches for Microsoft Excel 97
          • XL97: Status Bar Is Bold When Display Setting Is in Large Font
          • XL97: Status Bar Text Not Displayed When You Point to Toolbar
          • XL97: Stop Recording Button Is Not Displayed Recording a Macro
          • XL97: SUBTOTAL May Include Data in Hidden Rows
          • XL97: Summary List of Confirmed Bugs in Microsoft Excel 97
          • XL97: Summary of Workbook and Worksheet Application Events
          • XL97: Syntax Error Running Macro That Inserts WordArt
          • XL97: Syntax Errors Calculating Functions or Opening a Workbook
          • XL97: Template Wizard May Update Database with Blank Record
          • XL97: Text Contained in AutoShapes Does Not Rotate
          • XL97: Text Copied from Microsoft Word Is Converted into Squares
          • XL97: Text in Colored Cell Fails to Print on Color LaserJet
          • XL97: Text Is Cut Off When Printing or Viewing a Worksheet
          • XL97: Text Is Truncated in a Text Box with Rounded Corners
          • XL97: Text Is Truncated to 255 Characters After Using Justify
          • XL97: Text May Print on Top of Drawing Objects
          • XL97: Text Problems in Controls When Worksheet is Zoomed
          • XL97: TextColumn Property Displays Only the First Column
          • XL97: The Workbook Consolidation Wizard
          • XL97: Third-Party Utilities for Excel 97
          • XL97: Times Created by Filling-Down May Be Incorrect
          • XL97: Toolbox Disappears After Clicking TabStrip Control Tab
          • XL97: Trendline Equation Label Uses Different Color
          • XL97: Two Methods for Justifying Text
          • XL97: Unable to Close File Activated by WorkbookBeforeClose
          • XL97: Unable to Delete or Hide Sheet1
          • XL97: Unable to Open File After Changing Code Name of Sheet
          • XL97: Unable to Rotate AutoShapes While in Edit Mode
          • XL97: Unable to Select Defined Names by Using Function Wizard
          • XL97: Unable to Share Custom Lists
          • XL97: Unable to Use File URL in Linking Formulas
          • XL97: Undo After Clearing OLE Object Turns Object into a Picture
          • XL97: Undo Does Not Always Restore Previous Value
          • XL97: Undoing 'Merge and Center' Causes Page Fault or Hang
          • XL97: Unexpected Font or Color Formatting Applied to Chart
          • XL97: Unexpected Results Paste Linking Noncontiguous Range
          • XL97: Unexpected Results Using the SolverAdd Function
          • XL97: Unusual Behavior When You Use the HYPERLINK Function
          • XL97: Unusual Sheet Names Appear Using Custom Sheet Template
          • XL97: Upgrade Doesn't Migrate All Xlstart Files
          • XL97: User Settings Are Reset After Upgrading
          • XL97: UserForm Flashes When Editing Caption Property
          • XL97: UserForm Is Lost When Saving in Earlier Version Format
          • XL97: UserForm May Not Be Closed Using QueryClose Event
          • XL97: Using Adobe Acrobat 3.0 PDFWriter with MS Excel 97
          • XL97: Using AutoFilter May Take a Long Time
          • XL97: Using PivotTable Calculated Fields and Calculated Items
          • XL97: Using Server Page Fields in PivotTables
          • XL97: Using the Common Dialog (Print) Control Flags Property
          • XL97: Using the File Integration Wizard
          • XL97: Using the MailLogon Method in Microsoft Excel 97
          • XL97: Using the New Keyword to Create Instances of a UserForm
          • XL97: Using the Policy Editor to Force Macro Virus Protection
          • XL97: Using VbConstants in Text Strings in MS Excel 97
          • XL97: Value (Y) Axis Labels Missing When Workbook Is Reopened
          • XL97: ValuPack Templates Not in Microsoft Excel 97 Format
          • XL97: Variant Array of Dates Transfers to Worksheet Incorrectly
          • XL97: Virus Search Add-In Was Not Included with Microsoft Excel
          • XL97: Visible Property Does Not Apply to All CommandBars
          • XL97: Visio 4 Drawing Object Disappears After Being Opened
          • XL97: Visio 4 Drawing Object May Not Be Displayed Correctly
          • XL97: Visual Basic Help File Is Available for Microsoft Map
          • XL97: Visual Basic Procedure Halts on Workbooks.Open
          • XL97: Warning Saving Workbook if It Contains a Sound Note
          • XL97: Watch Window Does Not Use Procedure Call Context
          • XL97: Web Query File Is Case Sensitive
          • XL97: White Text May Not Be Printed or Appear in Preview
          • XL97: Window Vanishes/Stops Responding After Inserting Cut Cells
          • XL97: Windows Are Restored After Adding Worksheet to Binder
          • XL97: Word Object Displayed Differently in Excel 97
          • XL97: WordArt Object Displayed Differently in Excel 97
          • XL97: Workbook Protected/Saved with a Password Is Saved Slowly
          • XL97: WorkBookBeforeClose Event Fires Unexpectedly
          • XL97: Workbooks Saved in Earlier Formats May Open Slowly
          • XL97: Worksheet Events Don't Occur After Clicking Link
          • XL97: Worksheet Not Recalculated with
          • XL97: Wrong Folder Displayed in Save As Dialog Quitting Excel
          • XL97: Wrong Printer Is Used After Changing Printer Properties
          • XL97: Wrong Values Displayed for Calculated Item in PivotTable
          • XL97:PasteSpecial Crash with Math Operation
          • XL97:Results Unchanged Toggling Transition Formula Evaluation
          • XL97:UNCONF: Problems Using PowerBuilder with Microsoft Excel 97
        • ▶Excel 98
        • ▶FrontPage
        • ▶FrontPage 2000
        • ▶FrontPage 98
        • ▶FrontPage Server
        • ▶Microsoft Office 2000 Developer
        • ▶Microsoft Office 98
        • ▶Microsoft Vizact 2000
        • ▶Office
        • ▶Office 2000
        • ▶Office 2000 Web Components
        • ▶Office 97
        • ▶Office Developer
        • ▶Office Server Extensions
        • ▶Outlook
        • ▶Outlook 2000
        • ▶Outlook 98
        • ▶PowerPoint 2000
        • ▶PowerPoint 97
        • ▶VBA articles for Excel 2000
        • ▶VBA articles for Excel 97
        • ▶VBA articles for Excel 98 Macintosh Edition
        • ▶VBA Articles for Office 2000 Products
        • ▶Word
        • ▶Word 2000
        • ▶Word 97 for Windows
      • ▶OLE
      • ▶Visual Basic
      • ▶Visual Database Tools
      • ▶Visual C++
      • ▶Visual InterDev
      • ▶Visual J++ and Java Language
      • ▶Visual SourceSafe
      • ▶Visual Studio
      • ▶Windows
      • ▶Windows Development
      • ▶Miscellaneous
    • ▶Technical Articles
    • ▶Backgrounders
    • ▶Specifications
    • ▶Books
    • ▶Partial Books
    • ▶Periodicals
    • ▶Samples