Excel 2002 (Excel XP) 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 2002 (Excel XP) that have been released in January 2007. The list is daily updated.

• 317385 XL2002: SHIFT+SPACEBAR Keyboard Shortcut Does Not Work with Hangul Input Mode on Windows 2000 Q317385 KB317385 January 31, 2007
• 316619 OFFXP: Flipped Images Lose Their Flipped Properties in VBA When Saved Q316619 KB316619 January 31, 2007
• 316618 OFFXP: Objects May Not Be Displayed Correctly When You Use Third-Party Magnification Software Q316618 KB316618 January 31, 2007
• 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
• 316027 Linked Excel charts in Office documents do not update after you change MUI Language Q316027 KB316027 January 31, 2007
• 315997 OFFXP: Data Is Unexpectedly Dropped from a PivotTable After You Remove a Field Q315997 KB315997 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
• 313048 HOW TO: Change the Default "Save Prompt" Text When Users Save an Office XP Document in an Alternate Format Q313048 KB313048 January 31, 2007
• 312510 OFF: Some Files Are Not Found When You Search for Office Documents Q312510 KB312510 January 31, 2007
• 312385 OFFXP: Right-to-Left Text in Excel Objects Is Printed Incorrectly from Word Q312385 KB312385 January 31, 2007
• 312384 OFFXP: Drawing Elements in Right-to-Left Excel Object Are Displayed or Printed Incorrectly When Pasted into Word Q312384 KB312384 January 31, 2007
• 307818 OFF: Error Message When You Click a Hyperlink in an Office Document Q307818 KB307818 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
• 306986 You receive an "An Internal Error has occurred” or a “Setup cannot create the folder” when you install Office XP Q306986 KB306986 January 31, 2007
• 305567 Decimal point or trailing zeros unexpectedly appear in number in Excel Q305567 KB305567 January 31, 2007
• 305511 OFFXP: Smart Tag Indicators Do Not Appear or Work as Expected in Your Document Q305511 KB305511 January 31, 2007
• 304861 OFFXP: "Handwriting Recognition in Office XP" White Paper Available for Download Q304861 KB304861 January 31, 2007
• 304860 Description of the "Speech Recognition in Office XP" white paper Q304860 KB304860 January 31, 2007
• 304648 OFFXP: An Arabic Presentation Forms Character Changes to a Question Mark in an Enhanced Metafile Q304648 KB304648 January 31, 2007
• 304494 How to use Visual Basic for Applications in Excel Q304494 KB304494 January 31, 2007
• 304359 "The drive or network connection that the shortcut 'Insert Visio Button.DOT.LNK' refers to is unavailable" error message when you start Word or Excel after you upgrade to Visio 2002 Q304359 KB304359 January 31, 2007
• 303491 "Shortcut to Desktop" Command Does Not Work When Office Document Is Open in Internet Explorer Q303491 KB303491 January 31, 2007
• 303475 File download dialog box appears when you open Office XP file in browser Q303475 KB303475 January 31, 2007
• 303263 Gridlines missing from printed worksheet even though printing of gridlines is turned on Q303263 KB303263 January 31, 2007
• 303048 You receive a "Please wait while the wizard initializes..." error message when the Activation Wizard dialog box appears Q303048 KB303048 January 31, 2007
• 302841 ACC2002: Hyperlink Text Changes to Question Marks When You Paste the Text into Other Office Programs Q302841 KB302841 January 31, 2007
• 302598 OFFXP: Dictation Mode Does Not Start When You Start Speech Recognition Q302598 KB302598 January 31, 2007
• 302460 The Office XP Automation Help file is available for download Q302460 KB302460 January 31, 2007
• 302382 Money: How to Export a Money Report to an Excel Worksheet Q302382 KB302382 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
• 301990 "The Office Assistant requires Microsoft Agent 2.0 or later" error message when you start an Office XP program or use the Office Assistant in a program Q301990 KB301990 January 31, 2007
• 301418 OLAP cube data is returned alphabetically in a PivotTable report in Excel Q301418 KB301418 January 31, 2007
• 301403 OFFXP: How to Access Smart Tag Menus from the Keyboard Q301403 KB301403 January 31, 2007
• 300912 Office programs that have a Voodoo3 driver installed stop responding (hang) and you recieve error messages Q300912 KB300912 January 31, 2007
• 298411 OFFXP: 3-D Style Effect Ignores Other Object Attributes Q298411 KB298411 January 31, 2007
• 298019 OFFXP: Error Message: No Program Is Registered to Open This File Q298019 KB298019 January 31, 2007
• 298018 OFFXP: Error Message: Cannot Save <File Name> in Recent Folder Q298018 KB298018 January 31, 2007
• 297891 You experience performance and memory problems when you switch between a Web browser and the Office XP programs Q297891 KB297891 January 31, 2007
• 296665 XL2000: Data Labels Do Not Retain Formatting Q296665 KB296665 January 31, 2007
• 296446 Only one icon appears in Taskbar when Windows in Taskbar is selected in Excel 2002 and PowerPoint 2002 Q296446 KB296446 January 31, 2007
• 296055 "Cannot find the file" error message when you open Excel files from outside of Excel Q296055 KB296055 January 31, 2007
• 295365 OFFXP: Office Assistant Is Hidden When You Click Help Topic Suggestion Q295365 KB295365 January 31, 2007
• 295342 OFFXP: New Dialog Box Does Not Appear When You Click New on File Menu Q295342 KB295342 January 31, 2007
• 295008 Some characters cause a smart tag list to fail Q295008 KB295008 January 31, 2007
• 294916 Graphics or text may be corrupted when you scroll in a document or resize a window in an Office XP program Q294916 KB294916 January 31, 2007
• 294653 Program stops responding after you click Spelling and Grammar on Tools menu Q294653 KB294653 January 31, 2007
• 294109 Shapes in resized embedded Visio object are not visible in Visio 2002 Q294109 KB294109 January 31, 2007
• 293615 Organization charts from Office 2000 programs appear different in Office XP programs Q293615 KB293615 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
• 293368 OFFXP: Blue Color Used Twice If Venn Diagram Uses Primary Colors Style Q293368 KB293368 January 31, 2007
• 293205 OFFXP: Curves in AutoShapes Are Printed as Line Segments Q293205 KB293205 January 31, 2007
• 293184 HOW TO: Determine the Order in Which Shapes Are Added to Diagrams in Office Programs Q293184 KB293184 January 31, 2007
• 292583 OFFXP: Product ID in Splash Screen May Be Different from About <Program Name> Dialog Box Q292583 KB292583 January 31, 2007
• 292502 OFFXP: Earlier Versions of Office Programs Are Listed in Microsoft Office Application Recovery Utility Q292502 KB292502 January 31, 2007
• 292499 Image does not appear in thumbnail view after removing Office Q292499 KB292499 January 31, 2007
• 292481 You cannot dismiss the "number must be between -90 and 90" error message Q292481 KB292481 January 31, 2007
• 292477 OAER: Excel Stops Responding When You Scroll Through Categories in Insert Function Dialog Box Q292477 KB292477 January 31, 2007
• 292476 Run-Time error when you use the Range.Calculate method in Excel Q292476 KB292476 January 31, 2007
• 292466 OFFXP: Unable to Select a Menu Item by Using a Voice Command Q292466 KB292466 January 31, 2007
• 292264 You cannot open a password-protected workbook if you forget or lose the password Q292264 KB292264 January 31, 2007
• 292163 OFFXP: Inferno.log File Is Created and Updated When You Use the Handwriting Feature Q292163 KB292163 January 31, 2007
• 292136 WD2002: Smart Tag Indicators Don't Appear in Document After You Turn on Smart Tags Q292136 KB292136 January 31, 2007
• 292070 OFFXP: HTML File Saved as FrontPage Web Appears in Broken Hyperlinks Report Q292070 KB292070 January 31, 2007
• 291984 Limitations of the Break Links command in Excel Q291984 KB291984 January 31, 2007
• 291912 You receive a virus warning message when you click hyperlink to a program in Office 2002 or Office 2000 Q291912 KB291912 January 31, 2007
• 291311 XL2002: "File Not Loaded Completely" Error Message When You Run the Text Import Wizard Q291311 KB291311 January 31, 2007
• 291310 Some print settings are unavailable when you select multiple sheets in Excel Q291310 KB291310 January 31, 2007
• 291301 "ActiveX component can't create object" error message when you use Data Access Objects version 3.0 (DAO 3.0) Q291301 KB291301 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
• 291206 XL2002: Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High Q291206 KB291206 January 31, 2007
• 291199 "Invalid Use of New Keyword" error using ADODB object library Q291199 KB291199 January 31, 2007
• 291081 XL2002: 12:00:00 AM Is Displayed for Dates Earlier Than 1900 Q291081 KB291081 January 31, 2007
• 291074 Default toolbars and toolbar buttons seen instead of customizations in Excel Q291074 KB291074 January 31, 2007
• 291064 How to save files in other formats in Excel 2002 Q291064 KB291064 January 31, 2007
• 291058 Analysis ToolPak functions unexpectedly return #NAME error value in Excel 2003 and in Excel 2002 Q291058 KB291058 January 31, 2007
• 291051 List of supported file formats in Excel 2002 Q291051 KB291051 January 31, 2007
• 291048 OFFXP: Language Bar Is Minimized or Closed If You Minimize or Close an Office Program Q291048 KB291048 January 31, 2007
• 290577 OFFXP: Office Assistant Not Answering Visual Basic for Applications Questions Q290577 KB290577 January 31, 2007
• 290524 OFFXP: E-mail Button Does Not Appear on the Standard Toolbar Q290524 KB290524 January 31, 2007
• 290378 OFFXP: You Are Prompted for User Name When You Start a Program on Windows NT or Windows 2000 Q290378 KB290378 January 31, 2007
• 290376 OFFXP: Error Message When You Add an ActiveX Control to a VBA UserForm Q290376 KB290376 January 31, 2007
• 290374 How to display all menu commands in Office XP programs Q290374 KB290374 January 31, 2007
• 290368 You receive an "Error Starting Msinfo32.exe" error message when you start system information Q290368 KB290368 January 31, 2007
• 290364 OFFXP: Only One Icon Appears on the Taskbar When "Windows in Taskbar" Option Is Selected Q290364 KB290364 January 31, 2007
• 290359 How to remove leading space for values converted to strings Q290359 KB290359 January 31, 2007
• 290298 OFFXP: How to Publish a Web Document to an FTP Site Q290298 KB290298 January 31, 2007
• 290157 OFFXP: Invalid Page Fault When You Run an Office Program Q290157 KB290157 January 31, 2007
• 290155 OFFXP: HTML File Opens in the Last Office Program in Which It Was Edited Q290155 KB290155 January 31, 2007
• 290150 OFFXP: How to Programmatically Hide and Unhide the Windows Taskbar Q290150 KB290150 January 31, 2007
• 290118 OFFXP: Error Message When You Use Quick View: Could Not View <File Name>, the Viewer Returned an Unknown Error Q290118 KB290118 January 31, 2007
• 290115 OFFXP: Control How and When the Office Assistant Appears Q290115 KB290115 January 31, 2007
• 289572 You cannot add digital signature to shared workbooks Q289572 KB289572 January 31, 2007
• 289314 STS: Office Program Stops Responding When You Connect to SharePoint Team Web Site Q289314 KB289314 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
• 289245 HOW TO: Use the Excel Formula Evaluator in Excel 2002 Q289245 KB289245 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
• 289006 You may receive an error message or the Publisher icon becomes generic or no longer appears in the Start menu when you start an Office program Q289006 KB289006 January 31, 2007
• 288986 HOW TO: Use Text-to-Speech in Excel 2002 Q288986 KB288986 January 31, 2007
• 288985 Description of digital signatures in Excel 2002 workbooks Q288985 KB288985 January 31, 2007
• 288981 HOW TO: Use Speech Recognition to Select Cells, Rows, and Columns in Excel Q288981 KB288981 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
• 288964 How to insert a picture into the header or footer in Excel 2002 Q288964 KB288964 January 31, 2007
• 288853 Defined name is not removed when you break a link in Excel Q288853 KB288853 January 31, 2007
• 288839 XL: Exported Comma Separated File Ignores Regional Settings Q288839 KB288839 January 31, 2007
• 288729 General information about licensing and using Office XP Web Components Q288729 KB288729 January 31, 2007
• 288543 INFO: The Microsoft Office XP FileDialog Object Q288543 KB288543 January 31, 2007
• 288542 INFO: Customizing the Microsoft Office XP Task Pane Q288542 KB288542 January 31, 2007
• 287734 XL2002: Excel Saves XML Files in the XML Spreadsheet Format Q287734 KB287734 January 31, 2007
• 287698 OFFXP: How to Create a Microsoft Office Smart Tag List Q287698 KB287698 January 31, 2007
• 287135 OFFXP: Windows Installer Starts with /Safe Switch Q287135 KB287135 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
• 287113 XL2002: AutoSum Button Unexpectedly Returns Values from Hidden Cells in List with AutoFilter Q287113 KB287113 January 31, 2007
• 287105 XL2002: Excel Opens Workbook in Repair Mode When Workbook Contains Macros Q287105 KB287105 January 31, 2007
• 287080 XL: Error Messages When You Add Dimensions to PivotTable Report Q287080 KB287080 January 31, 2007
• 287038 OFFXP: System Info on Windows Me Is Not Refreshed When You Press F5 Q287038 KB287038 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
• 277617 RTD formula evaluates to #N/A in Excel Q277617 KB277617 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
• 316723 PRB: Visual Studio .NET Shared Add-in Is Not Displayed in Office COM Add-ins Dialog Box Q316723 KB316723 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
• 286394 OFFXP: "Remove Personal Information from This File on Save" May Not Work with Macros Q286394 KB286394 January 29, 2007
• 285884 How to determine whether VBA is enabled for Office applications Q285884 KB285884 January 29, 2007
• 285488 OFFXP: No Warning When You Overwrite File on FTP Server Q285488 KB285488 January 29, 2007
• 285337 How To Create a Visual Basic Automation Add-in for Excel Worksheet Functions Q285337 KB285337 January 29, 2007
• 284889 OFFXP: Error in Help Topic "Turn On or Off Transparent Floating Toolbars" Q284889 KB284889 January 29, 2007
• 284878 PRB: RTD Servers Used with Embedded Excel Workbooks May Be Problematic Q284878 KB284878 January 29, 2007
• 284874 XL2002: Excel Ignores "Number of Copies" Setting When Printing from Desktop Q284874 KB284874 January 29, 2007
• 284871 XL2002: Error Message: Did Not Find Anything to Print Q284871 KB284871 January 29, 2007
• 284869 Universal naming convention path of files in shared XLSTART folder points to local folder Q284869 KB284869 January 29, 2007
• 284866 Excel 2002 Stops Responding After You Save File in Excel 97-2002 & 5.0/95 Workbook Format Q284866 KB284866 January 29, 2007
• 283633 HOW TO: Display or Hide the Ask a Question Box in Microsoft Office Q283633 KB283633 January 29, 2007
• 282855 How to create and use one-input data tables in Microsoft Excel Q282855 KB282855 January 29, 2007
• 282166 XL2002&#58; Smart Tags Are Not Re-Pasted When &#34;Redo Paste&#34; Command Is Used Q282166 KB282166 January 29, 2007
• 282155 XL2002: Unable to Insert Workbook If Open in More Than One Window Q282155 KB282155 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
• 282144 OFFXP: Custom Graph Types in Graph Are Not Shared Q282144 KB282144 January 29, 2007
• 282033 XL2002: Error Message: Run-Time Error '1004': Programmatic Access to the Visual Basic Project Is Not Trusted Q282033 KB282033 January 29, 2007
• 280680 Cannot follow hyperlink to Office document Q280680 KB280680 January 29, 2007
• 280660 OFFXP: No Date or Time Information Available When Program Stops Responding in Windows 98 or Windows Me Q280660 KB280660 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
• 280611 OFFXP: Unable to Delete Web Folder Created on the MSN Network Q280611 KB280611 January 29, 2007
• 280608 OFFXP: Unable to Copy Same Selection of Drawing Objects to the Clipboard As Separate Selection Q280608 KB280608 January 29, 2007
• 280605 OFFXP: Additional Icon Displayed When You Press ALT+TAB to Cycle Through Multiple Open Documents in Office Program Q280605 KB280605 January 29, 2007
• 280602 OFFXP: Error Message When You Save to My Web Sites on MSN Q280602 KB280602 January 29, 2007
• 280600 OFFXP: Paste All Command from Office Clipboard Preserves Copy Order, Not Display Order Q280600 KB280600 January 29, 2007
• 280598 OFFXP: Mouse Clicks and Keyboard Commands Trigger Beeps, and Office Assistant Is Not Visible Q280598 KB280598 January 29, 2007
• 280592 OFFXP: Cannot Reset Changed Control Styles in Menu Commands or Toolbar Buttons Q280592 KB280592 January 29, 2007
• 280590 You are unable to drag information between workbooks in Excel Q280590 KB280590 January 29, 2007
• 280570 OFFXP: Unable to Sign Out of Microsoft Passport When Office Is Running in Reduced Functionality Mode Q280570 KB280570 January 29, 2007
• 280567 Shared software components are removed when you uninstall Office 2000 Q280567 KB280567 January 29, 2007
• 280553 Multiple Office Clipboard icons are displayed in the system tray in Office XP Q280553 KB280553 January 29, 2007
• 280548 OFFXP: Command Names Truncated in Commands List in Customize Dialog Box Q280548 KB280548 January 29, 2007
• 280546 OFFXP: User Name and Company Name in Splash Screen Different from Names in "About" Dialog Box Q280546 KB280546 January 29, 2007
• 280540 OFFXP: No Apparent Keyboard Command to Close the Task Pane Q280540 KB280540 January 29, 2007
• 280534 OFFXP: Paste All and Then Undo Only Undoes Most Recent Entry Q280534 KB280534 January 29, 2007
• 280533 Paste Options button does not appear when you paste between two instances of Excel Q280533 KB280533 January 29, 2007
• 279721 How to use Dynamic Data Exchange (DDE) with Word and Excel from Visual C++ Q279721 KB279721 January 29, 2007
• 278976 How To Use XSL to Transform Excel XML Spreadsheet for Server-Side Use Q278976 KB278976 January 29, 2007
• 278579 OFFXP: "Remove Personal Information" Option Does Not Apply to Inserted Objects Q278579 KB278579 January 29, 2007
• 278543 Excel objects appear truncated when you paste them in PowerPoint 2002 Q278543 KB278543 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
• 277621 XL2002: Export to Microsoft Excel Command in Internet Explorer Does Nothing Q277621 KB277621 January 29, 2007
• 277620 You receive an "Xlquery.xla" error message when you open or save an Excel workbook Q277620 KB277620 January 29, 2007
• 277618 XL2002: Calling a Server by Using the RealTimeData (RTD) Function Q277618 KB277618 January 29, 2007
• 277614 XL2002: Inconsistent Error Flags for Formulas in Worksheet Cells Q277614 KB277614 January 29, 2007
• 277608 XL2002: Macro High Security Warning or User Defined Functions Display #Name? Q277608 KB277608 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
• 277577 XL2002: Error Message: Run-Time Error 1004: Unable to Set the LineStyle Property of the Border Class Q277577 KB277577 January 29, 2007
• 272729 How to import data with more than 256 fields or columns into Excel Q272729 KB272729 January 29, 2007
• 272256 BUG: MFC ActiveX Document Container Hangs During Shutdown on Windows 2000 Q272256 KB272256 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
• 269168 How to recognize the difference among Excel 97 files, Excel 2000 files, and Excel 2002 files by using Visual C++ 6.0 Q269168 KB269168 January 27, 2007
• 268007 How to sort more than three columns in Excel Q268007 KB268007 January 27, 2007
• 266318 How to retrieve the name of an Office document that contains an MFC ActiveX control Q266318 KB266318 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
• 257464 Hyperlinks in an e-mail message do not work in Office 2000 or in Office 2002 programs Q257464 KB257464 January 27, 2007
• 254008 Gantt Chart Sample Add-In is available for download Q254008 KB254008 January 27, 2007
• 254006 INFO: Access Data Retrieval Sample Add-In Available for Download Q254006 KB254006 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
• 241861 BUG: ATL Control in Office Document Prevents Another Control's Events from Working Q241861 KB241861 January 25, 2007
• 318389 Vector Markup Language is not rendered correctly in Word Q318389 KB318389 January 24, 2007
• 238228 How to build an Office 2000 COM add-in in Visual Basic Q238228 KB238228 January 24, 2007
• 238133 How To Write a DDEML Server for Excel and Use it with NetDDE Q238133 KB238133 January 24, 2007
• 236872 You receive an "I/O Error" or the subfolders are displayed as question marks or squares in Office programs Q236872 KB236872 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
• 231614 How To Automate Excel to Create a New Workbook from Delphi Q231614 KB231614 January 24, 2007
• 229006 XL: Colors in HTML File Don't Appear as Expected When Opening Page in Excel Q229006 KB229006 January 24, 2007
• 225029 How To Determine Which Version of Excel Wrote a Workbook Q225029 KB225029 January 24, 2007
• 224925 INFO: Type Libraries for Office May Change with New Release Q224925 KB224925 January 24, 2007
• 223789 How to minimize metadata in Microsoft Excel workbooks Q223789 KB223789 January 24, 2007
• 223396 How to minimize metadata in Office documents Q223396 KB223396 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
• 215783 XL: "Excel Could Not Save All the Data and Formatting" Error Message Q215783 KB215783 January 24, 2007
• 215573 You receive an error message when you add a chart to a workbook in Excel Q215573 KB215573 January 24, 2007
• 214797 How To Automate Excel Using Perl for Win32 Q214797 KB214797 January 24, 2007
• 214462 PRB: Error "Bound to Unknown Type" Inserting ATL Control in VBA UserForm Q214462 KB214462 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
• 214275 XL: Using 16-Bit and 32-Bit ODBC Drivers Q214275 KB214275 January 24, 2007
• 214264 XL: How to Perform a Case-Sensitive Lookup Q214264 KB214264 January 24, 2007
• 214263 XL: Example on Use of Solver Q214263 KB214263 January 24, 2007
• 214259 How to use grouping for fields in a PivotTable in Excel Q214259 KB214259 January 24, 2007
• 214250 Excel cannot open MultiPlan files Q214250 KB214250 January 24, 2007
• 214249 How to use the Conditional Sum Wizard in Microsoft Excel Q214249 KB214249 January 24, 2007
• 214133 XL: Formula for Distance/Velocity Returned in Hours, Minutes, and Seconds Q214133 KB214133 January 24, 2007
• 214114 Unexpected result pasting non-contiguous range from Excel into Word Q214114 KB214114 January 24, 2007
• 214093 XL: How to Display the Current Date and Time with Text Q214093 KB214093 January 24, 2007
• 214091 XL: Finding the Balance of a Loan for a Given Period Q214091 KB214091 January 24, 2007
• 214084 XL: How to Display the File Name of a Worksheet Without Using a Macro Q214084 KB214084 January 24, 2007
• 214070 Description of filtering and extracting a record that contains a text string in Excel Q214070 KB214070 January 24, 2007
• 214069 XL: How to Return the First or Last Match in an Array Q214069 KB214069 January 24, 2007
• 214058 Days of the week before March 1, 1900 are incorrect in Excel Q214058 KB214058 January 24, 2007
• 214048 You receive a "This file is not in a recognizable format" error message when you try to open a file in Works 3.0 or 4.0 format in Excel 2000 or Excel 2002 Q214048 KB214048 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
• 213901 XL: General Number Format Applied to Improper Time Entry Q213901 KB213901 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
• 213837 How to run subroutines and macros from Visual Basic in Excel 2000 or Excel 2002 Q213837 KB213837 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
• 213772 How to use system, user, and file data source names (DSN) in Excel 2000 or Excel 2002 Q213772 KB213772 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
• 213507 XL: How to Count Cells That Contain Formulas, Text, or Numbers Q213507 KB213507 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
• 213476 XL: Unexpected Results with Mixed Text and Numbers in Lookup Table Q213476 KB213476 January 24, 2007
• 213447 XL: Visual Basic Module to Create a Gantt Chart Q213447 KB213447 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
• 213343 XL: How to Put Folder Contents into a Worksheet Q213343 KB213343 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
• 212064 XL: F4 Key Does Not Change Cell Formula Reference As Expected Q212064 KB212064 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
• 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
• 207475 DOC: Excel BIFF8 CONTINUE Record Information Is Incomplete Q207475 KB207475 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
• 199201 XL: Cannot Move or Resize Chart Objects in a PivotChart Q199201 KB199201 January 23, 2007
• 194611 How To Create and Call an Excel Macro Programmatically from VB Q194611 KB194611 January 23, 2007
• 189897 Data truncated to 255 characters with Excel ODBC driver Q189897 KB189897 January 23, 2007
• 186122 How to use MFC to automate Excel 2000 and Excel 2002 and obtain an array from a range in Excel 2000 and Excel 2002 Q186122 KB186122 January 23, 2007
• 186120 How To Use MFC to Automate Excel and Fill a Range with an Array Q186120 KB186120 January 23, 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
• 181889 BUG: VB Hangs While Automating Excel Using OLE Control Q181889 KB181889 January 22, 2007
• 181201 HLOOKUP, VLOOKUP, LOOKUP return incorrect values in Excel Q181201 KB181201 January 22, 2007
• 180312 HOWTO: Use Automation to Set the Printer from an MFC Project Q180312 KB180312 January 22, 2007
• 179824 XL: Features and Formatting Lost Saving to Excel 5.0/95 Q179824 KB179824 January 22, 2007
• 179706 How to use MFC to automate Excel and create and format a new workbook Q179706 KB179706 January 22, 2007
• 178783 How To Use MFC to Create a Microsoft Excel Chart Q178783 KB178783 January 22, 2007
• 178782 How To Use MFC to Automate Excel and Navigate Worksheets Q178782 KB178782 January 22, 2007
• 178605 How To Determine the Version of a Microsoft Excel Workbook Q178605 KB178605 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
• 171280 PRB: Error Message "Cannot insert object" in Excel Q171280 KB171280 January 20, 2007
• 831592 Cannot change the data type in a Parameter Query in Microsoft Query Q831592 KB831592 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
• 168437 XL: Unable to Select Defined Names by Using Function Wizard Q168437 KB168437 January 19, 2007
• 164383 No Tables Appear in Add Tables Dialog Box Q164383 KB164383 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
• 141762 XL: How to Use Looping Structures in Visual Basic for Applications Q141762 KB141762 January 19, 2007
• 141692 Visual Basic Example to Retrieve Value from Last Cell Q141692 KB141692 January 19, 2007
• 134913 XL: GetCustomListNum Returns Unexpected List Number Q134913 KB134913 January 19, 2007
• 131384 XL: EVALUATE() Function with INDIRECT() Returns #REF! Error Q131384 KB131384 January 19, 2007
• 123198 XL: How to Compute the Average Growth Rate of an Investment Q123198 KB123198 January 19, 2007
• 123183 How to export data to a text file with comma and quote delimiter in Excel Q123183 KB123183 January 19, 2007
• 121824 Toolbar Button Capable of Alternate Action Q121824 KB121824 January 19, 2007
• 119826 Macro to Remove Hidden Names in Active Workbook Q119826 KB119826 January 19, 2007
• 119083 XL: MOD() Function Returns #NUM! Error Value Q119083 KB119083 January 19, 2007
• 117128 XL: Hidden Cells in a Worksheet May Become Unhidden Q117128 KB117128 January 19, 2007
• 927198 MS07-002: Vulnerabilities in Microsoft Excel could allow remote code execution Q927198 KB927198 January 18, 2007
• 277592 Delete Watch button is available even though no listed cells are selected in Excel Q277592 KB277592 January 18, 2007
• 110854 XL: How to Compute the Periodic Annual Interest Rate in Microsoft Excel Q110854 KB110854 January 18, 2007
• 105111 XL: Sorting Feature Ignores Hidden Rows Q105111 KB105111 January 18, 2007
• 100825 #VALUE error when you add text and values in Excel Q100825 KB100825 January 18, 2007
• 100782 XL: Method Used by Goal Seek to Find a Solution Q100782 KB100782 January 18, 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
• 306022 How to transfer data to an Excel workbook by using Visual Basic .NET Q306022 KB306022 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
• 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
• 283626 You can only find the cells that exactly match the formatting based on the existing cell in Excel Q283626 KB283626 January 12, 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
• 288614 Error message when you try to run a Microsoft Visual Basic for Applications macro: "Excel was previously unable to load your toolbar customizations" Q288614 KB288614 January 6, 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
• 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
• 230137 Some files do not print when you use Windows Explorer to print files from Excel 2007, Excel 2002, or Excel 2000 Q230137 KB230137 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