Excel 2002 (Excel XP) articles, fixes and updates - April 2018

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 April 2018. The list is daily updated.

• 273711 How to obtain the latest Excel Viewer Q273711 KB273711 April 30, 2018
• 867838 Office XP document in a SharePoint Team Services from Microsoft document library opens as read-only in Internet Explorer Q867838 KB867838 April 23, 2018
• 837827 You receive a "Setup cannot update the file" error message when you install Office XP SP3 Q837827 KB837827 April 23, 2018
• 329309 Office files that are saved to a network drive take an unexpectedly long time to save in Word, Excel, Powerpoint 2002 and 2003 Q329309 KB329309 April 23, 2018
• 835413 Missing clips appear with the title Dglxasset.aspx when you search for clips in Office Q835413 KB835413 April 22, 2018
• 318756 PRB: Excel and Word Content Do Not Stream as Expected from ASP .NET Q318756 KB318756 April 22, 2018
• 285888 How to use an Excel RTD server with DCOM Q285888 KB285888 April 22, 2018
• 239930 How to obtain built-in constant values for an Office application Q239930 KB239930 April 22, 2018
• 192348 How to automate Excel and then know the user closed it Q192348 KB192348 April 22, 2018
• 936695 Issues that are fixed in the update to the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats Q936695 KB936695 April 21, 2018
• 925082 The icon is blank when you insert an object or a file into a document, presentation, spreadsheet, or other Microsoft Office file Q925082 KB925082 April 21, 2018
• 823838 The result is "FALSE" when you use the ISBLANK() function in an Excel spreadsheet Q823838 KB823838 April 21, 2018
• 329820 How to use Office programs with the Norton AntiVirus Office plug-in Q329820 KB329820 April 21, 2018
• 315961 The VLOOKUP and HLOOKUP functions fail to find a number in a list in Excel Q315961 KB315961 April 21, 2018
• 291287 Links in shared workbook return #REF! error in Excel Q291287 KB291287 April 21, 2018
• 291204 You receive an error message when you save a file after the network connection is lost in Excel Q291204 KB291204 April 21, 2018
• 290347 Error message when you use Web query to a secure Web page (HTTPS://) in Excel: "Unable to open" Q290347 KB290347 April 21, 2018
• 277596 Error message when you update a data query on your Excel worksheet: "This Web query returned no data" Q277596 KB277596 April 21, 2018
• 214386 Maximum times in Microsoft Excel Q214386 KB214386 April 21, 2018
• 213581 VBA code "behind" a worksheet or a workbook may not work in Excel Q213581 KB213581 April 21, 2018
• 211767 Dates are made consecutive when you create charts in Microsoft Excel Q211767 KB211767 April 21, 2018
• 916004 An unexpected value is returned when you use the DAYS360 function in Microsoft Excel Q916004 KB916004 April 20, 2018
• 908475 You cannot embed an Adobe OpenType font in a document in an Office program Q908475 KB908475 April 20, 2018
• 905431 You receive an "Incorrect function" error message when you try to save a file from an Office program to a CD-RW or a DVD/CD-RW drive Q905431 KB905431 April 20, 2018
• 895089 Very few clip art items are available in the results box of the Clip Art task pane in Office XP, in Office 2003, and in the 2007 Office system Q895089 KB895089 April 20, 2018
• 833724 Date format is not correct when you convert a CSV text file in Excel by using a VBA macro Q833724 KB833724 April 20, 2018
• 832293 The .SpecialCells(xlCellTypeBlanks) VBA function does not work as expected in Excel Q832293 KB832293 April 20, 2018
• 826924 How to apply different passwords or permissions to separate ranges in workbooks in Excel Q826924 KB826924 April 20, 2018
• 820204 How to change from absolute to relative or mixed references in a formula in Excel Q820204 KB820204 April 20, 2018
• 815356 Excel may not automatically fit the worksheet to the page after you set the "Fit to" option Q815356 KB815356 April 20, 2018
• 555263 Macro in Excel Stops After A Workbook.Open Command Q555263 KB555263 April 20, 2018
• 555127 Method to Delete Corrupt Defined Names in Excel Q555127 KB555127 April 20, 2018
• 325091 How to minimize the size of an XML Spreadsheet file in Excel Q325091 KB325091 April 20, 2018
• 316475 PRB: "Operation Must Use an Updateable Query" Error Message When You Access Excel Through ODBC Q316475 KB316475 April 20, 2018
• 308983 How to specify trusted sources for Digital Certificates in Excel, in PowerPoint, in and Word Q308983 KB308983 April 20, 2018
• 291309 Using a worksheet function in a Visual Basic macro in Excel Q291309 KB291309 April 20, 2018
• 290537 EXD files are created when you insert controls Q290537 KB290537 April 20, 2018
• 289840 Registry keys that control the File Repair feature in Excel Q289840 KB289840 April 20, 2018
• 289508 How to view error signatures if an Office program experiences a serious error and quits Q289508 KB289508 April 20, 2018
• 289262 How to use the AutoRepublish feature in Excel Q289262 KB289262 April 20, 2018
• 282852 An overview of data tables in Excel 2003 and in Excel 2007 Q282852 KB282852 April 20, 2018
• 282085 Description of task panes in Office programs Q282085 KB282085 April 20, 2018
• 280094 Sample user-defined function to hide formula errors in Excel Q280094 KB280094 April 20, 2018
• 249885 Formatted text (.prn) is limited to 240 characters per line in Excel Q249885 KB249885 April 20, 2018
• 221048 Custom function may not calculate expected value in Excel Q221048 KB221048 April 20, 2018
• 214105 Description of the algorithm used by the XIRR() function in Excel Q214105 KB214105 April 20, 2018
• 213634 XL: Using Saved Property to Determine If Workbook Has Changed Q213634 KB213634 April 20, 2018
• 213616 How to use a macro to apply cell shading format to every other row in a selected range in Excel Q213616 KB213616 April 20, 2018
• 213460 How to programmatically print all embedded charts on a worksheet Q213460 KB213460 April 20, 2018
• 213445 How to use the OnEntry macro to create a running total in a cell comment in Excel Q213445 KB213445 April 20, 2018
• 211652 AutoComplete may not work Q211652 KB211652 April 20, 2018
• 199505 Macro performance slow when page breaks are visible in Excel Q199505 KB199505 April 20, 2018
• 168563 Unexpected behavior when you use different print quality for sheets in Excel Q168563 KB168563 April 20, 2018
• 840817 How to extract information from Office files by using Office file formats and schemas Q840817 KB840817 April 19, 2018
• 820764 You cannot specify some color values by using the Pantone system in Office programs Q820764 KB820764 April 19, 2018
• 321147 Error message: "The password you supplied is not correct" Q321147 KB321147 April 19, 2018
• 292582 You receive an invalid character error message when you install Office XP and Office 2003 Q292582 KB292582 April 19, 2018
• 284876 Excel fails when Automation add-In loads Q284876 KB284876 April 19, 2018
• 828958 Resources to help you activate a license in Microsoft Office programs Q828958 KB828958 April 18, 2018
• 826214 How to customize the My Places bar in both the Open and the Save As dialog boxes in Office Q826214 KB826214 April 18, 2018
• 325671 Description of Office XP Service Pack 2 (SP2) Q325671 KB325671 April 18, 2018
• 317719 How To Export Data in a DataGrid on an ASP . NET WebForm to Microsoft Excel Q317719 KB317719 April 18, 2018
• 316126 How to use Visual C# to automate a running instance of an Office program Q316126 KB316126 April 18, 2018
• 315731 How to retrieve the names of macros from an Excel workbook by using Visual Basic 6.0 Q315731 KB315731 April 18, 2018
• 315041 Cannot access the Internet with ZoneAlarm or ZoneAlarm Pro installed after you upgrade to a later version of Office Q315041 KB315041 April 18, 2018
• 311546 How to embed and automate an Excel worksheet by using MFC and Visual C++ 2005 or Visual C++ .NET Q311546 KB311546 April 18, 2018
• 308407 How to automate Excel from MFC and Visual C++ 2005 or Visual C++ .NET to fill or obtain data in a range using arrays Q308407 KB308407 April 18, 2018
• 307029 How to transfer XML data to Microsoft Excel 2002 or Microsoft Excel 2003 by using Visual C# Q307029 KB307029 April 18, 2018
• 302901 How to build an Office COM add-in by using Visual C# .NET Q302901 KB302901 April 18, 2018
• 302596 Error message when you have the Adobe PDFMaker add-in installed Q302596 KB302596 April 18, 2018
• 296717 PRB: Internet Explorer Prompts User to Open/Save Office File Streamed from ASP Q296717 KB296717 April 18, 2018
• 292491 Office automation when multiple versions of Office are installed Q292491 KB292491 April 18, 2018
• 288130 How to use ASP to build spreadsheet XML for client-side display Q288130 KB288130 April 18, 2018
• 288118 Add-ins that are not included with Excel Q288118 KB288118 April 18, 2018
• 286259 Security settings and Excel RealTimeData servers Q286259 KB286259 April 18, 2018
• 285891 How to use Visual Basic or ASP to create an XML spreadsheet for Excel 2002 and Excel 2003 Q285891 KB285891 April 18, 2018
• 270844 How to create an Excel histogram by using Automation and Analysis ToolPak Q270844 KB270844 April 18, 2018
• 266088 BUG: Excel Does Not Shut Down After Calling the Quit Method When Automating from JScript Q266088 KB266088 April 18, 2018
• 258511 How to obtain the window handle for an Office Automation server Q258511 KB258511 April 18, 2018
• 242243 How To embed and automate Office documents with Visual Basic Q242243 KB242243 April 18, 2018
• 238972 Using Visual C++ to automate Office Q238972 KB238972 April 18, 2018
• 213810 How to determine how many pages will be printed in Excel Q213810 KB213810 April 18, 2018
• 213489 Add-ins do not load when using the CreateObject command in Excel Q213489 KB213489 April 18, 2018
• 199691 How to automate using Visual C++ to save Excel worksheet as HTML file Q199691 KB199691 April 18, 2018
• 190985 How to get IDispatch of an Excel or Word document from an OCX Q190985 KB190985 April 18, 2018
• 184663 How to embed and automate a Microsoft Excel worksheet with MFC Q184663 KB184663 April 18, 2018
• 906311 You cannot share an Excel workbook that contains an array formula that is linked to another workbook Q906311 KB906311 April 17, 2018
• 903771 Information about the ability to uninstall Office updates Q903771 KB903771 April 17, 2018
• 895456 How to change the product key for Office XP, for Office 2003, and for the 2007 Office system Q895456 KB895456 April 17, 2018
• 886549 You receive an "Error 1606" error message when you try to install or remove a Microsoft program Q886549 KB886549 April 17, 2018
• 884202 You must accept the Office End User License Agreement every time that you start an Office program Q884202 KB884202 April 17, 2018
• 830287 How to create a dynamic defined range in an Excel worksheet Q830287 KB830287 April 17, 2018
• 827371 Description of the NORMDIST function in Excel Q827371 KB827371 April 17, 2018
• 826921 How to control the startup message about updating linked workbooks in Excel Q826921 KB826921 April 17, 2018
• 825012 How formula calculations are performed in Excel Q825012 KB825012 April 17, 2018
• 822924 Description of Office features that are intended to enable collaboration and that are not intended to increase security Q822924 KB822924 April 17, 2018
• 819964 How to convert a single column of addresses to a CSV text file in Excel Q819964 KB819964 April 17, 2018
• 816644 How to send a range of cells in an e-mail message by using Visual Basic for Applications in Excel Q816644 KB816644 April 17, 2018
• 814068 Description of the way that Excel saves files Q814068 KB814068 April 17, 2018
• 812386 How to sort worksheets alphanumerically in a workbook in Excel Q812386 KB812386 April 17, 2018
• 327006 External links may be calculated when you open a workbook that was last saved in an earlier version of Excel Q327006 KB327006 April 17, 2018
• 320473 Excel data does not retain its formatting in mail merge operations in Word Q320473 KB320473 April 17, 2018
• 320369 BUG: "Old format or invalid type library" error when automating Excel Q320369 KB320369 April 17, 2018
• 318118 How to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet Q318118 KB318118 April 17, 2018
• 313937 Microsoft Office stops responding when you try to open or save a file Q313937 KB313937 April 17, 2018
• 313275 "Not enough memory" error messages when you copy formulas over large area in Excel Q313275 KB313275 April 17, 2018
• 312589 The Menu bar or the Minimize, Restore, and Close buttons are missing in Excel and in Word Q312589 KB312589 April 17, 2018
• 306023 How to transfer data to an Excel workbook by using Visual C# 2005 or Visual C# .NET Q306023 KB306023 April 17, 2018
• 304662 How to use the WebBrowser control to open Office documents in Visual C# 2005 or in Visual C# .NET Q304662 KB304662 April 17, 2018
• 299036 How to loop through a list of data on a worksheet by using macros in Excel Q299036 KB299036 April 17, 2018
• 292478 Inserted symbol is changed to a text character in Excel Q292478 KB292478 April 17, 2018
• 292468 You are unable to select unprotected cells in Excel Q292468 KB292468 April 17, 2018
• 291392 Excel COM add-ins and Automation add-ins Q291392 KB291392 April 17, 2018
• 291363 How to use the "Insert Options" button in Excel Q291363 KB291363 April 17, 2018
• 291323 Sample macro code to change the case of text in Excel Q291323 KB291323 April 17, 2018
• 291321 How to programmatically reset a workbook to default styles Q291321 KB291321 April 17, 2018
• 291288 Description of the startup switches for Excel Q291288 KB291288 April 17, 2018
• 291073 How to use the forms controls on a worksheet in Excel Q291073 KB291073 April 17, 2018
• 290228 "Cannot connect to the FTP server" error message when you access an FTP site in Office Q290228 KB290228 April 17, 2018
• 290142 How to open documents from FTP site and save documents to FTP site with Office programs. Q290142 KB290142 April 17, 2018
• 289577 How to make Paste Options button disappear after you paste in Excel Q289577 KB289577 April 17, 2018
• 288966 An image in a header or a footer may overlap into the data area of a worksheet in Excel Q288966 KB288966 April 17, 2018
• 288902 GetObject and CreateObject behavior of Office automation servers Q288902 KB288902 April 17, 2018
• 287392 How to programmatically turn off the Clipboard warning message Q287392 KB287392 April 17, 2018
• 285339 How to create a RealTimeData server for Excel Q285339 KB285339 April 17, 2018
• 284868 Error message in Excel when you try to import data from a Web source: "Invalid XML declaration" Q284868 KB284868 April 17, 2018
• 283806 Visual Basic for Applications (VBA) functions break in a database with missing references Q283806 KB283806 April 17, 2018
• 282847 Some Excel features are unavailable if you disable Visual Basic for Applications and run Excel Q282847 KB282847 April 17, 2018
• 282141 You cannot convert text to number when the cell contains a number Q282141 KB282141 April 17, 2018
• 277601 Blank pages are unexpectedly printed in Excel Q277601 KB277601 April 17, 2018
• 277600 The password you use to connect to the server is not saved when you import data from a server by using ODBC Connection in Excel Q277600 KB277600 April 17, 2018
• 275166 Using SUM(IF()) as an array function instead of COUNTIF() with AND or OR criteria in Excel Q275166 KB275166 April 17, 2018
• 274537 When to use SUM(IF()) instead of COUNTBLANK() in Excel Q274537 KB274537 April 17, 2018
• 269370 Last digits are changed to zeroes when you type long numbers in cells of Excel Q269370 KB269370 April 17, 2018
• 267982 How to use a logical AND or OR in a SUM+IF statement in Excel Q267982 KB267982 April 17, 2018
• 266691 How to sum and format a range of hours, minutes, or seconds in Excel Q266691 KB266691 April 17, 2018
• 247412 Methods for transferring data to Excel from Visual Basic Q247412 KB247412 April 17, 2018
• 246335 How to transfer data from an ADO Recordset to Excel with automation Q246335 KB246335 April 17, 2018
• 234774 How to automate Excel from an HTML Web page by using JScript Q234774 KB234774 April 17, 2018
• 224351 The Dsofile.dll files lets you edit Office document properties when you do not have Office installed Q224351 KB224351 April 17, 2018
• 214691 You are not able to drag page breaks in Page Break Preview in Excel Q214691 KB214691 April 17, 2018
• 214395 How Excel determines the current mode of calculation Q214395 KB214395 April 17, 2018
• 214394 The column width is not the same when printed in Excel Q214394 KB214394 April 17, 2018
• 214330 Differences between the 1900 and the 1904 date system in Excel Q214330 KB214330 April 17, 2018
• 214245 You receive the "Disk is Full" error message when you save a workbook in Excel Q214245 KB214245 April 17, 2018
• 214230 Incorrect output is returned when you use the Linear Regression (LINEST) function in Excel Q214230 KB214230 April 17, 2018
• 214073 You receive an error message when you try to save a file in Excel Q214073 KB214073 April 17, 2018
• 214024 How to convert multiple rows and columns to columns and rows in Excel Q214024 KB214024 April 17, 2018
• 213977 You cannot print a background graphic for a Excel worksheet Q213977 KB213977 April 17, 2018
• 213933 How to use the INDIRECT function to create references in Excel Q213933 KB213933 April 17, 2018
• 213907 How to calculate compound interest for an intra-year period in Excel Q213907 KB213907 April 17, 2018
• 213750 How to use a macro to add labels to data points in an xy scatter chart or in a bubble chart in Excel Q213750 KB213750 April 17, 2018
• 213630 How to use the IF THEN ELSE statement and the SELECT CASE statement in examples written in Visual Basic for Excel Q213630 KB213630 April 17, 2018
• 213610 How to delete every other row on an Excel worksheet Q213610 KB213610 April 17, 2018
• 213513 You are not prompted to save the changes when you change and close a workbook in Excel Q213513 KB213513 April 17, 2018
• 213477 VBA macro to concatenate columns of data in Excel Q213477 KB213477 April 17, 2018
• 213367 How to compare data in two columns to find duplicates in Excel Q213367 KB213367 April 17, 2018
• 212010 You cannot use the AutoFit feature for rows or columns that contain merged cells in Excel Q212010 KB212010 April 17, 2018
• 211967 Chart trendline formula is inaccurate in Excel Q211967 KB211967 April 17, 2018
• 211769 Error message when you try to insert or hide rows or columns in Excel: "Cannot shift objects off sheet" Q211769 KB211769 April 17, 2018
• 210684 Copying worksheet programmatically causes run-time error 1004 in Excel Q210684 KB210684 April 17, 2018
• 183446 How to use defined names to automatically update a chart range in Excel Q183446 KB183446 April 17, 2018
• 178510 Excel automation fails second time code runs Q178510 KB178510 April 17, 2018
• 141695 XL: How to Calculate Compound Interest Q141695 KB141695 April 17, 2018
• 135506 Cell linked to text-formatted cell shows formula not value Q135506 KB135506 April 17, 2018
• 78113 Floating-point arithmetic may give inaccurate results in Excel Q78113 KB78113 April 17, 2018
• 906309 You cannot scroll to view the other areas of an Excel worksheet Q906309 KB906309 April 16, 2018
• 895562 The conditional formatting may be set incorrectly when you use VBA in Excel Q895562 KB895562 April 16, 2018
• 834579 Some category labels are missing or are too small to read on Excel charts Q834579 KB834579 April 16, 2018
• 832286 How to save the addresses from a Word mail-merge label document to Excel Q832286 KB832286 April 16, 2018
• 832166 You receive a "Run-time Error 1004" error message when you make changes to legend entries in an chart in Excel Q832166 KB832166 April 16, 2018
• 826208 How to edit the Windows registry to clear the list of most recently used files in Office Q826208 KB826208 April 16, 2018
• 813974 You may receive an error message when you sort a range that contains merged cells in Excel Q813974 KB813974 April 16, 2018
• 326039 Error message when you open a Office file that has a long folder name Q326039 KB326039 April 16, 2018
• 300643 Macro to extract data from a chart in Excel Q300643 KB300643 April 16, 2018
• 300169 Keyboard shortcuts for applying borders to cells Q300169 KB300169 April 16, 2018
• 291305 Sample macro to insert/delete rows or columns on multiple sheets in Excel Q291305 KB291305 April 16, 2018
• 291300 How to delete cells by using a "For Each...Next" loop Q291300 KB291300 April 16, 2018
• 291296 Procedure to export a text file with both comma and quote delimiters in Excel Q291296 KB291296 April 16, 2018
• 291295 Macro code to check whether a file is already open Q291295 KB291295 April 16, 2018
• 291050 How to use the IF worksheet function to suppress the #DIV/0! error value in Excel Q291050 KB291050 April 16, 2018
• 289270 How to apply different passwords or permissions to separate ranges in worksheets in Excel Q289270 KB289270 April 16, 2018
• 289150 How to set up and use the RTD function in Excel Q289150 KB289150 April 16, 2018
• 289148 Description of the smart tag functionality in Excel Q289148 KB289148 April 16, 2018
• 289146 How to turn off Function Argument ToolTips in Excel Q289146 KB289146 April 16, 2018
• 288958 How to remove smart tags from a workbook in Excel Q288958 KB288958 April 16, 2018
• 288858 The worksheet may be printed at a different size than you expect when you print a worksheet in Excel Q288858 KB288858 April 16, 2018
• 288852 How to use Draw Border tools and Draw Border Grid tools to apply and remove cell borders in Excel Q288852 KB288852 April 16, 2018
• 287736 GETPIVOTDATA formula is automatically created when you try to create simple link in Excel Q287736 KB287736 April 16, 2018
• 282856 How to create and use two-input data tables in Microsoft Excel Q282856 KB282856 April 16, 2018
• 282140 You cannot remove error tracing arrow in Excel Q282140 KB282140 April 16, 2018
• 282135 How to display more digits in trendline equation coefficients in Excel Q282135 KB282135 April 16, 2018
• 269866 Columns and rows are labeled numerically in Excel Q269866 KB269866 April 16, 2018
• 269860 How to use shared workbooks with different versions of Excel Q269860 KB269860 April 16, 2018
• 254791 How to manage multiple windows in Excel Q254791 KB254791 April 16, 2018
• 245104 How to calculate ages before 1/1/1900 in Excel Q245104 KB245104 April 16, 2018
• 214391 How Excel works with two-digit year numbers Q214391 KB214391 April 16, 2018
• 214123 Description of how column widths are determined in Excel Q214123 KB214123 April 16, 2018
• 214080 XL2000: Error Message: That Command Cannot Be Used on Multiple Selections Q214080 KB214080 April 16, 2018
• 214029 The selected Data Analysis tool uses only data from the active sheet if sheets of a workbook are grouped in Excel Q214029 KB214029 April 16, 2018
• 213742 Macro to change the date/time format in a header or footer Q213742 KB213742 April 16, 2018
• 213646 How to use the left, right, mid, and len functions in Visual Basic for Applications in Excel Q213646 KB213646 April 16, 2018
• 213641 How to programmatically save a file to a network drive in Excel Q213641 KB213641 April 16, 2018
• 213609 How to hide sheets and use xlVeryHidden constant in a macro Q213609 KB213609 April 16, 2018
• 213566 How to create application-level event handlers in Excel Q213566 KB213566 April 16, 2018
• 213389 How to programmatically copy all range names in Excel Q213389 KB213389 April 16, 2018
• 213257 How to set page setup attributes for more than one sheet Q213257 KB213257 April 16, 2018
• 212022 The "Center Across Columns" button does not appear on the toolbar or on the Ribbon in Excel Q212022 KB212022 April 16, 2018
• 211548 You cannot use external references with data validation in Excel Q211548 KB211548 April 16, 2018
• 182189 How to create a conditional format to hide errors in Excel Q182189 KB182189 April 16, 2018
• 166342 Description of the limitations for working with arrays in Excel Q166342 KB166342 April 16, 2018
• 827710 How to control the size of a UserForm in Excel Q827710 KB827710 April 12, 2018