• ▼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
          • HOWTO: Automate Excel Using Perl for Win32
          • OFF2000: Searching for Help on the Web Starts Internet Explorer
          • OFF2000: Zeroes Unexpectedly Displayed in Published PivotTable
          • Query2000: 'Syntax Error (Missing Operator)...' Error Querying
          • SBFM2000: 'An Unexpected Error Occurred' Canceling Login
          • SBFM2000: Account Categories Incorrect If Update Accounting Data
          • SBFM2000: Average Monthly Profit from Asset Not Used
          • SBFM2000: Cannot Open Previous Financial Manager Data File
          • SBFM2000: Cannot Update Reports After Remapping Data
          • SBFM2000: Error Importing Data When Using Password in Login
          • SBFM2000: Incorrect Total Cash Flow for Simply Accounting Data
          • SBFM2000: Incorrect Transaction Dates in Cash Flow Report
          • SBFM2000: Microsoft Money 2000 Personal
          • SBFM2000: Payroll Expense Total Different Than QuickBooks Profit and Loss Total
          • SBFM2000: Peachtree Complete Accounting Version 7.0 Filter
          • SBFM2000: Recalculate Reports Does Not Update Charts
          • SBFM2000: Remap Data Error 'Unable to Open
          • SBFM2000: Reports Show Hidden Rows and Columns in Web Page
          • SBFM2000: Run-Time Error 429 Starting SBFM
          • SBFM2000: Sales By Customer Report Does Not Include Credit Memos
          • SBFM2000: Sales Total Different in Sales By Customer Report
          • SBFM2000: Supported Accounting Packages
          • SBFM2000: Tax Savings from Depreciation Appears for Asset
          • SBFM2000: UK Quickbooks Filter Available
          • SBFM2000: Updated MYOB Filter Available
          • XL2000: 'A Field in Your Source Data Has More Unique Items...'
          • XL2000: 'am/pm' Changed to 'AM/PM' in Custom Number Format
          • XL2000: 'An error occurred while loading 'Sheet1111111111111...'
          • XL2000: 'Auto_Open_xlquery_DClick' Err Msg When You Open File
          • XL2000: 'Cannot connect...' Error Refreshing OLAP PivotTable
          • XL2000: 'Cannot Open Protected File' Error Opening WK3, WK4 File
          • XL2000: 'Cannot Open Specified File' Clicking Hyperlink
          • XL2000: 'Cannot Print File' Error
          • XL2000: 'Cannot quit EXCEL.EXE' and Can't Log Off Windows NT
          • XL2000: 'Cannot Shift Objects Off Sheet' Error Hiding Columns
          • XL2000: 'Compile error in hidden module: registration db'
          • XL2000: 'Could Not Decrypt File' with Password Protected File
          • XL2000: 'Could Not Use File, File Already in Use' Running Query
          • XL2000: 'Couldn't open the OLAP Cube Wizard.' Error
          • XL2000: 'Create Hyperlink Here' Does Not Work in Unsaved File
          • XL2000: 'Current Printer Is Unavailable. Select Another Printer'
          • XL2000: 'Disk Is Full' Error Saving Workbook
          • XL2000: 'Document not saved. Any previously saved copy...'
          • XL2000: 'Excel could not save all the data and formatting' Error
          • XL2000: 'File Format Not Valid' Appears Opening Routed Workbook
          • XL2000: 'File Not Loaded Completely' Error in Text Import Wizard
          • XL2000: 'Filename Is Not Valid' Error Saving or Opening File
          • XL2000: 'Insert Copied Cells' Menu Item Missing After Copy
          • XL2000: 'Out of Virtual Memory' Opening Workbooks with Controls
          • XL2000: 'Save Not Completed. File Rename Failed. Retry?'
          • XL2000: 'SYLK: File Format is not Valid' Error Opening File
          • XL2000: 'SYLK: File format is not valid' Error Opening Text File
          • XL2000: 'Syntax Error in FROM Clause' When Getting External Data
          • XL2000: 'That command cannot be used on multiple selections.'
          • XL2000: 'The Disk Is Full' Error Copying Very Large Worksheet
          • XL2000: 'The macros in this project are disabled.' Error
          • XL2000: 'The Microsoft Map data file EUROPE.IND was not found.'
          • XL2000: 'This File Has Been Locked' Error Saving Shared Workbook
          • XL2000: 'This file is locked.' Saving or Closing Shared File
          • XL2000: 'Too Many Different Cell Formats' Error Formatting Cell
          • XL2000: 'Unable to Record' Message When Recording a Macro
          • XL2000: 'Unable to Write to Database' Error with Null String
          • XL2000: 'Your Changes Could Not Be Saved...' Error
          • XL2000: #N/A Error in Data Field of PivotTable Based on OLAP
          • XL2000: #NAME? Appears Copying Formulas to New Workbook
          • XL2000: #REF! Error Recalculating Worksheet with Defined Name
          • XL2000: #VALUE! Appears When Function Is Recalculated
          • XL2000: #VALUE! in Spreadsheet Published from Excel with TFE
          • XL2000: ;;; Number Format Fails to Hide Cell Contents
          • XL2000: 12:00:00 AM Displayed for Dates Earlier Than 1900
          • XL2000: ActiveX Controls May Be Inadvertently Cropped
          • XL2000: Additional Text Included in Hyperlink
          • XL2000: Always Create Backup Fails on Internet FTP Location
          • XL2000: Assigned Macro Not Copied with Objects
          • XL2000: ATP Functions Unexpectedly Return #NAME Error Value
          • XL2000: Attached Toolbar Is Not Saved in 5.0/95 File Format
          • XL2000: AutoComplete May Not Work
          • XL2000: AutoCorrect May Not Capitalize First Word in Sentence
          • XL2000: AutoCorrect Stops After 255 Characters
          • XL2000: AutoFill Limited to 255 Characters
          • XL2000: AutoFilter Settings Lost When Worksheet Is Published
          • XL2000: Automation Doesn't Release Excel Object from Memory
          • XL2000: AutoSave Settings Are Not Retained Between Sessions
          • XL2000: Behavior of Numbers When Using Automatic Percent Entry
          • XL2000: Blank Space Around Objects in Web Page Saved in Excel
          • XL2000: Blanks Sorted Differently in Office PivotTable List
          • XL2000: Blue Screen Error Printing Worksheet to HP LaserJet 6
          • XL2000: Border Color of Lines Returns Incorrect RGB Value
          • XL2000: Borders Appear in Printed Workbook Using Track Changes
          • XL2000: Borders Below Row 65536 Do Not Print
          • XL2000: Borders Printed Black with 'Black and White' Selected
          • XL2000: Borders Published to Web Page Don't Show in Border Tool
          • XL2000: Bullets Not Retained When Pasting Selection from Word
          • XL2000: Calculate Message Remains If 65,536 Formula References
          • XL2000: Calculation Differences with the Office Spreadsheet
          • XL2000: Calculation of Formula in Formula Bar Returns #VALUE!
          • XL2000: CALL Function Always Returns FALSE in Worksheet
          • XL2000: Can't Hide/Unhide Sheets If Workbook Contents Protected
          • XL2000: Can't Link to Worksheet with Exclamation Point in Name
          • XL2000: Can't Link Value of Control to Function
          • XL2000: Can't Open File With XLM Code When Security Set to High
          • XL2000: Can't Record 'Open Published Web Page in Browser' Option
          • XL2000: Can't Use Find/Replace on Text with Leading Apostrophe
          • XL2000: Cannot Add a Data Table to Some Charts
          • XL2000: Cannot Change Chart to PivotChart
          • XL2000: Cannot Change Fill Color for Walls or Floor on 3-D Chart
          • XL2000: Cannot Change PivotChart Source Range
          • XL2000: Cannot Drag Drawing Objects Between Worksheets
          • XL2000: Cannot Drag Drawing Objects onto Windows Desktop
          • XL2000: Cannot Drag Page Breaks in Page Break Preview
          • XL2000: Cannot Drag UserForm Control onto a Worksheet
          • XL2000: Cannot Drag, Cut, or Copy AutoFilter Drop-down List
          • XL2000: Cannot Edit Text Box with Unlocked Text
          • XL2000: Cannot Modify or Delete Custom Menus
          • XL2000: Cannot Open Multiplan Files
          • XL2000: Cannot Remove Auditing Arrows by Using Trace Tools
          • XL2000: Cannot Rename to '
          • XL2000: Cannot Reset a Column to the Standard Width
          • XL2000: Cannot Save a Query's Result Set as a Table
          • XL2000: Cannot Select Part of PivotTable as Source for Chart
          • XL2000: Cannot Undo PivotTable Refresh for Non-OLAP Data Sources
          • XL2000: Cannot Use Object Box When Multiple Controls Selected
          • XL2000: Cannot Use Web Data Source as PivotTable Data
          • XL2000: Cannot View Web Page Published from Stand-Alone Excel
          • XL2000: Cell Alignment Does Not Display Properly in Browser
          • XL2000: Cell Fill Color Bleeds into Adjacent Cells in Browser
          • XL2000: CELL Function with 'filename' No Longer Volatile
          • XL2000: Cell Ranges in Aggregate Formulas Change Unexpectedly
          • XL2000: Century Year Changes When Saved as Text File Format
          • XL2000: Certain Functions Calculate Differently in Early Version
          • XL2000: Changes Are Not Saved to HTTP or FTP Web Server
          • XL2000: Changes Aren't Saved When Altering or Resetting Toolbars
          • XL2000: Changes Not Saved When Workbook Is Opened in Microsoft O
          • XL2000: Changing a PivotChart Removes Series Formatting
          • XL2000: Changing Chart Title in Chart Options Resets Font Format
          • XL2000: Chart Data Table Does Not Display All Data Points
          • XL2000: Chart Labels Print Inside a White Box
          • XL2000: Chart Object Resizes After Switching to Another Program
          • XL2000: Chart Object Truncated After Paste Linking in PowerPoint
          • XL2000: Chart Titles with Multiple Lines Display Only One Line
          • XL2000: Clicking 'Export to Excel' Results in Blank PivotTable
          • XL2000: Clicking Cancel Button May Not Dismiss UserForm
          • XL2000: Clicking Close Button Does Not Dismiss UserForm
          • XL2000: Clicking Exit Design Mode Switches to Excel
          • XL2000: Clicking Microsoft Excel on Taskbar Does Not Work
          • XL2000: Client-Server Settings Error 'Problems Obtaining Data'
          • XL2000: Clipboard Displays One Item When You Copy Multiple Items
          • XL2000: Colors in HTML File Don't Appear as Expected
          • XL2000: Column and Area Chart Y Axis Is Scaled in Excel 2000
          • XL2000: Column Width Not the Same When Printed
          • XL2000: Columns Are Transparent When Printed in Black and White
          • XL2000: Comment Formatting May Be Lost When You Share a Workbook
          • XL2000: Comments Are Resized Unexpectedly
          • XL2000: Comments May Not Be Printed as Expected
          • XL2000: Comments Obscured Above Frozen Panes
          • XL2000: Comparison Value Changed from Fraction to Serial Number
          • XL2000: Conditional Formats May Not Work on Rich Text Cells
          • XL2000: Conditional Number Format Not Shifted in Group Edit Mode
          • XL2000: Context-Sensitive Help Not Available for Some Controls
          • XL2000: Control in Linked File Is Not Updated When Changed
          • XL2000: Control Names Change When Workbook Saved as Web Page
          • XL2000: Copied and Pasted Chart Appears as Gray Rectangle
          • XL2000: Copied Formula is Pasted as a Value
          • XL2000: Copy and Paste of Dates Produces Incorrect Dates
          • XL2000: Copying ActiveX Control Loses Code Behind Control
          • XL2000: Copying and Pasting Noncontiguous Range Loses Formulas
          • XL2000: Copying Worksheet into Workbook Deletes Defined Name
          • XL2000: COUNTA Function Returns 1 with Invalid Reference Argumen
          • XL2000: COUNTIF Returns Incorrect Value Referring to Blank Cells
          • XL2000: Crash After Closing Workbook with Circular References
          • XL2000: Crash Saving Shared Workbook with Conditional Formatting
          • XL2000: Crash Saving Workbook If Module Name Contains Equal Sign
          • XL2000: Crash When Clicking OK in Options Dialog Box
          • XL2000: Crash When Pasting Array Formulas into Merged Cells
          • XL2000: CTRL+ALT+TAB Does Not Insert Tab into Active Cell
          • XL2000: CTRL+SHIFT+' Keyboard Shortcut Has 1,024 Character Limit
          • XL2000: Currency Formats Lost Saving to Non-Default File Formats
          • XL2000: Currency in Cell Formatted Differently Than Expected
          • XL2000: Currency in Data Table Is Displayed in U.S. Dollars
          • XL2000: Custom Add-In Overwritten When You Load Add-In
          • XL2000: Custom Date Format Not Retained Saving Chart as Web Page
          • XL2000: Custom Function May Not Calculate Expected Value
          • XL2000: Custom Function May Return Different Result in HTML File
          • XL2000: Custom Function Returns #VALUE! If Returning Large Array
          • XL2000: Custom Number Format Doesn't Appear in Property Toolbox
          • XL2000: Custom Number Format Using Lowercase AM/PM Are Uppercase
          • XL2000: Custom Toolbar Lost When Workbook Sent as Attachment
          • XL2000: Customize Dialog Box Stays Behind Toolbars When Clicked
          • XL2000: Customizing Menus and Toolbars Without Customize Dialog
          • XL2000: Dashed Series Lines Appear Solid in Excel 2000
          • XL2000: Data Label Legend Keys Appear in Unexpected Positions
          • XL2000: Data Labels on Chart Appear Outside the Plot Area
          • XL2000: Data Labels on Published PivotCharts May Lose Formatting
          • XL2000: Data Overwritten Copying More Than 31,737 Characters
          • XL2000: DATE Function Different in Microsoft Excel 2000
          • XL2000: DATE Function May Return #NUM! Error When Year Is 0-3
          • XL2000: Date Labels on X-Axis of XY (Scatter) Chart Distorted
          • XL2000: Dates Truncated When You Save Worksheet as PRN File
          • XL2000: Dates/Times Display Serial Numbers If Viewing Formulas
          • XL2000: Days of the Week Before March 1, 1900 Are Incorrect
          • XL2000: DDE Links in Embedded Excel Object Do Not Update
          • XL2000: Decimals in Accounting Format Not Aligned in Browser
          • XL2000: Default Toolbars, Buttons Seen, Not Customizations
          • XL2000: Defined Names Saved Incorrectly in Lotus 1-2-3 Format
          • XL2000: Description and Examples of Data Validation
          • XL2000: Differences Between OLAP and Non-OLAP PivotTables
          • XL2000: Double-Clicking in Explorer Doesn't Open Workbook
          • XL2000: Drawing Objects and AutoShapes Printed Incorrectly
          • XL2000: Drawing Objects Appear Differently When Saved to 5.0/95
          • XL2000: Early Dates on Office Spreadsheet Differ from Excel
          • XL2000: Editing Local OLAP Cube Creates New Cube
          • XL2000: Embedded Chart Size Changes When Copied and Pasted
          • XL2000: Enter Parameters Dialog Is Blank When Loading Web Page
          • XL2000: Entering Data in List May Not Extend Formats as Expected
          • XL2000: Entire Text File Appears in a Merged Cell
          • XL2000: Err Msg 'The cube file
          • XL2000: Err Msg: 'The command you chose cannot be performed...'
          • XL2000: Err Msg: ? Is an Invalid Key. The File Can...
          • XL2000: Err Msg: Failure Loading the Printer's Device Driver
          • XL2000: Err Msg: Run-time Error '9': Subscript out of Range
          • XL2000: Err Msg: This File Is Not in a Recognizable Format
          • XL2000: Err Msg: Unable to Read File. Unexpected File Lock...
          • XL2000: ErrMsg Using Paste Method Without Moving Active Cell
          • XL2000: Error 1004 Opening Buy vs. Lease Analysis Report
          • XL2000: Error Accessing Data in Offline OLAP Cube
          • XL2000: Error Appears When Changing Chart Location with a Macro
          • XL2000: Error Changing Chart Source to PivotTable
          • XL2000: Error Clicking Export to Excel When Exporting OLAP Data
          • XL2000: Error Dragging Excel File into Internet Explorer
          • XL2000: Error Loading PivotTable Containing Two of Same Field
          • XL2000: Error Message: 'Microsoft Excel Can't Run This Addin'
          • XL2000: Error Message: | File Format Is Not Valid
          • XL2000: Error Message: Cannot Access Read-Only Document...
          • XL2000: Error Message: Cannot Place Chart on a Hidden Sheet
          • XL2000: Error Message: Document Is Not Completely Saved
          • XL2000: Error Message: Document Not Saved
          • XL2000: Error Message: File Format Is Not Valid
          • XL2000: Error Message: PivotTable Field Name Is Not Valid...
          • XL2000: Error Message: The Disk Is Full
          • XL2000: Error Message: The Password You Supplied Is Not Correct
          • XL2000: Error Message: There Are No Printers Installed
          • XL2000: Error Message: This File Is No Longer Shared
          • XL2000: Error Message: Unable to Read File. 1904 Date System...
          • XL2000: Error Opening File from Internet Explorer Address Bar
          • XL2000: Error Opening File That Refers to Shortcut
          • XL2000: Error Opening PivotTable Published from Excel List
          • XL2000: Error Opening Quattro Pro WB2 or WB3 File
          • XL2000: Error Opening Workbook Containing Links to HTML Workbook
          • XL2000: Error Opening Workbook That Contains Macro
          • XL2000: Error Publishing Chart with Data from Multiple Sheets
          • XL2000: Error Quitting WordPad Document That Contains Worksheet
          • XL2000: Error Restarting Your Computer While Excel Is Running
          • XL2000: Error Saving File After Network Connection Has Been Lost
          • XL2000: Error Using Defined Name That Refers to a Constant Value
          • XL2000: Error Viewing a Web Page Containing an Excel Workbook
          • XL2000: Error When Changing Reference Style Setting
          • XL2000: Error When Dragging Embedded Chart into Microsoft Word
          • XL2000: Error When Sorting a Range Containing Merged Cells
          • XL2000: Error When Using Validation Drop-Down List Box
          • XL2000: Errors Activating MS Map Created in an Earlier Version
          • XL2000: Errors After Copying Worksheet with Auditing Arrows
          • XL2000: Errors Saving When Transition Formula Evaluation Enabled
          • XL2000: Errors When Trusted Resources for Add-ins Is Removed
          • XL2000: Errors When Using ODBC Text Data Source (DSN)
          • XL2000: Euro Currency Character Is Not Displayed Correctly
          • XL2000: EUROCONVERT Rounds Number Up
          • XL2000: Example on Use of Solver
          • XL2000: Excel 'Merge Workbooks' vs Lotus 1-2-3 '/File Combine'
          • XL2000: Excel 97 Custom Toolbars Not Available in Excel 2000
          • XL2000: Excel Caused an Invalid Page Fault in MSO9.DLL When Savi
          • XL2000: Excel Chart Object May Change Shape in PowerPoint 2000
          • XL2000: Excel Considers Cell Outside Data Area as Last Cell
          • XL2000: Excel HTML File Always Displayed at 100 Percent Zoom
          • XL2000: F1 in Custom XLM Dialog Box Displays Office Assistant
          • XL2000: Features and Formatting Lost Saving to Excel 5.0/95
          • XL2000: File Conversion Wizard Is Not Available
          • XL2000: File Name in Formula Doesn't Appear Correctly
          • XL2000: File Saved as Alternate File Format Even When Declined
          • XL2000: Files Corrupted on Save: How to TShoot Source of Problem
          • XL2000: Files Open Slowly Across Network
          • XL2000: Filter Settings Lost When You Move to or from Page Field
          • XL2000: Financial or Accounting AutoFormats Change Number Format
          • XL2000: Floating-Point Arithmetic May Give Inaccurate Results
          • XL2000: Fonts on Chart Title and Label Are Too Large
          • XL2000: Formats May Not Be Applied to Pasted Merged Cell
          • XL2000: Formatting Lost When You Publish a PivotTable
          • XL2000: Formatting May Be Lost When Pasting Merged Cells
          • XL2000: Formulas Unexpectedly Changed When Saved in HTML Format
          • XL2000: Four-Digit Years May Display Only Two Digits
          • XL2000: Frozen Panes Do Not Stay Frozen on Web Page
          • XL2000: General Number Format Applied to Time Entry
          • XL2000: Gridlines Are Not Displayed in Web Browser
          • XL2000: Grouping ActiveX Option Buttons on a Worksheet
          • XL2000: Handling Corrupted Excel Files by Saving in SYLK Format
          • XL2000: Hidden Property Not Retained When Pasting from Word
          • XL2000: Hidden Rows, Columns Are Displayed in Some Web Browsers
          • XL2000: How Auto Extend List Behavior Works
          • XL2000: How Microsoft Excel Works with Two-Digit Year Numbers
          • XL2000: How to Add MS Excel 5.0 Dialog Sheet to a Workbook
          • XL2000: How to Change Default Font and Font Size in Excel
          • XL2000: How to Consolidate Multiple Worksheets to a Single Sheet
          • XL2000: How to Convert an Add-in File into a Workbook
          • XL2000: How to Convert Text to Number
          • XL2000: How to Create a Conditional Format to Hide Errors
          • XL2000: How to Create a Normal Chart from a PivotTable
          • XL2000: How to Create a User-Defined Chart Format
          • XL2000: How to Create Add-in Application Name and Description
          • XL2000: How to Create an Add-in File
          • XL2000: How to Create Auto_Open Macro to Show Data Form Dialog
          • XL2000: How to Create Functions to Calculate Light Years
          • XL2000: How to Link to a Particular Worksheet from a Web Page
          • XL2000: How to Modify the Number of Undo Levels
          • XL2000: How to Obtain and Install the SYLK File Security Update
          • XL2000: How to Parse Data Using the Text To Columns Command
          • XL2000: How to Prevent the Automatic Creation of Hyperlinks
          • XL2000: How to Save Files in Other Formats
          • XL2000: How to Set Print Area to Range with Defined Name
          • XL2000: How to Simulate a PivotTable with No Summarization
          • XL2000: How to Suppress #DIV/0! Error Value in Division
          • XL2000: How to Use a Web Data Source for a PivotTable
          • XL2000: How to Use Grouping for Fields in a PivotTable
          • XL2000: How to Use the Forms Controls on a Worksheet
          • XL2000: How to Use the Histogram Add-in
          • XL2000: How to Use the Template Wizard with Data Tracking Add-In
          • XL2000: How to Use Wildcards in Parameter Queries
          • XL2000: HTML File Grows in Size Each Time That It Is Published
          • XL2000: Hyperlink Colors Don't Show Expected Color Format
          • XL2000: HYPERLINK Doesn't Work If Second Argument Returns Error
          • XL2000: Illegal Operation Saving Shared Workbook
          • XL2000: Inconsistent Results Using Natural Language Formulas
          • XL2000: Incorrect 3-D Formula Reference After Undo or Redo Paste
          • XL2000: Incorrect Quattro Pro Converter Information in Help
          • XL2000: Incorrect Range of Values Displayed on X-Axis of Chart
          • XL2000: Incorrect Recommended Format Displayed Saving Workbook
          • XL2000: Incorrect Result Raising 10 to a Power
          • XL2000: Incorrect URL Pasted After Browsing from New Web Query
          • XL2000: Indent Option Not Available with General Alignment
          • XL2000: Invalid Page Fault Changing PivotTable Data Source
          • XL2000: Invalid Page Fault in VBACV10.DLL with French Workbook
          • XL2000: Invalid Page Fault Opening Workbook Sent in E-mail
          • XL2000: Invalid Page Fault When Using Macro to Close Workbook
          • XL2000: Invalid Page Fault When You Assign Macro to Custom Menu
          • XL2000: Invalid Site Error Using Relative Hyperlink Path
          • XL2000: IPF Opening Workbook with Embedded Enhanced Metafile
          • XL2000: Left, Top Sides of Chart Missing After Pasting Bitmap
          • XL2000: Limits of PivotTables in Microsoft Excel 2000
          • XL2000: Linked Picture Not Updated When Source Data Closed
          • XL2000: Linked References Not Updated in Closed Worksheet
          • XL2000: Linking Charts Does Not Work Correctly with Long Names
          • XL2000: Linking to Data in a Damaged File
          • XL2000: Links in Shared Workbook Return #REF! Error
          • XL2000: Links to Closed Workbook Are Not Updated Properly
          • XL2000: Links to Excel 4.0 Macro Sheets Do Not Update
          • XL2000: List of Supported File Formats in MS Excel 2000
          • XL2000: Macro Error Running Recorded Paste Commands
          • XL2000: Macro Performance Slow When Page Breaks Are Visible
          • XL2000: Macro That Inserts Formula Returns #NAME?
          • XL2000: Macro Virus Warning Does Not Appear Opening SYLK File
          • XL2000: Manual Page Break Does Not Move in Excel 5.0/95 File
          • XL2000: Medium Dot or Dashed-Dot Borders Appear Solid in Browser
          • XL2000: Method to Determine Whether a Year Is a Leap Year
          • XL2000: Methods for Recovering Data from Damaged Workbooks
          • XL2000: Minus Sign Appears Before Text in Custom Number Format
          • XL2000: Module Missing After Opening and Saving Workbook as HTML
          • XL2000: Multiple-Level Category Labels Displayed Differently
          • XL2000: Natural Language Formula Returns Incorrect Results
          • XL2000: Natural Language Formulas Produce #NAME? Errors
          • XL2000: Natural Language Formulas Return Error
          • XL2000: No 'Center Across Columns' Toolbar Button
          • XL2000: Not All Database Sheets Are Listed in theTemplate Wizard
          • XL2000: Not All Menu Items Appear for All Users
          • XL2000: Not All Workbooks Print When Printing from Explorer
          • XL2000: Nothing Happens Clicking Hyperlink in Excel Web Page
          • XL2000: Number Formatting Affects Perceived Precision
          • XL2000: Number Signs (###) Displayed in Cells of a Worksheet
          • XL2000: Objects Appear in Wrong Location in Netscape Navigator
          • XL2000: Objects or Borders Are Not Printed Correctly
          • XL2000: Odd Behavior Using Format Painter and Merged Cells
          • XL2000: Odd Display in Browser If Font Size Less Than 8 Points
          • XL2000: OFFSET Accepts Negative Values for Height and Width
          • XL2000: Only 1,024 Characters Are Displayed in a Cell
          • XL2000: Opening Web Page Containing PivotTable Prompts for User
          • XL2000: Option to Save Entire Workbook as Web Page Not Available
          • XL2000: Overview of the Built-In Chart Types
          • XL2000: Page Fault Deleting a Record with the Data Form
          • XL2000: Page Fault Linking to Workbook or Creating Formula
          • XL2000: Page Fault Printing to Generic/Text Only Printer
          • XL2000: Page Fault Starting Excel with Page Break Menu Command
          • XL2000: Page Field Area Missing After Creating PivotTable
          • XL2000: Page Formats in Header/Footer Use Two-Digit Year
          • XL2000: Page Setup Properties for Embedded Chart Lost in HTML
          • XL2000: Parameter Names Lost When Publishing a PivotTable
          • XL2000: Parameter Query Does Not Refresh Automatically
          • XL2000: Paste All Not Available with Drawing Object on Clipboard
          • XL2000: Pasted Data May Include Hidden Cells
          • XL2000: Pasting Entire Column Is Slower Than in Earlier Versions
          • XL2000: Patterns Do Not Display in a Web Browser
          • XL2000: Performing a Lookup with Unsorted Data in Excel
          • XL2000: PivotChart Button Overlaps Data Labels in Pie Chart
          • XL2000: PivotChart Data Labels Lost When Published Interactively
          • XL2000: PivotChart Loses Data When Pasted to a New Workbook
          • XL2000: PivotTable Does Not Preserve Conditional Formatting
          • XL2000: PivotTable List Week Grouping Lost When Exported to XL
          • XL2000: PivotTable Times Greater Than 24 Hrs Display Incorrectly
          • XL2000: PivotTable Wizard Does Not Automatically Refresh Data
          • XL2000: Placeholder Remains After Canceling Clip Gallery
          • XL2000: Pressing TAB Doesn't Switch Tabs in Dialog Box
          • XL2000: Print Titles with Merged Cells Add Columns or Rows
          • XL2000: Printer Name Not Listed in Print Dialog Box
          • XL2000: Problems When You AutoFormat an Entire Worksheet
          • XL2000: Products That Qualify for the Microsoft Excel Upgrade
          • XL2000: Published Chart Displays 'Series' as Name in Legend
          • XL2000: Publishing Cells with Spilled Text Creates Merged Cells
          • XL2000: Range_Lookup Argument in VLOOKUP Finds Exact Match
          • XL2000: Read-Only Recommended When You Open Excel 97-2000/5.0/7.
          • XL2000: Read/Write Permission Required for Customized Toolbars
          • XL2000: Referencing an Invalid UserForm Control Causes a Crash
          • XL2000: Rotated Text Displays Horizontal When Viewed In Browser
          • XL2000: Run-time Error '1004' Saving Workbook as Text
          • XL2000: Run-Time Errors Using UserForms Collection
          • XL2000: Running Multiple Versions of Microsoft Excel
          • XL2000: Saving in Excel 97 Loses PivotTable Field Layout Options
          • XL2000: Scanned Picture Appears Zoomed When Printed
          • XL2000: Scatter Chart Points and Line Missing in WebPage
          • XL2000: Selected Text in Combo Box Overflows into Worksheet
          • XL2000: Separate Jobs Sent When Printing/Faxing Multiple Copies
          • XL2000: Series Data Orientation Not Saved in Custom Chart Type
          • XL2000: Shadows on Drawing Objects May not Appear Correctly
          • XL2000: Sheet Protection Does Not Disable Options Settings
          • XL2000: Some Commands Are Not Listed in the Customize Dialog Box
          • XL2000: Some Functions May Give Incorrect Results with 2/29/2000
          • XL2000: Some Page Breaks May Not Be Removed in Group Edit Mode
          • XL2000: Some Workbook Features Not Retained When Saving as a Web
          • XL2000: Some Worksheet Properties Not Preserved
          • XL2000: Startup Switches for Microsoft Excel 2000
          • XL2000: Status Bar Text Is Bold When Using Large Fonts Setting
          • XL2000: Supporting Data for Your PivotTable May Be Visible
          • XL2000: Temporary File Created When You Save a Document
          • XL2000: Text Box Border Appears Jagged in Browser
          • XL2000: Text Contained in AutoShapes Does Not Rotate
          • XL2000: Text Is Truncated in a Text Box with Rounded Corners
          • XL2000: Text Is Truncated in Text Box on Chart in Worksheet
          • XL2000: Text May Print on Top of Drawing Objects
          • XL2000: Text on Worksheet Tab Is Compressed or Clipped
          • XL2000: Text Spanning Multiple Cells Truncated If Saved as HTML
          • XL2000: The 1900 Date System vs. the 1904 Date System
          • XL2000: Tips for Importing Lotus 1-2-3 Files into Excel
          • XL2000: Toolbars Don't Resize After Closing Print Preview
          • XL2000: Totals Missing From PivotTable Published From Excel
          • XL2000: TrueType Fonts Available But Not Used in Print Preview
          • XL2000: Two Pastes from Office Clipboard Clears Bounding Outline
          • XL2000: Two-Digit Year Displayed When You Type a Four-Digit Year
          • XL2000: Unable to Move or Resize Chart Objects in a PivotChart
          • XL2000: Unable to Rotate AutoShapes While in Edit Mode
          • XL2000: Unable to Use File URL in Linking Formulas
          • XL2000: Undo and Redo Unavailable After Using Auditing Tools
          • XL2000: Undo Does Not Always Restore Previous Value
          • XL2000: Undo Unavailable After Creating PivotChart Report
          • XL2000: Undoing Change to Chart after Freezing Pane Causes IPF
          • XL2000: Unexpected Behavior with Numbers Formatted as Text
          • XL2000: Unexpected Font or Color Formatting Applied to Chart
          • XL2000: Unexpected Result Pasting Non-Contiguous Range in Word
          • XL2000: Unsigned Macros Trusted When Macro Security Is High
          • XL2000: UserForm Is Lost When Saving in Earlier Version Format
          • XL2000: Using 'Fit To' Does Not Increase Scale to Fill Page
          • XL2000: Using A Functions in Microsoft Excel 2000
          • XL2000: Using Data Analysis Tools on Grouped Sheets
          • XL2000: Using Excel 2000 Files with Earlier Versions of Excel
          • XL2000: Values Pasted from Clipboard in Place of Formulas
          • XL2000: VLOOKUP/HLOOKUP with TFE Return Incorrect Value
          • XL2000: Warning Saving Workbook if It Contains a Sound Note
          • XL2000: Web Page Cannot Be Opened on the Macintosh
          • XL2000: Web Page Saved in Excel Displays Differently in Browser
          • XL2000: WMF Image Inserted as Background Appears Very Large
          • XL2000: Workbook Loads Slowly the First Time That it is Opened
          • XL2000: Workbook Name Contains Invalid Characters
          • XL2000: Worksheet May Not Recalculate Completely If F9 Pressed
          • XL2000: Worksheet Saved as HTML Displays Wrong Font in Browser
          • XL2000: Wrong Date Returned When You Enter Month and Digits
          • XL2000: Wrong Date Saved to Clipboard
          • XL2000: Wrong Workbook Is Printed or Previewed
          • XL2000: XLDataSource Error Opening PivotTable
          • XL2000: Zooming 39% or Less Changes the Worksheet Appearance
          • XL2000:'Problems came up...' Error Exporting Web Component
          • XL2000:#N/A Error When (All) Member Missing from OLAP Cube
          • XL2000:Chart Axis May Be Four Years Early After You Format Scale
          • XL2000:Charts Lose Axis Labels, Axis Scaling After Copying Sheet
          • XL2000:Custom Date Appears or Date Is Missing in AutoFilter List
          • XL2000:Linked Files Updated More Slowly Than in Earlier Versions
        • ▶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