kbupdate.info ›
Daily Updated!
Excel 2000 articles, fixes and updates - September 2003
Daily Updated!
chronological list: 2021 | ... 7 6 5 4 3 1 | 2005 | 2004 | 2003/12 11 10 9 8 6 5
alphabetical list: A B C D E F G H I K L M N O P Q R S T U V W X Y
This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Excel 2000 that have been released in September 2003. The list is daily updated.
- 279412 HOW TO: Use Natural Language Formulas in Excel 2000 Q279412 KB279412 September 27, 2003
- 214384 XL2000: Error Messages Occur Sending Workbook to Mail Program Q214384 KB214384 September 27, 2003
- 214349 XL2000: "Reference Is Not Valid" Error Message When You Create PivotTable Q214349 KB214349 September 27, 2003
- 214252 HOW TO: Use the Excel Lookup Wizard (Lookup.xla) in Excel 2000 Q214252 KB214252 September 27, 2003
- 214251 HOW TO: Use the INDEX and LINEST Functions to Solve for New X-Values in Excel 2000 Q214251 KB214251 September 27, 2003
- 214247 HOW TO: Hide Records with Duplicate Cell Entries in Excel 2000 Q214247 KB214247 September 27, 2003
- 214149 XL2000: Keeping a Cumulative Total in a Column or Row Q214149 KB214149 September 27, 2003
- 214115 XL2000: Solver Uses Generalized Reduced Gradient Algorithm Q214115 KB214115 September 27, 2003
- 214057 HOW TO: Display Data as Percentage of the Total in a PivotTable in Excel 2000 Q214057 KB214057 September 27, 2003
- 214054 XL2000: "Cannot Change Part of an Array" Error Message Q214054 KB214054 September 27, 2003
- 214053 XL2000: Formula to Sum Digits of a Number Q214053 KB214053 September 27, 2003
- 213970 XL2000: Cell Linked to Text-Formatted Cell Shows Formula Not Value Q213970 KB213970 September 27, 2003
- 213929 HOW TO: Create a Single Stacked Column Chart or Single Bar Chart in Excel 2000 Q213929 KB213929 September 27, 2003
- 213928 HOW TO: Create Two Pie Charts in One in Excel 2000 Q213928 KB213928 September 27, 2003
- 213920 HOW TO: Analyze a Questionnaire or Survey with a PivotTable in Excel 2000 Q213920 KB213920 September 27, 2003
- 213916 HOW TO: Rank Duplicate Values Sequentially in Excel 2000 Q213916 KB213916 September 27, 2003
- 213887 HOW TO: Find the Secant, Cosecant, or Cotangent of an Angle in Excel 2000 Q213887 KB213887 September 27, 2003
- 213884 HOW TO: Hide Gridlines in a Selected Area of a Worksheet in Excel 2000 Q213884 KB213884 September 27, 2003
- 213394 XL2000: Changing Protected Document's Properties with Visual Basic Macro Q213394 KB213394 September 27, 2003
- 212227 XL2000: The Fill Values Command Fills Series Instead of Values with Merge Cells Formatting Q212227 KB212227 September 27, 2003
- 212204 XL2000: Pasting in Merged Cell Duplicates Copied Cells Q212204 KB212204 September 27, 2003
- 212181 XL2000: Some On Events Are Not Displayed in the Visual Basic Object Browser Q212181 KB212181 September 27, 2003
- 212152 XL2000: Lotus 1-2-3 Dates and Phone Numbers Are Converted to One Number Q212152 KB212152 September 27, 2003
- 212136 XL2000: Redraw Problems Applying Page Setup in Many Sheets Q212136 KB212136 September 27, 2003
- 212134 XL2000: Letters Available As Keyboard Shortcuts for Macros Q212134 KB212134 September 27, 2003
- 212121 HOW TO: Rename a Chart by Using the Name Box in Excel 2000 Q212121 KB212121 September 27, 2003
- 212119 XL2000: Chart Axis Changes Scale in Earlier Version of Workbook Q212119 KB212119 September 27, 2003
- 212105 XL2000: Both Diagonal Cell Borders Use the Same Line Style Q212105 KB212105 September 27, 2003
- 212089 XL2000: Input Range Error Using Anova Analysis Tool Q212089 KB212089 September 27, 2003
- 212079 HOW TO: Sort Cells Without Sorting Linked Cells in Excel 2000 Q212079 KB212079 September 27, 2003
- 212069 XL2000: AutoComplete Works Differently After 102 Rows Past Last Occurrence Q212069 KB212069 September 27, 2003
- 212040 XL2000: Microsoft Map May Hang When You Insert Canadian Postal Codes Q212040 KB212040 September 27, 2003
- 212024 XL2000: Template Wizard May Update Database with Blank Record Q212024 KB212024 September 27, 2003
- 211996 XL2000: Picture Linked to Cell Is Not Immediately Updated Q211996 KB211996 September 27, 2003
- 211991 XL2000: Dates Are Incorrect When You Fill a Very Large Time Frame Q211991 KB211991 September 27, 2003
- 211986 XL2000: Imported Toolbox Page Loses Caption and Tip Text Q211986 KB211986 September 27, 2003
- 211978 XL2000: Grouping ActiveX Option Buttons on a Worksheet Q211978 KB211978 September 27, 2003
- 211976 XL2000: Some Page Numbers in "Now Printing" Dialog Box May Be Skipped Q211976 KB211976 September 27, 2003
- 211972 XL2000: Drawing Object Names Increment Incorrectly Q211972 KB211972 September 27, 2003
- 211965 XL2000: Data Overwritten Copying More Than 31,737 Characters Q211965 KB211965 September 27, 2003
- 211958 XL2000: Illegal Operation Error if Chart Gallery File Is Password-Protected Q211958 KB211958 September 27, 2003
- 211945 XL2000: PivotTable Report Unavailable with Parameter Query Q211945 KB211945 September 27, 2003
- 211931 XL2000: Query Is Not Executed in the Background Q211931 KB211931 September 27, 2003
- 211906 XL2000: Redo Toolbar Button Does Not Repeat Formatting Q211906 KB211906 September 27, 2003
- 211903 XL2000: COUNTA Function Changed to COUNT Q211903 KB211903 September 27, 2003
- 211894 XL2000: Comparison Value Changed from Fraction to Serial Number Q211894 KB211894 September 27, 2003
- 211885 XL2000: Error Message Appears When You Run a Macro to Modify Cell Comments Q211885 KB211885 September 27, 2003
- 211878 XL2000: Linked Formula May Return a Maximum of 255 Characters Q211878 KB211878 September 27, 2003
- 211875 XL2000: Natural Language Formula Returns Zero Value Q211875 KB211875 September 27, 2003
- 211858 XL2000: Shadows and 3-D Effects Do Not Print Across Page Breaks Q211858 KB211858 September 27, 2003
- 211845 XL2000: Page Fault When You Press ENTER After Clicking Camera Tool Q211845 KB211845 September 27, 2003
- 211843 XL2000: Text Is Truncated to 255 Characters After You Use Justify Command Q211843 KB211843 September 27, 2003
- 211840 XL2000: Cannot Show Scenario That Includes Merged Cells Q211840 KB211840 September 27, 2003
- 211823 XL2000: Page Fault When You Add a Shadow to a Series in a Surface Chart Q211823 KB211823 September 27, 2003
- 211792 XL2000: "Project Is Unviewable" Error Message When You Try to View Project Q211792 KB211792 September 27, 2003
- 211789 XL2000: Function Box Has Replaced Name Box and Functionality Has Changed Q211789 KB211789 September 27, 2003
- 211784 XL2000: Linked Cell Changes Before Sheet Is Completely Calculated Q211784 KB211784 September 27, 2003
- 211772 XL2000: All Input Messages Appear in the Same Location Q211772 KB211772 September 27, 2003
- 211764 XL2000: No Warning with Incorrect Data Validation Setting Q211764 KB211764 September 27, 2003
- 211756 XL2000: Cannot Paste a Picture into a UserForm Q211756 KB211756 September 27, 2003
- 211754 XL2000: Natural Language Formula Returns Incorrect Results Q211754 KB211754 September 27, 2003
- 211749 XL2000: Conditional Number Format Not Shifted in Group Edit Mode Q211749 KB211749 September 27, 2003
- 211728 XL2000: Trendline Equation Label Does Not Use the Specified Color Q211728 KB211728 September 27, 2003
- 211715 XL2000: Control in Linked File Is Not Updated When Changed Q211715 KB211715 September 27, 2003
- 211713 XL2000: Using Microsoft Excel to Save a File to an FTP Site Q211713 KB211713 September 27, 2003
- 211703 XL2000: Wrong Values Displayed for Calculated Item in PivotTable Q211703 KB211703 September 27, 2003
- 211684 XL2000: Cannot Use Object Box When Multiple Controls Are Selected Q211684 KB211684 September 27, 2003
- 211680 XL2000: Printing at Non-Square Resolution Distorts AutoShapes Q211680 KB211680 September 27, 2003
- 211667 XL2000: Comment Changes Are Not Saved in Shared Workbook Q211667 KB211667 September 27, 2003
- 211665 XL2000: Changes May Be Lost When You Use a Shared Workbook on an FTP Server Q211665 KB211665 September 27, 2003
- 211663 XL2000: Objects in Chart May Not Appear in Sample Chart Q211663 KB211663 September 27, 2003
- 211661 XL2000: Black and White Printer Prints Colored Lines As Grayscale Q211661 KB211661 September 27, 2003
- 211658 XL2000: Animation Feedback Does Not Work with Floating Toolbars Q211658 KB211658 September 27, 2003
- 211657 XL2000: Size of Scaled Picture Is Incorrect if Picture Is Cropped Q211657 KB211657 September 27, 2003
- 211647 XL2000: Borders Near Hidden Cells May Not Be Displayed or Printed Q211647 KB211647 September 27, 2003
- 211635 XL2000: Cannot Drag Cells When You Use AutoFilter Q211635 KB211635 September 27, 2003
- 211628 XL2000: Two Methods for Justifying Text Q211628 KB211628 September 27, 2003
- 211622 XL2000: Query Returns More Records Than You Specify Q211622 KB211622 September 27, 2003
- 211614 XL2000: Columns Are Transparent When They Are Printed in Black and White Q211614 KB211614 September 27, 2003
- 211540 XL2000: Text May Print on Top of Drawing Objects Q211540 KB211540 September 27, 2003
- 211409 XL2000: Column and Area Chart Y Axis Is Scaled in Microsoft Excel 2000 Q211409 KB211409 September 27, 2003
- 210766 XL2000: X and Z Axis Labels Appear to Be Reversed in a 3-D Pivot Chart Q210766 KB210766 September 27, 2003
- 236331 XL2000: Supporting Data for the Initial View of Your PivotTable May Be Visible to Users Q236331 KB236331 September 26, 2003
- 214075 XL2000: How Chart Axis Limits Are Determined Q214075 KB214075 September 26, 2003
- 214026 XL2000: Error Message: "Cannot Group that Selection" Q214026 KB214026 September 26, 2003
- 211698 XL2000: Remove Page Break Command May Not Remove Page Break Q211698 KB211698 September 26, 2003
- 275611 HOW TO: Work with an HTML Table That Contains Merged Cells in Excel 2000 Q275611 KB275611 September 25, 2003
- 267281 XL2000: Error: Anova: Two-Factor With Replication - Each sample must contain the same number of rows. Q267281 KB267281 September 25, 2003
- 263552 HOW TO: Turn AutoComplete On or Off in Excel 2000 Q263552 KB263552 September 25, 2003
- 259625 XL2000: Invalid External Reference Error When Creating Chart Q259625 KB259625 September 25, 2003
- 259558 XL2000: Cannot Set Edit Links to Manual for Workbooks Q259558 KB259558 September 25, 2003
- 259200 HOW TO: Use NETWORKDAYS with Multiple Holidays in Excel 2000 Q259200 KB259200 September 25, 2003
- 231421 HOW TO: Create a Normal Chart from a PivotTable in Excel 2000 Q231421 KB231421 September 25, 2003
- 231006 XL2000: Cannot Undo PivotTable Refresh for Non-OLAP Data Sources Q231006 KB231006 September 25, 2003
- 230945 XL2000: Scatter Chart Points and Line Missing When Published as WebPage with Interactivity Q230945 KB230945 September 25, 2003
- 230934 XL2000: Bullets Not Retained When You Paste Selection from Word Q230934 KB230934 September 25, 2003
- 230584 XL2000: Entering Data in List May Not Extend Formats as Expected Q230584 KB230584 September 25, 2003
- 229344 XL2000: Additional Text Included in Hyperlink Q229344 KB229344 September 25, 2003
- 229040 XL2000: Blank Space Appears Around Objects in Web Page Saved in Excel Q229040 KB229040 September 25, 2003
- 228894 XL2000: Can't Record "Open Published Web Page in Browser" Option Q228894 KB228894 September 25, 2003
- 228868 XL2000: Hidden Property Not Retained When Pasting Selection from Word Q228868 KB228868 September 25, 2003
- 228782 XL2000: Odd Display in Browser If Font Size Less Than 8 Points Q228782 KB228782 September 25, 2003
- 215971 XL2000: Copy and Paste of Dates Produces Incorrect Dates Q215971 KB215971 September 25, 2003
- 213922 HOW TO: Index Data in a PivotTable in Excel 2000 Q213922 KB213922 September 25, 2003
- 212240 XL2000: Unable to Rotate AutoShapes While in Edit Mode Q212240 KB212240 September 25, 2003
- 212179 XL2000: Cannot Reset a Column to the Standard Width Q212179 KB212179 September 25, 2003
- 212165 XL2000: Borders Printed Black with "Black and White" Selected Q212165 KB212165 September 25, 2003
- 212149 XL2000: Status Bar Text Is Bold When Using Large Fonts Display Setting Q212149 KB212149 September 25, 2003
- 212114 XL2000: "am/pm" Changed to "AM/PM" in Custom Number Format Q212114 KB212114 September 25, 2003
- 212062 XL2000: Manual Page Break Does Not Move in Excel 5.0/95 File Q212062 KB212062 September 25, 2003
- 212018 XL2000: Cannot Drag Drawing Objects Between Worksheets Q212018 KB212018 September 25, 2003
- 211999 XL2000: Unable to Use File URL in Linking Formulas Q211999 KB211999 September 25, 2003
- 211988 XL2000: Customize Dialog Box Stays Behind Toolbars When Clicked Q211988 KB211988 September 25, 2003
- 211947 XL2000: Customizing Menus and Toolbars Without Using Customize Dialog Box Q211947 KB211947 September 25, 2003
- 211891 XL2000: Borders Appear in Printed Workbook Using Track Changes Q211891 KB211891 September 25, 2003
- 211779 XL2000: Group Name in Name Box Does Not Update Q211779 KB211779 September 25, 2003
- 211752 XL2000: Left, Top Sides of Chart Missing After Pasting Bitmap Picture Q211752 KB211752 September 25, 2003
- 211722 XL2000: Context-Sensitive Help Not Available for Some Form Controls Q211722 KB211722 September 25, 2003
- 211650 XL2000: Cannot Change Fill Color for Walls or Floor on 3-D Chart Q211650 KB211650 September 25, 2003
- 211591 XL2000: Text Contained in AutoShapes Does Not Rotate Q211591 KB211591 September 25, 2003
- 211587 XL2000: CTRL+SHIFT+" Keyboard Shortcut Limited to 1,024 Characters Q211587 KB211587 September 25, 2003
- 211575 XL2000: Indent Option on Alignment Tab Not Available with General Alignment Q211575 KB211575 September 25, 2003
- 211573 XL2000: Undo Does Not Always Restore Previous Value Q211573 KB211573 September 25, 2003
- 211559 XL2000: Chart Data Table Does Not Display All Data Points Q211559 KB211559 September 25, 2003
- 211554 XL2000: Cannot Drag Drawing Objects onto Windows Desktop Q211554 KB211554 September 25, 2003
- 211550 XL2000: Formatting May Be Lost When Pasting Merged Cells Q211550 KB211550 September 25, 2003
- 211535 XL2000: F1 in Custom XLM Dialog Box Displays Office Assistant Q211535 KB211535 September 25, 2003
- 211527 XL2000: Cannot Drag UserForm Control onto a Worksheet Q211527 KB211527 September 25, 2003
- 210826 XL2000: PivotTable List Grouped by Week Becomes Grouped by Month in Exported Excel PivotTable Q210826 KB210826 September 25, 2003
- 210808 XL2000: Page Field Area Missing After Creating PivotTable Q210808 KB210808 September 25, 2003
- 210794 XL2000: PivotChart Button Overlaps Data Labels in Pie Chart Q210794 KB210794 September 25, 2003
- 210790 XL2000: Client-Server Settings Error "Problems Obtaining Data" Q210790 KB210790 September 25, 2003
- 210780 XL2000: Changes Are Not Saved to HTTP or FTP Web Server Q210780 KB210780 September 25, 2003
- 210777 XL2000: Editing Local OLAP Cube Creates New Cube Q210777 KB210777 September 25, 2003
- 210725 XL2000: Copying and Pasting Noncontiguous Range Loses Formulas Q210725 KB210725 September 25, 2003
- 210691 XL2000: Incorrect URL Pasted After Browsing to Web from New Web Query Dialog Box Q210691 KB210691 September 25, 2003
- 221084 OFF2000: Unable to Save .htm and .html File Extensions to Same Location Q221084 KB221084 September 18, 2003
- 270108 OFF2000: Application Error When You Open a Web Page That Contains a Data Object Tag Q270108 KB270108 September 16, 2003