kbupdate.info ›
Daily Updated!
Excel 2000 articles, fixes and updates - April 2018
Daily Updated!
chronological list: 2021 | 2020 | 2019 | 2018/12 9 5 4 | 2017 | 2016 | 2015 | 2014 | 2013/11 10 9 ... 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 April 2018. The list is daily updated.
- 273711 How to obtain the latest Excel Viewer Q273711 KB273711 April 30, 2018
- 821430 The Solver add-in may not work when you start Solver by using a macro in Excel 2000 Q821430 KB821430 April 22, 2018
- 318756 PRB: Excel and Word Content Do Not Stream as Expected from ASP .NET Q318756 KB318756 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
- 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
- 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
- 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
- 832293 The .SpecialCells(xlCellTypeBlanks) VBA function does not work as expected in Excel Q832293 KB832293 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
- 290537 EXD files are created when you insert controls Q290537 KB290537 April 20, 2018
- 282852 An overview of data tables in Excel 2003 and in Excel 2007 Q282852 KB282852 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
- 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
- 315731 How to retrieve the names of macros from an Excel workbook by using Visual Basic 6.0 Q315731 KB315731 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
- 307033 How To Use an XML Web Service by Using ASP.NET from an Office VBA Macro in Word or Excel Q307033 KB307033 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
- 271572 How to format an Excel workbook while streaming MIME content Q271572 KB271572 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
- 212536 How to run sample code from Knowledge Base articles in Office 2000 Q212536 KB212536 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
- 891636 You receive an "Access denied" error message, and the program unexpectedly quits when you try to open or save a file in an Office program Q891636 KB891636 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
- 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
- 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
- 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
- 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
- 291323 Sample macro code to change the case of text in Excel Q291323 KB291323 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
- 288902 GetObject and CreateObject behavior of Office automation servers Q288902 KB288902 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
- 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
- 213930 XL: How to Create a Bell Curve Chart Q213930 KB213930 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
- 208218 ACC2000: VBA Functions Break in Database with Missing References Q208218 KB208218 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
- 813974 You may receive an error message when you sort a range that contains merged cells in Excel Q813974 KB813974 April 16, 2018
- 282856 How to create and use two-input data tables in Microsoft Excel Q282856 KB282856 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
- 214244 XL: How to Create a Formula to Correctly Evaluate Blank Cells Q214244 KB214244 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