Excel 2000 articles, fixes and updates - letter H

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Excel 2000 starts with letter H that have been released. The list is daily updated.

• 219905 How to dynamically add and run a VBA macro from Visual Basic Q219905 KB219905 January 25, 2021
• 211922 How to modify the number of undo levels in Excel Q211922 KB211922 November 20, 2020
• 830258 How to create a "Masked Password" dialog box in Office programs by using Visual Basic for Applications Q830258 KB830258 September 29, 2020
• 214328 Hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel Q214328 KB214328 August 20, 2020
• 306572 How to query and display excel data by using ASP.NET, ADO.NET, and Visual C# .NET Q306572 KB306572 June 10, 2019
• 291304 How to select ranges using Visual Basic for Applications (novice examples) Q291304 KB291304 June 10, 2019
• 291308 How to select cells/ranges by using Visual Basic procedures in Excel Q291308 KB291308 May 28, 2019
• 243058 How to use the WebBrowser control to open an Office document Q243058 KB243058 May 28, 2019
• 833402 How to convert Excel column numbers into alphabetical characters Q833402 KB833402 May 27, 2019
• 304643 How to use the WebBrowser control in Visual Basic to open an Office document Q304643 KB304643 May 27, 2019
• 271513 How to troubleshoot errors when you save Excel workbooks Q271513 KB271513 May 27, 2019
• 234788 How to find the installation path of an Office application Q234788 KB234788 May 27, 2019
• 219151 How to automate Microsoft Excel from Visual Basic Q219151 KB219151 May 27, 2019
• 216686 How to automate Excel from C++ without using MFC or #import Q216686 KB216686 May 27, 2019
• 211736 How to display a progress bar with a user form in Excel Q211736 KB211736 May 27, 2019
• 89794 How to use Visual Basic for Applications to count the occurrences of a character in a selection in Excel Q89794 KB89794 May 27, 2019
• 213612 How to run a macro when certain cells change in Excel Q213612 KB213612 January 8, 2019
• 213428 How to suppress "Save Changes" prompt when you close a workbook in Excel Q213428 KB213428 December 7, 2018
• 150774 How to create a monthly calendar in Excel Q150774 KB150774 September 18, 2018
• 324861 How to find data in an Excel table Q324861 KB324861 May 14, 2018
• 273711 How to obtain the latest Excel Viewer Q273711 KB273711 April 30, 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
• 329820 How to use Office programs with the Norton AntiVirus Office plug-in Q329820 KB329820 April 21, 2018
• 820204 How to change from absolute to relative or mixed references in a formula in Excel Q820204 KB820204 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
• 840817 How to extract information from Office files by using Office file formats and schemas Q840817 KB840817 April 19, 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
• 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
• 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
• 213810 How to determine how many pages will be printed in Excel Q213810 KB213810 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
• 830287 How to create a dynamic defined range in an Excel worksheet Q830287 KB830287 April 17, 2018
• 819964 How to convert a single column of addresses to a CSV text file in Excel Q819964 KB819964 April 17, 2018
• 812386 How to sort worksheets alphanumerically in a workbook in Excel Q812386 KB812386 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
• 291073 How to use the forms controls on a worksheet in Excel Q291073 KB291073 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
• 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
• 214395 How Excel determines the current mode of calculation Q214395 KB214395 April 17, 2018
• 214024 How to convert multiple rows and columns to columns and rows in Excel Q214024 KB214024 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
• 213367 How to compare data in two columns to find duplicates in Excel Q213367 KB213367 April 17, 2018
• 183446 How to use defined names to automatically update a chart range in Excel Q183446 KB183446 April 17, 2018
• 832286 How to save the addresses from a Word mail-merge label document to Excel Q832286 KB832286 April 16, 2018
• 282856 How to create and use two-input data tables in Microsoft Excel Q282856 KB282856 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
• 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
• 182189 How to create a conditional format to hide errors in Excel Q182189 KB182189 April 16, 2018
• 827710 How to control the size of a UserForm in Excel Q827710 KB827710 April 12, 2018
• 843144 How to use variables in Excel sub-procedures in Visual Basic for Applications Q843144 KB843144 July 11, 2017
• 264372 How to control and understand settings in the Format Cells dialog box in Excel Q264372 KB264372 June 14, 2017
• 271143 HOW TO: Calculate the nth Root of a Number in Excel 2000 Q271143 KB271143 June 13, 2017
• 213449 How to convert degrees/minutes/seconds angles to or from decimal angles in Excel Q213449 KB213449 May 17, 2017
• 321686 How to import data from Excel to SQL Server Q321686 KB321686 April 26, 2017
• 914200 How to convert European currencies programmatically by using the Excel MSoEuro component and how to use the Euro Currency Tools add-in Q914200 KB914200 March 29, 2017
• 162059 How to configure Internet Explorer to open Office documents in the appropriate Office program instead of in Internet Explorer Q162059 KB162059 August 15, 2016
• 924074 How to open new file formats in earlier versions of Microsoft Office Q924074 KB924074 September 23, 2015
• 205041 How to customize the Places Bar in Office 2000 Q205041 KB205041 January 14, 2015
• 243394 HOWTO: Use MFC to Copy a DAO Recordset to Excel with Automation Q243394 KB243394 January 11, 2015
• 835229 How to remove "Add/Modify FTP Locations" from the list of locations when you open or save a file in Office 2000 programs Q835229 KB835229 January 10, 2015
• 295681 HOW TO: Obtain and Install the Excel 2000 SR-1 Eurotool Add-In Update Q295681 KB295681 December 24, 2014
• 284273 How to deploy Office 2000 over a network Q284273 KB284273 December 23, 2014
• 274680 How to use MFC to retrieve a list of macro names in an Office document Q274680 KB274680 December 23, 2014
• 252613 How to remove all components of Office 2000 CD2 in Windows 2000 Q252613 KB252613 December 23, 2014
• 243788 How to install Office 2000 CD2 on Windows Terminal Server Q243788 KB243788 December 23, 2014
• 214090 HOW TO: Use RAND() to Generate Randomly Distributed Integers in Excel 2000 Q214090 KB214090 June 22, 2014
• 213914 HOW TO: Use STDEV or STDEVP with a PivotTable in Excel 2000 Q213914 KB213914 June 22, 2014
• 213880 HOW TO: Use Microsoft Map to Display Specific States and Nations in Excel 2000 Q213880 KB213880 June 22, 2014
• 262584 How to install Office 2000 to Windows NT 4.0 Terminal Server Q262584 KB262584 November 2, 2013
• 245226 How to troubleshoot the issues with Office 2000 installation from a CD Q245226 KB245226 October 26, 2013
• 214040 HOW TO: Use Lotus 1-2-3 Commands to Attach Text Data Labels to a Chart in Excel 2000 Q214040 KB214040 October 26, 2013
• 213881 HOW TO: Change the Chart Type of a Series in a Combination Chart in Excel 2000 Q213881 KB213881 October 26, 2013
• 213648 HOW TO: Set a Print Area by Using a Defined Name in Excel 2000 Q213648 KB213648 October 26, 2013
• 213512 HOW TO: Identify and Remove PLDT, CAR, and SGV Macro Viruses in Excel 2000 Q213512 KB213512 October 26, 2013
• 211938 HOW TO: Plot Values Against a Recommended Range in Excel 2000 Q211938 KB211938 October 26, 2013
• 211883 HOW TO: Change the Font in a Comment in Excel 2000 Q211883 KB211883 October 26, 2013
• 214260 HOW TO: Create Functions to Calculate Light Years in Excel 2000 Q214260 KB214260 October 25, 2013
• 214009 HOW TO: Export Lotus 1-2-3 Linked Files to Excel 2000 Q214009 KB214009 October 25, 2013
• 213799 HOW TO: Simulate a PivotTable with No Summarization in Excel 2000 Q213799 KB213799 October 25, 2013
• 139402 How to Use DAO to Create a New Microsoft Excel Workbook Q139402 KB139402 October 25, 2013
• 214314 HOW TO: Open a Document Linked to Password-Protected Sheet in Excel 2000 Q214314 KB214314 October 24, 2013
• 211908 HOW TO: Use a Web Data Source for a PivotTable in Excel 2000 Q211908 KB211908 October 24, 2013
• 242144 HOW TO: Obtain and Install the Excel 2000 SYLK File Security Update in Excel 2000 Q242144 KB242144 October 22, 2013
• 263557 HOW TO: Use Only Selected Parts of AutoFormat in Excel 2000 Q263557 KB263557 October 20, 2013
• 214300 HOW TO: Use the "Most Recently Used" Category in the Function Wizard in Excel 2000 Q214300 KB214300 October 14, 2013
• 214298 HOW TO: Create an Add-in Application Name and Description in Excel 2000 Q214298 KB214298 October 14, 2013
• 214095 HOW TO: Modify a Particular Time with the TIME and MOD Functions in Excel 2000 Q214095 KB214095 October 14, 2013
• 213913 HOW TO: Preserve Formulas If You Save a Document As a Text File in Excel 2000 Q213913 KB213913 October 14, 2013
• 193006 How to reset personal menus in Office XP and Office 2000 programs Q193006 KB193006 September 3, 2013
• 302751 How to remove the Office 2000 Service Release SR-1/SR-1a update Q302751 KB302751 October 24, 2012
• 871146 How to troubleshoot general printing problems in Windows 2000 when you are using Office products Q871146 KB871146 October 12, 2012
• 923505 How to install the Microsoft Office Compatibility Pack so that you can open and save Office Open XML formats in earlier versions of Microsoft Office Q923505 KB923505 August 13, 2012
• 221190 How to use the Office 2000 Clipboard Q221190 KB221190 February 17, 2012
• 316934 How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET Q316934 KB316934 September 23, 2011
• 66033 Hexadecimal Values Changed When Imported from .CSV File Q66033 KB66033 September 19, 2011
• 870622 How to troubleshoot problems that you may experience when you try to print to a local printer by using Office programs in Windows XP Q870622 KB870622 September 18, 2011
• 247311 How to use macros to sort data in multiple columns as one column in Excel Q247311 KB247311 September 18, 2011
• 2519419 How to obtain a new product key for a Microsoft Office suite Q2519419 KB2519419 April 7, 2011
• 304165 How to download and install an update to an administrative installation of Office 2000 Q304165 KB304165 February 9, 2011
• 214295 How to bypass the Text Import Wizard when you import files in Excel Q214295 KB214295 September 25, 2009
• 316587 How to automate embedded Office ActiveX documents with C++ Q316587 KB316587 March 23, 2009
• 198703 How to automate Excel from a client-side VBScript Q198703 KB198703 March 23, 2009
• 153307 How to call Microsoft Excel macros that take parameters Q153307 KB153307 March 23, 2009
• 870968 How to troubleshoot general printing problems in Windows Server 2003 when you use Office products Q870968 KB870968 October 29, 2008
• 823002 How to write context numbers in excel Q823002 KB823002 August 25, 2008
• 821091 HowTo: Formula to Find Number of Weekdays Between Dates Q821091 KB821091 August 25, 2008
• 198687 How to install real mode CD-ROM drive drivers in Windows 98 Q198687 KB198687 May 29, 2008
• 816562 How to change connection information for a query in Excel Q816562 KB816562 May 13, 2008
• 177512 How to select a compatible printer driver for your printer How to select a compatible printer driver for your printer when you use Office 97, Office 2000, or Office XP Q177512 KB177512 April 29, 2008
• 266134 How to find Office 2000 updates Q266134 KB266134 October 3, 2007
• 288367 How to configure Office applications to run under a specific user account Q288367 KB288367 August 23, 2007
• 235537 HOW TO: Custom Sort or Prevent Auto Sort in PivotTable in Excel 2000 Q235537 KB235537 August 23, 2007
• 214031 HOW TO: Convert Dates in Imported Files from yy/mm/dd to mm/dd/yy Format in Excel 2000 Q214031 KB214031 August 22, 2007
• 213267 HOW TO: Get Windows Status Information from Windows API in Excel 2000 Q213267 KB213267 August 22, 2007
• 274504 HOW TO: Use Global and Local References in Formulas in Excel 2000 Q274504 KB274504 August 21, 2007
• 237957 How to use an Office 2000 Setup log file to troubleshoot Office Setup problems Q237957 KB237957 July 19, 2007
• 288368 How to configure Office applications for automation from a COM+/MTS package Q288368 KB288368 July 2, 2007
• 309301 HOW TO: Handle Events for Excel by Using Visual C++ .NET Q309301 KB309301 June 29, 2007
• 110006 How to reset the Update Remote References option in Excel Q110006 KB110006 June 4, 2007
• 271736 How to add Excel LinkedCell support to your ATL ActiveX control Q271736 KB271736 May 31, 2007
• 248822 How to use custom functions with the Spreadsheet component Q248822 KB248822 May 31, 2007
• 253501 How to pass a COleDispatchDriver as an argument for a method expecting a VARIANT Q253501 KB253501 May 14, 2007
• 238983 How to trap events exposed by Office applications Q238983 KB238983 May 11, 2007
• 233499 How to change the company name and user name in the About <program name> window after you install Office 2000 Q233499 KB233499 May 7, 2007
• 308408 How To Use Automation to Get and Set Office Document Properties from a Managed C++ Client Q308408 KB308408 March 29, 2007
• 288366 How to configure Office applications to run under the interactive user account Q288366 KB288366 March 28, 2007
• 267362 How to change the server location for Office source files Q267362 KB267362 March 22, 2007
• 245025 How to obtain and install the Office 2000 SR-1&#47;SR-1a Update Q245025 KB245025 March 22, 2007
• 240216 How Office 2000 manages templates Q240216 KB240216 March 22, 2007
• 113899 How To Convert a Database Table into an Excel Spreadsheet Q113899 KB113899 February 23, 2007
• 260239 How To Format Cell Data When You Are Creating an Excel File With an Active Server Pages Page Q260239 KB260239 February 12, 2007
• 186898 How To Read Compound Document Properties Directly with VC++ Q186898 KB186898 February 12, 2007
• 181473 HOWTO: Use OLE Automation from a C Application Rather Than C++ Q181473 KB181473 February 12, 2007
• 178474 How To Build an Add-in (XLL) for Excel Using Visual C++ Q178474 KB178474 February 12, 2007
• 114348 How To Print Two Excel Charts on Single Page w/OLE Automation Q114348 KB114348 February 12, 2007
• 214011 How to create a column chart with two Y-axes in Excel Q214011 KB214011 February 8, 2007
• 843621 How to format Sub procedures in Visual Basic for Applications Q843621 KB843621 February 6, 2007
• 812072 How to copy an Office file to a disk Q812072 KB812072 February 1, 2007
• 313454 How to clear the Most Recently Used list (MRU) list in Office programs Q313454 KB313454 January 31, 2007
• 304494 How to use Visual Basic for Applications in Excel Q304494 KB304494 January 31, 2007
• 296067 How to use msiexec.exe and the globally unique identifier (GUID) of the product to remove suite or stand-alone Office 2000 programs Q296067 KB296067 January 31, 2007
• 290359 How to remove leading space for values converted to strings Q290359 KB290359 January 31, 2007
• 287484 How to download and install an administrative update available for the Access 2000 and SQL Server 2000 Readiness Update Q287484 KB287484 January 31, 2007
• 282855 How to create and use one-input data tables in Microsoft Excel Q282855 KB282855 January 29, 2007
• 279721 How to use Dynamic Data Exchange (DDE) with Word and Excel from Visual C++ Q279721 KB279721 January 29, 2007
• 279299 How to troubleshoot the installation of Office 2000 SP2 by using the log file Q279299 KB279299 January 29, 2007
• 272729 How to import data with more than 256 fields or columns into Excel Q272729 KB272729 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
• 264625 How to install or repair individual features of Office 2000 Q264625 KB264625 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
• 257464 Hyperlinks in an e-mail message do not work in Office 2000 or in Office 2002 programs Q257464 KB257464 January 27, 2007
• 247684 How to remove Office 2000 CD2 Q247684 KB247684 January 25, 2007
• 238251 How to Install Windows Messaging After You Remove Outlook 2000 or Office 2000 from Windows 95 Q238251 KB238251 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
• 238122 How to install Office 2000 or Office XP on a computer that is running Windows Millennium Edition, Windows 95, or Windows 98 with User Profiles and without User Profiles Q238122 KB238122 January 24, 2007
• 231614 How To Automate Excel to Create a New Workbook from Delphi Q231614 KB231614 January 24, 2007
• 225029 How To Determine Which Version of Excel Wrote a Workbook Q225029 KB225029 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
• 219423 How to remove the Office 2000 CD1 Q219423 KB219423 January 24, 2007
• 214797 How To Automate Excel Using Perl for Win32 Q214797 KB214797 January 24, 2007
• 214259 How to use grouping for fields in a PivotTable in Excel Q214259 KB214259 January 24, 2007
• 214249 How to use the Conditional Sum Wizard in Microsoft Excel Q214249 KB214249 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
• 213837 How to run subroutines and macros from Visual Basic in Excel 2000 or Excel 2002 Q213837 KB213837 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
• 213638 How to create a macro that counts comments Q213638 KB213638 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
• 212144 Hyphens and apostrophes are sorted after alphabetic letters in Excel Q212144 KB212144 January 24, 2007
• 211835 How to control the placement of objects Q211835 KB211835 January 24, 2007
• 205548 How to use A functions in Excel Q205548 KB205548 January 23, 2007
• 200378 How to install Windows 98 to a new folder to troubleshoot problems in Office 2000 Q200378 KB200378 January 23, 2007
• 194611 How To Create and Call an Excel Macro Programmatically from VB Q194611 KB194611 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
• 181201 HLOOKUP, VLOOKUP, LOOKUP return incorrect values in Excel Q181201 KB181201 January 22, 2007
• 179706 How to use MFC to automate Excel and create and format a new workbook Q179706 KB179706 January 22, 2007
• 178605 How To Determine the Version of a Microsoft Excel Workbook Q178605 KB178605 January 22, 2007
• 164317 How to sum a range of cells based on a number format in Excel Q164317 KB164317 January 19, 2007
• 149235 How to help prevent file corruption in Excel Q149235 KB149235 January 19, 2007
• 123183 How to export data to a text file with comma and quote delimiter in Excel Q123183 KB123183 January 19, 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
• 307292 How To: Dismiss a Dialog Box Displayed by an Office Application with Visual Basic .NET Q307292 KB307292 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
• 907349 How to troubleshoot video issues in Office programs Q907349 KB907349 December 7, 2006
• 213355 How to find duplicate entries in a column by using a macro in Excel 2000 Q213355 KB213355 November 23, 2006
• 61090 How to use cell references and defined names in criteria in Excel Q61090 KB61090 November 23, 2006
• 180625 How to use Automation to modify the Office menu Q180625 KB180625 November 21, 2006
• 48198 How to set the starting page number in the header or footer in Excel Q48198 KB48198 November 16, 2006
• 302087 How to run Office 2000 from a network server Q302087 KB302087 October 13, 2006
• 265113 How to make a macro that automatically starts when you open a workbook in Excel 2000 Q265113 KB265113 October 11, 2006
• 240077 How to use macros to delete duplicate items in a list in Excel 2000 Q240077 KB240077 October 11, 2006
• 213615 How to add the workbook path to the footer in Excel 2000 Q213615 KB213615 October 11, 2006
• 149831 How to Populate an Array with a Discontiguous Range Q149831 KB149831 October 11, 2006
• 147392 How to Force Macro Code to Wait for Outside Procedure Q147392 KB147392 October 11, 2006
• 142588 How to compare two cells and ignore leading and trailing spaces by using the TRIM worksheet function Q142588 KB142588 September 13, 2006
• 295646 How To Transfer Data from ADO Data Source to Excel with ADO Q295646 KB295646 August 23, 2006
• 233073 How to prevent the automatic creation of hyperlinks Q233073 KB233073 May 12, 2006
• 830502 How to customize menus and menu bars in Excel Q830502 KB830502 January 11, 2006
• 304423 HOW TO: Use Functions in Formulas in Excel 2000 Q304423 KB304423 January 7, 2006
• 286142 HOW TO: Use Find to Search Multiple Worksheets in Excel 2000 Q286142 KB286142 January 6, 2006
• 279199 HOW TO: Include Both Value Labels and Percentage Labels on a Pie Chart in Excel 2000 Q279199 KB279199 January 6, 2006
• 213961 HOW TO: Use SUM Function on Only Odd or Even Rows in Excel 2000 Q213961 KB213961 January 6, 2006
• 200724 HOW TO: Use the Keyboard to Change the Active Cell in Excel 2000 Q200724 KB200724 January 6, 2006
• 255275 How to determine the version of your Office 2000 program Q255275 KB255275 December 20, 2005
• 222101 How to find and use Office object model documentation Q222101 KB222101 November 22, 2005
• 256624 HOWTO: Use a COM Add-In Function as an Excel Worksheet Function Q256624 KB256624 August 23, 2005
• 147640 How to Hide Records with Duplicate Cell Entries Q147640 KB147640 August 17, 2005
• 213624 HOW TO: Create an Auto_Open Macro to Show the Data Form Dialog Box in Excel 2000 Q213624 KB213624 June 23, 2005
• 280290 How to install an Excel Add-in (XLA or XLL) with Automation Q280290 KB280290 June 10, 2005
• 212174 How to save files in other formats in Excel 2000 Q212174 KB212174 March 30, 2005
• 214253 How to link to data in a file that is damaged in Excel 2000 Q214253 KB214253 October 28, 2004
• 211963 HOW TO: Use Custom Toolbars from Excel 5.0 in Excel 2000 Q211963 KB211963 October 28, 2004
• 207438 How to prevent the Office Clipboard toolbar from appearing when you use multiple Copy commands in any Office 2000 program Q207438 KB207438 October 7, 2004
• 211563 How to create an add-in file in Excel 2000 Q211563 KB211563 October 6, 2004
• 264582 How to change default colors in Excel 2000 Q264582 KB264582 September 30, 2004
• 213951 How to troubleshoot the source of the problem when you save files in Excel 2000 and they become corrupted Q213951 KB213951 September 30, 2004
• 263564 How to remove password protection from worksheets, workbooks, and shared workbooks in Excel 2000 Q263564 KB263564 September 28, 2004
• 214388 How to run multiple versions of Excel on the same computer Q214388 KB214388 September 28, 2004
• 240150 How to use the Excel startup folders in Excel 2000 Q240150 KB240150 September 27, 2004
• 214246 How to use the Template Wizard with the Data Tracking add-in in Excel 2000 Q214246 KB214246 September 23, 2004
• 214127 How to remove links from a worksheet in Excel 2000 Q214127 KB214127 September 9, 2004
• 214119 How to create charts with multiple groups of stacked bars in Excel 2000 Q214119 KB214119 September 9, 2004
• 214099 How to work with serial number dates and Julian dates in Excel 2000 Q214099 KB214099 September 9, 2004
• 273583 How to optimize PivotTable performance in Excel 2000 Q273583 KB273583 July 27, 2004
• 240794 How to Determine the Path for an Office Application Q240794 KB240794 July 15, 2004
• 199841 How To Display ASP Results Using Excel in IE with MIME Types Q199841 KB199841 July 15, 2004
• 238393 How To Use Visual C++ to Access DocumentProperties with Automation Q238393 KB238393 July 13, 2004
• 247985 How To Find the Path and Version of an Office Application from Visual C++ Q247985 KB247985 June 30, 2004
• 219430 How To Create/Format an Excel Workbook Using Visual J++ Automation Q219430 KB219430 June 30, 2004
• 142387 How To Create Excel Chart w/OLE Automation from Visual Basic Q142387 KB142387 June 30, 2004
• 311731 How To Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual Basic .NET Q311731 KB311731 June 29, 2004
• 308292 How To Automate Excel to Create And Format a New Workbook Using C++ .NET and MFC Q308292 KB308292 June 29, 2004
• 263958 HOW TO: Install or Repair Microsoft Excel Features in Excel 2000 Q263958 KB263958 November 5, 2003
• 244789 HOW TO: Use the SUBTOTAL Function with AutoFiltered Lists in Excel 2000 Q244789 KB244789 November 5, 2003
• 214292 HOW TO: Add a Series to an XY (Scatter) Chart with a Second X-Axis in Excel 2000 Q214292 KB214292 November 5, 2003
• 213958 HOW TO: Add Text to the X-Axis or Y-Axis on a Chart in Excel 2000 Q213958 KB213958 November 5, 2003
• 213947 HOW TO: Create PivotTables from Multiple Consolidation Ranges in Excel 2000 Q213947 KB213947 November 5, 2003
• 213882 HOW TO: Use Microsoft Map to Display Postal Code Centers in Excel 2000 Q213882 KB213882 November 5, 2003
• 211949 HOW TO: Use the GetPivotData Worksheet Function in Excel 2000 Q211949 KB211949 November 5, 2003
• 211693 HOW TO: Link to a Particular Worksheet from a Web Page in Excel 2000 Q211693 KB211693 November 5, 2003
• 211561 HOW TO: Convert an Add-in File into a Workbook in Excel 2000 Q211561 KB211561 November 5, 2003
• 211459 HOW TO: Use Wildcard Characters in Microsoft Excel 2000 Parameter Queries Q211459 KB211459 November 5, 2003
• 275170 HOW TO: Perform a Two-Dimensional Lookup in Excel 2000 Q275170 KB275170 October 8, 2003
• 214324 HOW TO: Use Advanced Filter to Exclude Records in Excel 2000 Q214324 KB214324 October 8, 2003
• 214258 HOW TO: Create Multiple Views, Create and Print a Report in Excel 2000 Q214258 KB214258 October 8, 2003
• 213921 HOW TO: Add Totals to a Stacked Column Chart in Excel 2000 Q213921 KB213921 October 8, 2003
• 211926 HOW TO: Specify Dynamic Web Query Parameters in Excel 2000 Q211926 KB211926 October 8, 2003
• 279412 HOW TO: Use Natural Language Formulas in Excel 2000 Q279412 KB279412 September 27, 2003
• 214252 HOW TO: Use the Excel Lookup Wizard (Lookup.xla) in Excel 2000 Q214252 KB214252 September 27, 2003
• 214251 HOW TO: Use the INDEX and LINEST Functions to Solve for New X-Values in Excel 2000 Q214251 KB214251 September 27, 2003
• 214247 HOW TO: Hide Records with Duplicate Cell Entries in Excel 2000 Q214247 KB214247 September 27, 2003
• 214057 HOW TO: Display Data as Percentage of the Total in a PivotTable in Excel 2000 Q214057 KB214057 September 27, 2003
• 213929 HOW TO: Create a Single Stacked Column Chart or Single Bar Chart in Excel 2000 Q213929 KB213929 September 27, 2003
• 213928 HOW TO: Create Two Pie Charts in One in Excel 2000 Q213928 KB213928 September 27, 2003
• 213920 HOW TO: Analyze a Questionnaire or Survey with a PivotTable in Excel 2000 Q213920 KB213920 September 27, 2003
• 213916 HOW TO: Rank Duplicate Values Sequentially in Excel 2000 Q213916 KB213916 September 27, 2003
• 213887 HOW TO: Find the Secant, Cosecant, or Cotangent of an Angle in Excel 2000 Q213887 KB213887 September 27, 2003
• 213884 HOW TO: Hide Gridlines in a Selected Area of a Worksheet in Excel 2000 Q213884 KB213884 September 27, 2003
• 212121 HOW TO: Rename a Chart by Using the Name Box in Excel 2000 Q212121 KB212121 September 27, 2003
• 212079 HOW TO: Sort Cells Without Sorting Linked Cells in Excel 2000 Q212079 KB212079 September 27, 2003
• 275611 HOW TO: Work with an HTML Table That Contains Merged Cells in Excel 2000 Q275611 KB275611 September 25, 2003
• 263552 HOW TO: Turn AutoComplete On or Off in Excel 2000 Q263552 KB263552 September 25, 2003
• 259200 HOW TO: Use NETWORKDAYS with Multiple Holidays in Excel 2000 Q259200 KB259200 September 25, 2003
• 231421 HOW TO: Create a Normal Chart from a PivotTable in Excel 2000 Q231421 KB231421 September 25, 2003
• 213922 HOW TO: Index Data in a PivotTable in Excel 2000 Q213922 KB213922 September 25, 2003