Excel 2003 articles, fixes and updates - January 2007

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Excel 2003 that have been released in January 2007. The list is daily updated.

• 316032 "This command is not available because the document is locked for edit" error message when you try to edit old or new documents in Office XP and in Office 2003 Q316032 KB316032 January 31, 2007
• 313611 XL: Calculated Measures Disappear When OLAP PivotTable Is Grouped Q313611 KB313611 January 31, 2007
• 313454 How to clear the Most Recently Used list (MRU) list in Office programs Q313454 KB313454 January 31, 2007
• 313150 You cannot view Help on the EuroConvert function in Excel Q313150 KB313150 January 31, 2007
• 307812 Troubleshooting navigation issues in Microsoft Excel Q307812 KB307812 January 31, 2007
• 307787 Excel stops responding when you create PivotTable from a very large OLAP cube Q307787 KB307787 January 31, 2007
• 305567 Decimal point or trailing zeros unexpectedly appear in number in Excel Q305567 KB305567 January 31, 2007
• 303263 Gridlines missing from printed worksheet even though printing of gridlines is turned on Q303263 KB303263 January 31, 2007
• 302295 How To Obtain the Window Handle for an Office Automation Server by Using Visual C# .NET Q302295 KB302295 January 31, 2007
• 301418 OLAP cube data is returned alphabetically in a PivotTable report in Excel Q301418 KB301418 January 31, 2007
• 296055 "Cannot find the file" error message when you open Excel files from outside of Excel Q296055 KB296055 January 31, 2007
• 295008 Some characters cause a smart tag list to fail Q295008 KB295008 January 31, 2007
• 293418 Frequently asked questions about using links in Excel 2002 and in later versions of Excel Q293418 KB293418 January 31, 2007
• 293412 Articles about troubleshooting errors in worksheets in Excel Q293412 KB293412 January 31, 2007
• 292481 You cannot dismiss the "number must be between -90 and 90" error message Q292481 KB292481 January 31, 2007
• 292476 Run-Time error when you use the Range.Calculate method in Excel Q292476 KB292476 January 31, 2007
• 292264 You cannot open a password-protected workbook if you forget or lose the password Q292264 KB292264 January 31, 2007
• 291984 Limitations of the Break Links command in Excel Q291984 KB291984 January 31, 2007
• 291310 Some print settings are unavailable when you select multiple sheets in Excel Q291310 KB291310 January 31, 2007
• 291209 How to prevent the automatic creation of hyperlinks in Excel Q291209 KB291209 January 31, 2007
• 291208 Error message when you use the "Application.Dialogs(xlDialogChartWizard).Show" code to display the Chart Wizard dialog box in Excel: "Run-time error '1004': Show method of Dialog class failed" Q291208 KB291208 January 31, 2007
• 291199 "Invalid Use of New Keyword" error using ADODB object library Q291199 KB291199 January 31, 2007
• 291074 Default toolbars and toolbar buttons seen instead of customizations in Excel Q291074 KB291074 January 31, 2007
• 291058 Analysis ToolPak functions unexpectedly return #NAME error value in Excel 2003 and in Excel 2002 Q291058 KB291058 January 31, 2007
• 290359 How to remove leading space for values converted to strings Q290359 KB290359 January 31, 2007
• 289572 You cannot add digital signature to shared workbooks Q289572 KB289572 January 31, 2007
• 289284 You may receive a "Please wait while Office Configures Office Professional" when you start Excel 2002 or 2003 Q289284 KB289284 January 31, 2007
• 289111 In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made Q289111 KB289111 January 31, 2007
• 288979 About speech recognition in Excel Q288979 KB288979 January 31, 2007
• 288968 A blank page appears at the end of a printout in Excel Q288968 KB288968 January 31, 2007
• 288853 Defined name is not removed when you break a link in Excel Q288853 KB288853 January 31, 2007
• 287116 Web page preview does not work Q287116 KB287116 January 31, 2007
• 287114 Error message when you create a custom toolbar in Excel: "Run-Time Error '438'" Q287114 KB287114 January 31, 2007
• 287080 XL: Error Messages When You Add Dimensions to PivotTable Report Q287080 KB287080 January 31, 2007
• 287027 Web query converts numbers that contain hyphens into dates in Excel Q287027 KB287027 January 31, 2007
• 284880 Personal data is not removed as expected when Excel file is saved Q284880 KB284880 January 31, 2007
• 896309 The bullet that is located at the start of the tracer arrows will randomly appear and disappear when you scroll through an Excel worksheet window Q896309 KB896309 January 30, 2007
• 821404 You cannot send e-mail messages from Word, PowerPoint, and Excel Q821404 KB821404 January 30, 2007
• 820590 You cannot forward a fax to another fax recipient in the 2007 Office suites or in Office 2003 Q820590 KB820590 January 30, 2007
• 316653 PRB: Error Using WithEvents or Delegates to Handle Excel Events from Visual Basic .NET or Visual C# .NET Q316653 KB316653 January 30, 2007
• 303872 How To Create an Excel Macro by Using Automation from Visual C# .NET Q303872 KB303872 January 30, 2007
• 303296 How To Use Automation to Get and to Set Office Document Properties with Visual C# .NET Q303296 KB303296 January 30, 2007
• 303018 HOWTO: Use Automation to Create Office Command Bars and Controls with Visual C# .NET Q303018 KB303018 January 30, 2007
• 298017 You receive a "Cannot delete <file name>" error message when you try to delete a file in the Open dialog box or in the Save As dialog box in Office Q298017 KB298017 January 30, 2007
• 283768 Description of the end user privacy policy in application error reporting when you are using Office Q283768 KB283768 January 30, 2007
• 897853 You receive an error message when you use an Office program to try to save a file to a shared drive or to a mapped drive Q897853 KB897853 January 29, 2007
• 286460 How To Set the Mask and Picture Properties for Office XP CommandBars Q286460 KB286460 January 29, 2007
• 285884 How to determine whether VBA is enabled for Office applications Q285884 KB285884 January 29, 2007
• 285337 How To Create a Visual Basic Automation Add-in for Excel Worksheet Functions Q285337 KB285337 January 29, 2007
• 284878 PRB: RTD Servers Used with Embedded Excel Workbooks May Be Problematic Q284878 KB284878 January 29, 2007
• 284869 Universal naming convention path of files in shared XLSTART folder points to local folder Q284869 KB284869 January 29, 2007
• 282855 How to create and use one-input data tables in Microsoft Excel Q282855 KB282855 January 29, 2007
• 282153 Error message when you use a macro to search for a fill color in Excel: "Run-time error '91'" Q282153 KB282153 January 29, 2007
• 282151 Macro that uses FindNext to search for specific format finds wrong cell in Excel Q282151 KB282151 January 29, 2007
• 280680 Cannot follow hyperlink to Office document Q280680 KB280680 January 29, 2007
• 280641 The Excel 97 custom toolbars are not imported when you upgrade from Excel 97 to a later version of Excel Q280641 KB280641 January 29, 2007
• 280590 You are unable to drag information between workbooks in Excel Q280590 KB280590 January 29, 2007
• 280533 Paste Options button does not appear when you paste between two instances of Excel Q280533 KB280533 January 29, 2007
• 277864 A Web page is opened in a new browser window when you click a link in the Web Query dialog box in Excel Q277864 KB277864 January 29, 2007
• 277620 You receive an "Xlquery.xla" error message when you open or save an Excel workbook Q277620 KB277620 January 29, 2007
• 277606 Microsoft Map removed from the computer when you upgrade to Excel 2002 or to Excel 2003 Q277606 KB277606 January 29, 2007
• 272729 How to import data with more than 256 fields or columns into Excel Q272729 KB272729 January 29, 2007
• 272066 Compile error in hidden module Tbrun97.xls in Excel Q272066 KB272066 January 29, 2007
• 271856 Hyperlink does not work when pasted or imported Q271856 KB271856 January 29, 2007
• 268007 How to sort more than three columns in Excel Q268007 KB268007 January 27, 2007
• 265361 XL: Excel Does Not Run on Multiple Processors Q265361 KB265361 January 27, 2007
• 263213 INFO: Excel May Change the Precision Mode of the Floating-Point Control Word Q263213 KB263213 January 27, 2007
• 261997 How To Obtain the Window Handle for an Office Automation Server with MFC Q261997 KB261997 January 27, 2007
• 259137 How to determine whether a selected cell in an Excel worksheet is in a specified defined range by using a Visual Basic macro Q259137 KB259137 January 27, 2007
• 258781 You receive an error message when you try to open multiple documents in Excel Q258781 KB258781 January 27, 2007
• 254008 Gantt Chart Sample Add-In is available for download Q254008 KB254008 January 27, 2007
• 243495 The Calculate message may remain in the status bar when you enter formulas that include cell references Q243495 KB243495 January 25, 2007
• 242237 Worksheet may not recalculate completely when you repeatedly press F9 Q242237 KB242237 January 25, 2007
• 893286 Your changes to the values of the header and of the footer may not be applied in Microsoft Office Excel Q893286 KB893286 January 24, 2007
• 318389 Vector Markup Language is not rendered correctly in Word Q318389 KB318389 January 24, 2007
• 234700 Differences between OLAP and non-OLAP PivotTables in Excel Q234700 KB234700 January 24, 2007
• 232866 The whole Excel workbook may be pasted when you paste only the copied cells into another program Q232866 KB232866 January 24, 2007
• 223789 How to minimize metadata in Microsoft Excel workbooks Q223789 KB223789 January 24, 2007
• 221492 Publishing cells with spilled text creates merged cells in Excel Q221492 KB221492 January 24, 2007
• 221077 Gridlines are not displayed in Web browser Q221077 KB221077 January 24, 2007
• 221070 Decimal points in Accounting format are not aligned in browser in Excel Q221070 KB221070 January 24, 2007
• 215904 Changing a PivotChart removes series formatting in Excel Q215904 KB215904 January 24, 2007
• 215854 Data label legend keys may appear in unexpected positions in Excel Q215854 KB215854 January 24, 2007
• 215573 You receive an error message when you add a chart to a workbook in Excel Q215573 KB215573 January 24, 2007
• 214282 Sorting alphanumeric text as numeric values Q214282 KB214282 January 24, 2007
• 214278 Row Height Changes When You Print to a Different Printer Q214278 KB214278 January 24, 2007
• 214250 Excel cannot open MultiPlan files Q214250 KB214250 January 24, 2007
• 214114 Unexpected result pasting non-contiguous range from Excel into Word Q214114 KB214114 January 24, 2007
• 214070 Description of filtering and extracting a record that contains a text string in Excel Q214070 KB214070 January 24, 2007
• 214058 Days of the week before March 1, 1900 are incorrect in Excel Q214058 KB214058 January 24, 2007
• 214033 Pie Chart Shows Incorrect Percentage Value in Excel Q214033 KB214033 January 24, 2007
• 213923 How to use AutoFilter to filter records based on cell formatting in Excel Q213923 KB213923 January 24, 2007
• 213915 How to create a Gantt chart using hours as the scale Q213915 KB213915 January 24, 2007
• 213886 The AutoFilter status bar displays the "Filter Mode" message in Excel Q213886 KB213886 January 24, 2007
• 213841 Passed strings longer than 255 characters are truncated in Excel Q213841 KB213841 January 24, 2007
• 213823 Macro that changes cell dimensions on multiple sheets does not run as expected Q213823 KB213823 January 24, 2007
• 213798 Sample Visual Basic macros for working with arrays in Excel Q213798 KB213798 January 24, 2007
• 213773 How to create data validation circles for printing in Excel Q213773 KB213773 January 24, 2007
• 213754 How to customize a custom toolbar button Q213754 KB213754 January 24, 2007
• 213740 How to record a macro using relative cell references in Excel Q213740 KB213740 January 24, 2007
• 213719 Description of the Value2 property for the Range object in Excel Q213719 KB213719 January 24, 2007
• 213689 Compile error occurs running a recorded macro that uses the Solver add-in Q213689 KB213689 January 24, 2007
• 213650 Error opening file that refers to shortcut Q213650 KB213650 January 24, 2007
• 213638 How to create a macro that counts comments Q213638 KB213638 January 24, 2007
• 213598 You cannot use the PrintOut method when the custom dialog box is visible Q213598 KB213598 January 24, 2007
• 213495 How to use a formula in Excel to calculate the average of a data sample without the highest and lowest values Q213495 KB213495 January 24, 2007
• 213438 How to programmatically select every nth row in a range in Excel Q213438 KB213438 January 24, 2007
• 213413 Visual Basic macro to show active cell's range names in Excel Q213413 KB213413 January 24, 2007
• 213269 Error handler ignored when Break on All Errors is selected Q213269 KB213269 January 24, 2007
• 213243 Odd refresh behavior after you specify a conditional format in Excel Q213243 KB213243 January 24, 2007
• 213189 Stop Recording Toolbar is not displayed when you record a macro Q213189 KB213189 January 24, 2007
• 212366 Rotated text in an Excel worksheet is displayed horizontally when you view the text in a browser Q212366 KB212366 January 24, 2007
• 212250 Cannot add a data table to some charts in Excel Q212250 KB212250 January 24, 2007
• 212144 Hyphens and apostrophes are sorted after alphabetic letters in Excel Q212144 KB212144 January 24, 2007
• 212074 A Visual Basic procedure that opens a workbook may halt in Excel Q212074 KB212074 January 24, 2007
• 211951 Overview of the built-in chart types in Excel Q211951 KB211951 January 24, 2007
• 211933 Chart display options change according to page setup Q211933 KB211933 January 24, 2007
• 211835 How to control the placement of objects Q211835 KB211835 January 24, 2007
• 919026 Error message when you try to open or to save a 2007 Office document: "Do you want to download a compatibility pack so that you can work with this file" Q919026 KB919026 January 23, 2007
• 813972 Error message when you try to edit multiple cells in a protected worksheet by using a single password in Excel: "Some of the cells you are trying to change are password protected" Q813972 KB813972 January 23, 2007
• 214042 You receive an error message when you access files from a floppy disk in Excel Q214042 KB214042 January 23, 2007
• 211816 Comments may not be printed as expected Q211816 KB211816 January 23, 2007
• 211580 Only 1,024 characters are displayed in a cell in Excel Q211580 KB211580 January 23, 2007
• 211557 Additional columns or rows that are not selected may be added to the print titles when you create print titles on a worksheet in Excel Q211557 KB211557 January 23, 2007
• 211515 Using server page fields in PivotTables in Excel Q211515 KB211515 January 23, 2007
• 210320 Web page saved in Excel displays differently in Web browser Q210320 KB210320 January 23, 2007
• 209121 Excel HTML file always displayed at 100 percent zoom Q209121 KB209121 January 23, 2007
• 205548 How to use A functions in Excel Q205548 KB205548 January 23, 2007
• 201487 Patterns do not display in a Web browser in Excel Q201487 KB201487 January 23, 2007
• 189897 Data truncated to 255 characters with Excel ODBC driver Q189897 KB189897 January 23, 2007
• 829252 You may obtain incorrect results and misleading labels when you use the Analysis ToolPak t-Test in Excel Q829252 KB829252 January 22, 2007
• 829208 Description of the effects of the improved statistical functions for the Analysis ToolPak in Excel Q829208 KB829208 January 22, 2007
• 182812 Description of the Value2 property for the Range object Q182812 KB182812 January 22, 2007
• 182197 The General number format rounds off real numbers in Excel Q182197 KB182197 January 22, 2007
• 181201 HLOOKUP, VLOOKUP, LOOKUP return incorrect values in Excel Q181201 KB181201 January 22, 2007
• 176838 You receive an error message when you use the Paste Special command in Excel Q176838 KB176838 January 22, 2007
• 898511 When you programmatically save a workbook in Excel, a menu command does not run in the BeforeSave event Q898511 KB898511 January 20, 2007
• 171595 How to Change the ToolTip for a Custom Toolbar Control Q171595 KB171595 January 20, 2007
• 831592 Cannot change the data type in a Parameter Query in Microsoft Query Q831592 KB831592 January 19, 2007
• 829248 Excel statistical functions: VAR and VARP improvements and data consolidation Q829248 KB829248 January 19, 2007
• 827314 Error messages when you save to an earlier file format if Transition Formula Evaluation is enabled Q827314 KB827314 January 19, 2007
• 315996 You receive an "Error 1305: Setup Cannot Read File" error message when you install Office 2003 Q315996 KB315996 January 19, 2007
• 164317 How to sum a range of cells based on a number format in Excel Q164317 KB164317 January 19, 2007
• 162814 Sample macros to return ID for a CommandBar control Q162814 KB162814 January 19, 2007
• 162028 Formatting is not retained in PivotTable in Excel Q162028 KB162028 January 19, 2007
• 151364 Glossary of charting terminology in Excel Q151364 KB151364 January 19, 2007
• 149235 How to help prevent file corruption in Excel Q149235 KB149235 January 19, 2007
• 141692 Visual Basic Example to Retrieve Value from Last Cell Q141692 KB141692 January 19, 2007
• 123183 How to export data to a text file with comma and quote delimiter in Excel Q123183 KB123183 January 19, 2007
• 119826 Macro to Remove Hidden Names in Active Workbook Q119826 KB119826 January 19, 2007
• 927198 MS07-002: Vulnerabilities in Microsoft Excel could allow remote code execution Q927198 KB927198 January 18, 2007
• 887297 You receive an error when you create an OLAP cube-based PivotTable in Excel Q887297 KB887297 January 18, 2007
• 828695 Possible to Obtain Password to SQL Database Attached to OWC PivotTable in Office Excel 2003 Q828695 KB828695 January 18, 2007
• 828335 Excel statistical functions: LOGINV Q828335 KB828335 January 18, 2007
• 828334 Excel statistical functions: GAMMAINV Q828334 KB828334 January 18, 2007
• 828332 Excel statistical functions: FINV Q828332 KB828332 January 18, 2007
• 828296 Description of the ZTEST function in Excel Q828296 KB828296 January 18, 2007
• 828117 Excel statistical functions: CRITBINOM Q828117 KB828117 January 18, 2007
• 827733 You receive an error message when you try to install an XML expansion pack in Office Word 2003 or Office Excel 2003 Q827733 KB827733 January 18, 2007
• 826409 Description of the STDEVA statistical function in Excel Q826409 KB826409 January 18, 2007
• 826406 Excel statistical functions: STDEVP Q826406 KB826406 January 18, 2007
• 826393 Excel statistical functions: VARP Q826393 KB826393 January 18, 2007
• 277592 Delete Watch button is available even though no listed cells are selected in Excel Q277592 KB277592 January 18, 2007
• 100825 #VALUE error when you add text and values in Excel Q100825 KB100825 January 18, 2007
• 832665 "You need the administrative version of this update due to previously applied administrative updates" error message when you look for Office Updates Q832665 KB832665 January 17, 2007
• 826371 Excel statistical functions: VARA Q826371 KB826371 January 17, 2007
• 823981 HOW TO: Handle Events for Excel by Using Visual C# .NET Q823981 KB823981 January 17, 2007
• 310744 How To Dismiss a Dialog Box Displayed by an Office Application by Using Visual C++ .NET and MFC Q310744 KB310744 January 17, 2007
• 308409 PRB: Visual Basic .NET Error Using GetObject or GetActiveObject for Running Instance of Office Application Q308409 KB308409 January 17, 2007
• 307292 How To: Dismiss a Dialog Box Displayed by an Office Application with Visual Basic .NET Q307292 KB307292 January 17, 2007
• 304661 How To Use Visual Basic .NET for Binding for Office Automation Servers Q304661 KB304661 January 17, 2007
• 259971 How To Dismiss a Dialog Box Displayed by an Office Application with Visual Basic Q259971 KB259971 January 17, 2007
• 823573 How to determine the number of unique items in a list in versions 97, 2000, and 2002 of Excel Q823573 KB823573 January 16, 2007
• 289255 Microsoft Excel does not automatically shift manual page breaks when you delete or insert rows in the Microsoft Excel Workbook 5.0/95 format file Q289255 KB289255 January 16, 2007
• 908003 FIX: Office 2003 crashes when you try to close a Word document or an Excel spreadsheet from a WinForm control in a Visual Studio Tools for the Office System version 2003 solution Q908003 KB908003 January 15, 2007
• 823988 BUG: You cannot delete an Excel list row from the CommandButton Click event Q823988 KB823988 January 15, 2007
• 930477 A color hairline border in an Excel worksheet may be printed as a black solid border that has a heavier line weight Q930477 KB930477 January 12, 2007
• 895618 An Office update does not appear to be installed after you install the update Q895618 KB895618 January 12, 2007
• 283626 You can only find the cells that exactly match the formatting based on the existing cell in Excel Q283626 KB283626 January 12, 2007
• 829215 Description of numeric improvement in Analysis ToolPak ANOVA tools in Excel Q829215 KB829215 January 10, 2007
• 287102 Data in target cells is lost when you use the "Paste Special" command in Excel Q287102 KB287102 January 10, 2007
• 277582 Error message when you use the Lookup Wizard in Excel: "Run-time error '1004' Application-defined or object-defined error" Q277582 KB277582 January 10, 2007
• 268016 Internet Explorer cannot open an Excel Add-In (*.xla) file Q268016 KB268016 January 10, 2007
• 838905 Description of the Office 2003 security update: September 14, 2004 Q838905 KB838905 January 9, 2007
• 838022 Description of the Office 2003 Dutch Spelling Checker Update: May 25, 2004 Q838022 KB838022 January 9, 2007
• 902988 How to perform a chain installation of Office 2003 and Office 2003 updates Q902988 KB902988 January 8, 2007
• 898058 Description of the Office 2003 post-Service Pack 1 hotfix package: April 28, 2005 Q898058 KB898058 January 8, 2007
• 154876 You receive an error message when you use right bracket in text file name in Excel 2003 and earlier versions Q154876 KB154876 January 6, 2007
• 903776 Office updates are not successfully installed if you deploy updates by using Windows Server Update Services or the Microsoft Update Web site after the path of the local installation source changes Q903776 KB903776 January 5, 2007
• 834681 FIX: You may receive "The command you selected is not available from this shortcut" error message when you use the Open dialog box or the Save dialog box in Excel 2003 Q834681 KB834681 January 5, 2007
• 830168 Frequently asked questions about the Local Install Source feature in Office 2003 Q830168 KB830168 January 5, 2007
• 826826 BUG: The Code Is Not Disabled If You Press and Then Hold Down the SHIFT Key While You Open a Microsoft Excel Workbook from the Getting Started Task Pane Q826826 KB826826 January 5, 2007
• 824007 PRB: ActiveX Control Events Are Not Handled When the Excel Macro Security Level Is Set to High Q824007 KB824007 January 5, 2007
• 279408 PRB: Office Application That Hosts a Custom ActiveX Control Fails on the Save or Save As Method Q279408 KB279408 January 5, 2007
• 930204 The specifications for the smallest and largest allowed positive and negative numbers are wrong in the Help files for Excel Q930204 KB930204 January 4, 2007
• 282034 You receive an unexpected result when you compare the results of the "Application.Version" property to another string value in Excel Q282034 KB282034 January 3, 2007