Excel 2007 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 2007 starts with letter H that have been released. The list is daily updated.

• 2625107 How do I make an Excel single-slash\multi-slash header? - EeeKB Q2625107 KB2625107 January 25, 2021
• 926535 How to clear the list of recently used files in 2007 Office programs Q926535 KB926535 January 25, 2021
• 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
• 2591018 How to obtain Service Pack 3 (SP3) packages in 2007 Office system, 2007 Office servers, and Windows SharePoint Services 3.0 Q2591018 KB2591018 April 10, 2020
• 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
• 2758592 How to troubleshoot crashing and not responding issues with Excel Q2758592 KB2758592 May 27, 2019
• 833402 How to convert Excel column numbers into alphabetical characters Q833402 KB833402 May 27, 2019
• 826511 How to use a setup log to troubleshoot setup problems in Office Q826511 KB826511 May 27, 2019
• 302094 How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays Q302094 KB302094 May 27, 2019
• 291320 How to use macro examples to delete duplicate items in a list in Excel Q291320 KB291320 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
• 826922 How to prevent files from opening automatically in Excel Q826922 KB826922 May 9, 2019
• 2779852 How to troubleshoot "available resources" errors in Excel Q2779852 KB2779852 March 28, 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
• 926530 How to use the registry to configure 2007 Office programs to prompt you when a packager object runs Q926530 KB926530 July 6, 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
• 923718 How to troubleshoot a failed installation of the Beta 2 Technical Refresh update for 2007 Microsoft Office suites Q923718 KB923718 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
• 329820 How to use Office programs with the Norton AntiVirus Office plug-in Q329820 KB329820 April 21, 2018
• 926368 How to create a custom chart format in Excel 2007 Q926368 KB926368 April 20, 2018
• 924461 How to change the company name and user name in 2007 Office programs Q924461 KB924461 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
• 325091 How to minimize the size of an XML Spreadsheet file in Excel Q325091 KB325091 April 20, 2018
• 308983 How to specify trusted sources for Digital Certificates in Excel, in PowerPoint, in and Word Q308983 KB308983 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
• 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
• 2547338 Hyperlink to MHT File in Office Documents Fails to Load in Internet Explorer Q2547338 KB2547338 April 18, 2018
• 924617 How administrators can use Office policy templates together with the Group Policy settings of Windows Q924617 KB924617 April 18, 2018
• 924284 How to enable the Memory Diagnostic test for 2007 Office products on a Windows Server-based computer Q924284 KB924284 April 18, 2018
• 827100 How to insert scanned images in Office 2007 and Office 2003 Programs Q827100 KB827100 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
• 822750 How to handle events for Excel by using Visual Basic .NET Q822750 KB822750 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
• 302901 How to build an Office COM add-in by using Visual C# .NET Q302901 KB302901 April 18, 2018
• 288130 How to use ASP to build spreadsheet XML for client-side display Q288130 KB288130 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
• 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
• 928116 How to determine which version of a 2007 Office product is installed Q928116 KB928116 April 17, 2018
• 925757 How to enable or disable hyperlink warning messages in 2007 Office programs and in Office 2010 programs Q925757 KB925757 April 17, 2018
• 925180 How to view Word 2007, or later versions files by using Word Viewer 2003 Q925180 KB925180 April 17, 2018
• 924614 How to use the repair process in the 2007 Office programs Q924614 KB924614 April 17, 2018
• 924611 How to install the individual 2007 Office features or to repair the installed 2007 Office programs Q924611 KB924611 April 17, 2018
• 924460 How to manage templates in 2007 Office programs and in 2010 Office programs Q924460 KB924460 April 17, 2018
• 919895 How to troubleshoot problems that you may experience when you try to activate a 2007 Office suite Q919895 KB919895 April 17, 2018
• 919196 How to troubleshoot Excel 2007 startup problems Q919196 KB919196 April 17, 2018
• 914813 How to use a VBA macro to add labels to data points in an XY (scatter) chart or in a bubble chart in Excel 2007 Q914813 KB914813 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
• 830287 How to create a dynamic defined range in an Excel worksheet Q830287 KB830287 April 17, 2018
• 827298 How to recover a lost workbook or a lost version of a workbook in Excel 2007 and in Excel 2003 Q827298 KB827298 April 17, 2018
• 826921 How to control the startup message about updating linked workbooks in Excel Q826921 KB826921 April 17, 2018
• 826207 How to change the voice that is used for the Text to Speech feature in Office 2003 and in Office 2007 Q826207 KB826207 April 17, 2018
• 825012 How formula calculations are performed in Excel Q825012 KB825012 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
• 812386 How to sort worksheets alphanumerically in a workbook in Excel Q812386 KB812386 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
• 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
• 291363 How to use the "Insert Options" button in Excel Q291363 KB291363 April 17, 2018
• 291321 How to programmatically reset a workbook to default styles Q291321 KB291321 April 17, 2018
• 291073 How to use the forms controls on a worksheet in Excel Q291073 KB291073 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
• 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
• 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
• 926369 How to create a Gantt chart that uses hours as the scale in Excel 2007 Q926369 KB926369 April 16, 2018
• 832286 How to save the addresses from a Word mail-merge label document to Excel Q832286 KB832286 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
• 822107 How to use startup folders in Excel Q822107 KB822107 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
• 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
• 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
• 282856 How to create and use two-input data tables in Microsoft Excel Q282856 KB282856 April 16, 2018
• 282135 How to display more digits in trendline equation coefficients in Excel Q282135 KB282135 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
• 940167 How to connect Excel to SQL Server 2005 Analysis Services Q940167 KB940167 April 13, 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
• 213449 How to convert degrees/minutes/seconds angles to or from decimal angles in Excel Q213449 KB213449 May 17, 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
• 928723 How to use the Alert ID feature in the 2007 Office programs when you search for a warning or an error message in the Microsoft Knowledge Base Q928723 KB928723 December 9, 2015
• 2735567 How to obtain the latest versions of MSOLAP Q2735567 KB2735567 September 23, 2015
• 924074 How to open new file formats in earlier versions of Microsoft Office Q924074 KB924074 September 23, 2015
• 935787 How to create legacy Office files in the 2007 Office system Q935787 KB935787 January 16, 2015
• 932493 How to manage the "Allow users with earlier versions of Office to read with browsers supporting Information Rights Management" option in the 2007 Office programs Q932493 KB932493 January 16, 2015
• 928738 How to configure the Excel Services Unattended Service account in Microsoft Office SharePoint Server 2007 Q928738 KB928738 January 16, 2015
• 928027 How to access workbooks that contain menu and toolbar commands for the 2007 Office programs through Office Offline Q928027 KB928027 January 16, 2015
• 926707 Help content does not appear when you click "Help" during the setup of a 2007 Office program on a computer that is running a 64-bit version of Windows XP or of Windows Vista Q926707 KB926707 January 16, 2015
• 926426 Help content may not appear as expected in 2007 Office programs Q926426 KB926426 January 16, 2015
• 274680 How to use MFC to retrieve a list of macro names in an Office document Q274680 KB274680 December 23, 2014
• 826516 How to make sure that your Office document has a valid digital signature in 2007 Office products and in Office 2003 Q826516 KB826516 February 28, 2014
• 291358 How to use the Paste Options button in Excel Q291358 KB291358 September 23, 2013
• 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
• 949585 How to obtain the latest service pack for the 2007 Office suite Q949585 KB949585 June 13, 2012
• 873209 How to install the Excel 2002 Report Manager add-in and Template Wizard add-in in Excel 2003 and in Excel 2007 Q873209 KB873209 February 15, 2012
• 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
• 2534458 How to obtain the latest service pack for the 2007 Office suite Q2534458 KB2534458 April 10, 2011
• 2519419 How to obtain a new product key for a Microsoft Office suite Q2519419 KB2519419 April 7, 2011
• 945598 How to determine the version of an installed 2007 Office language pack Q945598 KB945598 April 7, 2010
• 977994 How to use the Excel Automation Addin to create user defined formulas for Microsoft Office Excel Q977994 KB977994 December 16, 2009
• 932921 How to use components of the .NET Framework 3.0 to create and then to stream an Office Word 2007 document and an Office Excel 2007 workbook to a client computer Q932921 KB932921 March 23, 2009
• 931866 How to use the Office XML file format and the packaging components from the .NET Framework 3.0 to create a simple Excel 2007 workbook or a simple Word 2007 document Q931866 KB931866 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
• 931406 How to apply different passwords or permissions to separate ranges in worksheets in Excel 2007 Q931406 KB931406 October 15, 2007
• 288367 How to configure Office applications to run under a specific user account Q288367 KB288367 August 23, 2007
• 288368 How to configure Office applications for automation from a COM+/MTS package Q288368 KB288368 July 2, 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
• 830033 How to apply Windows XP themes to Office COM add-ins Q830033 KB830033 May 16, 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
• 300950 How to troubleshoot custom Smart Tags in Office Q300950 KB300950 April 13, 2007
• 288366 How to configure Office applications to run under the interactive user account Q288366 KB288366 March 28, 2007
• 307803 How to bring an unmanaged installation of Office into a managed state Q307803 KB307803 March 22, 2007
• 933428 How to open Word 2007 files or Excel 2007 files in Microsoft Works Q933428 KB933428 March 14, 2007
• 214011 How to create a column chart with two Y-axes in Excel Q214011 KB214011 February 8, 2007
• 288972 How to suppress the printing of errors in workbook cells in Excel 2002, Excel 2003 and Excel 2007 Q288972 KB288972 February 5, 2007
• 213773 How to create data validation circles for printing in Excel Q213773 KB213773 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
• 205548 How to use A functions in Excel Q205548 KB205548 January 23, 2007
• 123183 How to export data to a text file with comma and quote delimiter in Excel Q123183 KB123183 January 19, 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
• 61090 How to use cell references and defined names in criteria in Excel Q61090 KB61090 November 23, 2006
• 290148 How to use the Undo feature with inserted objects in Office programs Q290148 KB290148 November 21, 2006
• 48198 How to set the starting page number in the header or footer in Excel Q48198 KB48198 November 16, 2006