Excel 2010 articles, fixes and updates - April 2018

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Excel 2010 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
• 2761239 Cell content is displayed as #N/A! after you enable editing in a workbook in Protected View in Excel 2010 or Excel 2013 Q2761239 KB2761239 April 22, 2018
• 982583 You receive an error message when you try to install the PowerPivot add-in on a computer that is running Windows Vista SP1 or Windows Server 2008 Q982583 KB982583 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
• 2986404 Office Applications experience a serious problem with an add-in Q2986404 KB2986404 April 20, 2018
• 2829791 Coloring Locked Cells in Microsoft Excel Q2829791 KB2829791 April 20, 2018
• 968779 Improved handling of warning when saving encrypted binary file formats in Office 2007 Q968779 KB968779 April 19, 2018
• 2551525 Function names changed in non-English versions of Excel 2010 SP1 Q2551525 KB2551525 April 18, 2018
• 2547338 Hyperlink to MHT File in Office Documents Fails to Load in Internet Explorer Q2547338 KB2547338 April 18, 2018
• 982242 Microsoft Office 2010 Upload Center opens the wrong file on a SharePoint Server Q982242 KB982242 April 18, 2018
• 982240 "Your beta software has expired" message in Office 2010 Q982240 KB982240 April 18, 2018
• 978753 Some settings for the Visual Basic Editor that you enabled in an earlier version of an Office application are disabled in Office 2010 Q978753 KB978753 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
• 2761244 F4 keyboard shortcut does not work as expected in Excel 2013, Excel 2010, and Excel 2007 Q2761244 KB2761244 April 17, 2018
• 982258 "This 64-bit product may not be installed with Microsoft Office Click-to-Run" Error message when you try to install a 64-bit version of Office Q982258 KB982258 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
• 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
• 919196 How to troubleshoot Excel 2007 startup problems Q919196 KB919196 April 17, 2018
• 903771 Information about the ability to uninstall Office updates Q903771 KB903771 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
• 827371 Description of the NORMDIST function in Excel Q827371 KB827371 April 17, 2018
• 826921 How to control the startup message about updating linked workbooks in Excel Q826921 KB826921 April 17, 2018
• 826917 Nothing happens when you try to use the "Export to Microsoft Excel" command in Internet Explorer Q826917 KB826917 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
• 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
• 818954 "Error 1919. Error configuring ODBC data source" error messages when you run the Setup program for Office Q818954 KB818954 April 17, 2018
• 814068 Description of the way that Excel saves files Q814068 KB814068 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
• 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
• 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
• 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
• 282847 Some Excel features are unavailable if you disable Visual Basic for Applications and run Excel Q282847 KB282847 April 17, 2018
• 277601 Blank pages are unexpectedly printed in Excel Q277601 KB277601 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
• 214395 How Excel determines the current mode of calculation Q214395 KB214395 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
• 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
• 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
• 211967 Chart trendline formula is inaccurate in Excel Q211967 KB211967 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
• 78113 Floating-point arithmetic may give inaccurate results in Excel Q78113 KB78113 April 17, 2018
• 2417395 "This document contains invalid signatures" when opening Excel files that are digitally signed in a newer version Q2417395 KB2417395 April 3, 2018