- ▼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