kbupdate.info ›
Daily Updated!
Excel 2007 articles, fixes and updates - April 2018
Daily Updated!
chronological list: 2022 | 2021 | 2020 | 2019 | 2018/12 9 7 5 4 | 2017 | 2016 | 2015/12 9 4 1 | ... 2003
alphabetical list: A B C D E F G H I J K L M N O P 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 2007 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
- 974070 The changes that you made to a shared.xls file in an offline folder are not saved on a file server that is running Windows Server 2003 or Windows XP Q974070 KB974070 April 22, 2018
- 930069 Columns in a text box do not generate a compatibility conflict in the Compatibility Pack for Word, Excel, and PowerPoint 2007/2010 File Formats when you open an Excel 2007 or 2010 workbook in Excel 2003 Q930069 KB930069 April 22, 2018
- 928974 Deleting or modifying rows that are above and below a hidden row in a filtered Excel 2007 worksheet also deletes or modifies the hidden row Q928974 KB928974 April 22, 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
- 835413 Missing clips appear with the title Dglxasset.aspx when you search for clips in Office Q835413 KB835413 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
- 926946 Error message when you try to install a 2007 Office update package: "The installation of this package failed" Q926946 KB926946 April 21, 2018
- 919066 Error message when you try to change a Microsoft Organization Chart 2.0 object in PowerPoint 2007, in Excel 2007, or in Word 2007 Q919066 KB919066 April 21, 2018
- 823838 The result is "FALSE" when you use the ISBLANK() function in an Excel spreadsheet Q823838 KB823838 April 21, 2018
- 818244 You receive an error message when you create a list from a filtered range of cells in Excel 2003 or when you create a table from a filtered range of cells in Excel 2007 Q818244 KB818244 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
- 2829791 Coloring Locked Cells in Microsoft Excel Q2829791 KB2829791 April 20, 2018
- 973823 Conditional formatting rules are duplicated when you copy and then paste cells in Excel 2007 Q973823 KB973823 April 20, 2018
- 954572 Description of the Excel 2007 hotfix package: June 23, 2008 Q954572 KB954572 April 20, 2018
- 951339 Error message when you try to open the Office Customization Tool: "Files necessary to run the Office Customization Tool were not found" Q951339 KB951339 April 20, 2018
- 941506 When you save an Excel 2007 workbook as a PDF file or as an XPS file, the layout differs from the layout in the Excel 2007 workbook Q941506 KB941506 April 20, 2018
- 937680 No progress occurs in the "Installation Progress" dialog box when you install the 2007 Office system or a stand-alone 2007 Office product Q937680 KB937680 April 20, 2018
- 928984 You cannot use the Name box to rename a chart in Excel 2007 Q928984 KB928984 April 20, 2018
- 928613 You receive a message when you try to run a macro in an encrypted workbook in Excel 2007: "Because of your security settings, macros have been disabled" Q928613 KB928613 April 20, 2018
- 928283 Error message when you use a VBA macro to save a shared Excel 2007 workbook: "Application-defined or object-defined error" Q928283 KB928283 April 20, 2018
- 927535 An Excel chart is blank when you apply a custom chart template in a 2007 Office program Q927535 KB927535 April 20, 2018
- 927476 Setup program crashes when you try to install a 2007 Office suite on a 64-bit version of Windows Server 2003 Q927476 KB927476 April 20, 2018
- 926368 How to create a custom chart format in Excel 2007 Q926368 KB926368 April 20, 2018
- 926316 The "Disable all Data Connections" option in the Trust Center is not applied to the data connections that you create after you open a workbook in Office Excel 2007 Q926316 KB926316 April 20, 2018
- 924461 How to change the company name and user name in 2007 Office programs Q924461 KB924461 April 20, 2018
- 922960 A picture or a graphic is distorted when you paste the picture or the graphic into a SmartArt graphic in Office 2007 Q922960 KB922960 April 20, 2018
- 899725 An active Microsoft Excel process continues to run after you use a VBA macro to programmatically quit Excel Q899725 KB899725 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
- 829247 Misleading labels in the output of the Analysis ToolPak t-Test tools in Excel Q829247 KB829247 April 20, 2018
- 828678 Excel statistical functions: Representing ties by using RANK Q828678 KB828678 April 20, 2018
- 828528 Excel statistical functions: LOGEST Q828528 KB828528 April 20, 2018
- 828526 Excel statistical functions: GROWTH Q828526 KB828526 April 20, 2018
- 828313 Excel statistical functions: CHIINV Q828313 KB828313 April 20, 2018
- 828234 Excel statistical functions: INTERCEPT Q828234 KB828234 April 20, 2018
- 828232 Excel statistical functions: STEYX Q828232 KB828232 April 20, 2018
- 828131 Excel statistical functions: RSQ Q828131 KB828131 April 20, 2018
- 828103 Differences between the Excel statistical functions STDEVPA and STDEVP Q828103 KB828103 April 20, 2018
- 827467 "Error 25090" error message when you start an Office program Q827467 KB827467 April 20, 2018
- 826924 How to apply different passwords or permissions to separate ranges in workbooks in Excel Q826924 KB826924 April 20, 2018
- 820738 Description of digital signatures and code signing in workbooks in Excel Q820738 KB820738 April 20, 2018
- 820204 How to change from absolute to relative or mixed references in a formula in Excel Q820204 KB820204 April 20, 2018
- 817137 Error message when you open a Word document or an Excel worksheet: "The document caused a serious error the last time it was opened" Q817137 KB817137 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
- 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
- 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
- 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
- 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
- 973932 Description of the Excel 2007 hotfix package (Excel-x-none.msp, Xlconv-x-none.msp): August 25, 2009 Q973932 KB973932 April 19, 2018
- 973402 Description of the Excel 2007 hotfix package (Excel-x-none.msp, Graph-x-none.msp, Xlview-x-none.msp): August 25, 2009 Q973402 KB973402 April 19, 2018
- 968779 Improved handling of warning when saving encrypted binary file formats in Office 2007 Q968779 KB968779 April 19, 2018
- 935569 Error message when you start a 2007 Office program on a computer that is running Outlook 2007 with Business Contact Manager: "Office application version does not match" Q935569 KB935569 April 19, 2018
- 926309 Message when you try to open a file that was saved in a prerelease version of the 2007 Office programs: "This file was created in a previous beta version" or "This workbook was created in an earlier beta version" Q926309 KB926309 April 19, 2018
- 840817 How to extract information from Office files by using Office file formats and schemas Q840817 KB840817 April 19, 2018
- 832392 You cannot use Photo Editor to save image from the Clipboard in Office Q832392 KB832392 April 19, 2018
- 827358 Excel statistical functions: NORMINV Q827358 KB827358 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
- 284876 Excel fails when Automation add-In loads Q284876 KB284876 April 19, 2018
- 2591039 Technical details about the 2007 Office system SP3 releases Q2591039 KB2591039 April 18, 2018
- 2547338 Hyperlink to MHT File in Office Documents Fails to Load in Internet Explorer Q2547338 KB2547338 April 18, 2018
- 946088 When you try to start or exit Word 2007, Excel 2007, or PowerPoint 2007 in Windows Vista, the application may crash Q946088 KB946088 April 18, 2018
- 936982 Description of the 2007 Microsoft Office suite Service Pack 1 Q936982 KB936982 April 18, 2018
- 928516 Description of product code GUIDs in 2007 Office suites and programs Q928516 KB928516 April 18, 2018
- 927150 A macro that is contained in an encrypted Office Open XML file does not run in 2007 Office programs Q927150 KB927150 April 18, 2018
- 926705 Fonts in a 2007 Office program may not appear as clear as expected Q926705 KB926705 April 18, 2018
- 926315 Error message when you try to install an Office program: "Microsoft Office <Product_Name> 2007 encountered an error during setup. Error 1714" Q926315 KB926315 April 18, 2018
- 926198 An .mdi file does not open in the Microsoft Office Document Imaging program that is included in the 2007 Office programs Q926198 KB926198 April 18, 2018
- 926054 Message when you try to use an earlier version of an Office program to open a file that was saved in a 2007 Office program: "This file was created in a previous beta version" Q926054 KB926054 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
- 918792 The "E-mail" command is missing or is unavailable in Excel 2007, in PowerPoint 2007, or in Word 2007 Q918792 KB918792 April 18, 2018
- 828958 Resources to help you activate a license in Microsoft Office programs Q828958 KB828958 April 18, 2018
- 828801 Excel statistical functions: TREND Q828801 KB828801 April 18, 2018
- 828533 Description of the LINEST function in Excel 2003 and in later versions of Excel Q828533 KB828533 April 18, 2018
- 828130 Excel Statistical Functions: POISSON Q828130 KB828130 April 18, 2018
- 827740 List of Photo Editor features that are not available in Picture Manager Q827740 KB827740 April 18, 2018
- 827729 Picture Manager does not start when you double-click a file after you associate an image file type with Picture Manager 2003 Q827729 KB827729 April 18, 2018
- 827369 Description of the NORMSDIST function in Excel Q827369 KB827369 April 18, 2018
- 827100 How to insert scanned images in Office 2007 and Office 2003 Programs Q827100 KB827100 April 18, 2018
- 826349 Description of the STDEV function in Excel 2003 and in later versions of Excel Q826349 KB826349 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
- 826112 Excel statistical functions: VAR Q826112 KB826112 April 18, 2018
- 822750 How to handle events for Excel by using Visual Basic .NET Q822750 KB822750 April 18, 2018
- 817095 Photo Editor is removed when you install Office 2003, Office 2007, or Office 2010 Q817095 KB817095 April 18, 2018
- 813970 Error message when you cancel the installation of Visual Basic for Applications: "An error occurred" Q813970 KB813970 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
- 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
- 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
- 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
- 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
- 2761244 F4 keyboard shortcut does not work as expected in Excel 2013, Excel 2010, and Excel 2007 Q2761244 KB2761244 April 17, 2018
- 959997 MS09-009: Description of the security update for Excel 2007: April 14, 2009 Q959997 KB959997 April 17, 2018
- 954326 MS08-052: Description of the security update for GDI+ for the 2007 Office system: September 9, 2008 Q954326 KB954326 April 17, 2018
- 952216 The "Send To OneNote 2007" printer is missing in the Print dialog box in a 2007 Office program Q952216 KB952216 April 17, 2018
- 947318 MS09-043: Description of the security update for Office 2003 Web Components for the 2007 Office system: August 11, 2009 Q947318 KB947318 April 17, 2018
- 934062 Description of the security update for the 2007 Office system: May 8, 2007 Q934062 KB934062 April 17, 2018
- 930479 DDE links are not automatically updated in Excel 2007 Q930479 KB930479 April 17, 2018
- 930076 Error message when you click buttons for macros in the Excel 2007 Quick Access Toolbar: "Cannot run the macro" Q930076 KB930076 April 17, 2018
- 928976 Excel 2007 error: Excel cannot complete this task with available resources. Q928976 KB928976 April 17, 2018
- 928718 When you try to open a fax that is a TIFF file in Microsoft Office Document Imaging, the fax opens in the Windows Picture and Fax Viewer instead Q928718 KB928718 April 17, 2018
- 928116 How to determine which version of a 2007 Office product is installed Q928116 KB928116 April 17, 2018
- 926279 Installation fails, and you receive an error message when you try to install a 2007 Office suite or program, or an Office 2010 suite or program by double-clicking an .msi file: "Error 1713" or "MSI Error 41" Q926279 KB926279 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
- 922848 You receive an error message when you try to open a file type that was blocked by your registry policy settings in Excel 2010, Excel 2007 or Excel 2003 Q922848 KB922848 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
- 912203 Description of the command-line switches that are supported by a software installation package, an update package, or a hotfix package that was created by using Microsoft Self-Extractor Q912203 KB912203 April 17, 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
- 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
- 884202 You must accept the Office End User License Agreement every time that you start an Office program Q884202 KB884202 April 17, 2018
- 839951 Excel may appear to endlessly loop calculating cells when you insert several subtotals in a workbook Q839951 KB839951 April 17, 2018
- 834008 You cannot send a document as an e-mail message from an Office 2003 or Office 2007 program Q834008 KB834008 April 17, 2018
- 830335 Microsoft Update and Windows Update offer updates for Office programs that you do not have installed Q830335 KB830335 April 17, 2018
- 830287 How to create a dynamic defined range in an Excel worksheet Q830287 KB830287 April 17, 2018
- 828795 Description of the RAND function in Excel Q828795 KB828795 April 17, 2018
- 828129 Excel statistical functions: PEARSON Q828129 KB828129 April 17, 2018
- 828124 Description of the CONFIDENCE statistical functions in Excel Q828124 KB828124 April 17, 2018
- 827459 Excel statistical functions: BINOMDIST Q827459 KB827459 April 17, 2018
- 827371 Description of the NORMDIST function in Excel Q827371 KB827371 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
- 826917 Nothing happens when you try to use the "Export to Microsoft Excel" command in Internet Explorer Q826917 KB826917 April 17, 2018
- 826772 Excel Statistical Functions: NORMSINV Q826772 KB826772 April 17, 2018
- 826513 “Your system is low on virtual memory” error message when you try to start an Office program Q826513 KB826513 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
- 822924 Description of Office features that are intended to enable collaboration and that are not intended to increase security Q822924 KB822924 April 17, 2018
- 822519 When you try to activate Office programs over the Internet, you receive an error message Q822519 KB822519 April 17, 2018
- 819964 How to convert a single column of addresses to a CSV text file in Excel Q819964 KB819964 April 17, 2018
- 818954 "Error 1919. Error configuring ODBC data source" error messages when you run the Setup program for Office Q818954 KB818954 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
- 813977 You receive a message when you try to open a Microsoft Excel workbook: "This workbook contains one or more links that cannot be updated" Q813977 KB813977 April 17, 2018
- 813971 Error message when you click Replace in the "Find and Replace" dialog box: "Microsoft Excel Cannot Find a Match" Q813971 KB813971 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
- 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
- 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
- 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
- 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
- 952878 Error message when you print an Excel workbook: "Margins do not fit page size" Q952878 KB952878 April 16, 2018
- 940166 Error message when you play a recorded macro to create a PivotTable in a new worksheet in Excel 2007: "Run-time error '1004': Application-defined error" or "Run-time error '5': Invalid procedure call or argument" Q940166 KB940166 April 16, 2018
- 928989 Worksheet tabs disappear when you change some "Display options for this workbook" options and then add a macro worksheet to a workbook in Excel 2007 Q928989 KB928989 April 16, 2018
- 928979 Error message when you try to open a workbook that you receive in an e-mail message for review in Excel 2007: "Excel cannot open the file" Q928979 KB928979 April 16, 2018
- 928465 A picture fill may unexpectedly stretch to fill a shape in 2007 Office programs Q928465 KB928465 April 16, 2018
- 926369 How to create a Gantt chart that uses hours as the scale in Excel 2007 Q926369 KB926369 April 16, 2018
- 922069 Information about the settings in the "Format Cells" dialog box in Excel 2007 Q922069 KB922069 April 16, 2018
- 919195 Visual Basic for Applications is disabled by default in Excel 2007 Q919195 KB919195 April 16, 2018
- 917650 An object may be hidden as an invisible object in a presentation in PowerPoint 2007 Q917650 KB917650 April 16, 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
- 822107 How to use startup folders in Excel Q822107 KB822107 April 16, 2018
- 819033 The Solver add-in may not work or does not find a solution in Excel 2003 and in Excel 2007 Q819033 KB819033 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
- 813969 You may receive an run-time error when you programmatically allow access to a Visual Basic project in Excel 2003 and in Excel 2007 Q813969 KB813969 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
- 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
- 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
- 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
- 2417395 "This document contains invalid signatures" when opening Excel files that are digitally signed in a newer version Q2417395 KB2417395 April 3, 2018