Excel 2010 articles, fixes and updates - Year 2012

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 Year 2012. The list is daily updated.

• 2565425 Microsoft Word does not recognize the linked Excel object after file move Q2565425 KB2565425 December 20, 2012
• 2786632 Excel client does not use Secure Store Service credential to connect to database Q2786632 KB2786632 December 19, 2012
• 2781086 Enums for xlThemeColor are Incorrectly Named Q2781086 KB2781086 December 19, 2012
• 2790770 Excel does not refresh pivot table field list for dynamic sets created by Analysis Services Personalization Extensions Q2790770 KB2790770 December 17, 2012
• 2983111 The stapling gallery and the duplexing gallery do not appear in the printer settings in an Office application even if the printer supports these two features Q2983111 KB2983111 December 14, 2012
• 983111 The stapling gallery and the duplexing gallery do not appear in the printer settings in an Office application even if the printer supports these two features Q983111 KB983111 December 14, 2012
• 2983069 Some print options are not available in Word 2010, in Excel 2010, or in PowerPoint 2010 Q2983069 KB2983069 December 13, 2012
• 2583221 The Tablet PC pen eraser does not work in Microsoft Office. Q2583221 KB2583221 December 13, 2012
• 2983109 Garbage characters may be included in an .odc file created in Excel Q2983109 KB2983109 December 12, 2012
• 2669445 OLAP PivotTable Filtered Field is limited to 32000 unique items Q2669445 KB2669445 December 12, 2012
• 2458237 Error message when you try to open an Excel file on a 32-bit computer: "Excel cannot complete this task with available resources. Choose less data or close other applications." Q2458237 KB2458237 December 12, 2012
• 983109 Garbage characters may be included in an .odc file created in Excel Q983109 KB983109 December 12, 2012
• 2983462 How to sequence Office 2010 in App-V 4.5 SP2 or App-V 4.6 Q2983462 KB2983462 December 10, 2012
• 2712071 You cannot access a PowerPivot workbook as a data source in Excel 2010 Q2712071 KB2712071 December 3, 2012
• 2755172 You cannot use VBA code to configure the Cap Type and Join Type properties in Excel Q2755172 KB2755172 November 30, 2012
• 149663 Wrap text does not adjust row height in Excel Q149663 KB149663 November 28, 2012
• 2748721 Two Team tabs are displayed on the ribbon in certain Office applications after you install Visual Studio 2012 and Visual Studio 2010 Q2748721 KB2748721 November 20, 2012
• 2983129 Text box margins are lost in an Excel workbook when the workbook is saved as "Excel 97-2003 Workbook" and then reopened in Excel 2003 Q2983129 KB2983129 November 1, 2012
• 2983122 The x-coordinate of the scatter data points can be plotted only on the major units of the x-axis in a combination chart in Excel Q2983122 KB2983122 November 1, 2012
• 2535767 OLAP Server Formatting results in DISCOVER command against all cubes Q2535767 KB2535767 November 1, 2012
• 2459816 Inserting Rows in Excel Tables with Structured References May Take Several Seconds Q2459816 KB2459816 November 1, 2012
• 2249320 Unable to add refedit control to VBA userform. Q2249320 KB2249320 November 1, 2012
• 983129 Text box margins are lost in an Excel workbook when the workbook is saved as "Excel 97-2003 Workbook" and then reopened in Excel 2003 Q983129 KB983129 November 1, 2012
• 983122 The x-coordinate of the scatter data points can be plotted only on the major units of the x-axis in a combination chart in Excel Q983122 KB983122 November 1, 2012
• 982273 Office Excel 2003 chart axis and chart colors may be different in Excel 2013 or Excel 2010 Q982273 KB982273 November 1, 2012
• 291110 Cannot use keyboard shortcuts to select ranges in RefEdit control in Excel Q291110 KB291110 November 1, 2012
• 2983119 "Run-time error '-2147467259 (80004005)'" when you programmatically set a property of a chart in Excel Q2983119 KB2983119 October 31, 2012
• 2983047 An Office document opens in Protected View even though you enable the "Open Office documents as read/write while browsing" policy setting Q2983047 KB2983047 October 31, 2012
• 2983034 ATP function names are not automatically translated in Excel Q2983034 KB2983034 October 31, 2012
• 2983031 The DSUM and DCOUNT functions in Excel do not work with PivotTables Q2983031 KB2983031 October 31, 2012
• 2625969 Sparklines do not print on right edge of page when next cells to right are merged Q2625969 KB2625969 October 31, 2012
• 2601322 "Fixed objects will move" notice comes up repeatedly when filtering a range Q2601322 KB2601322 October 31, 2012
• 2295835 Office 2010 and Office 2013 document files that are opened as read-only from a SharePoint site that enables anonymous access are not cached to your local Office documents cache Q2295835 KB2295835 October 31, 2012
• 983034 ATP function names are not automatically translated in Excel Q983034 KB983034 October 31, 2012
• 983031 The DSUM and DCOUNT functions in Excel do not work with PivotTables Q983031 KB983031 October 31, 2012
• 981236 Sparklines are not filled in the new cells that correspond to extended ranges in Excel Q981236 KB981236 October 31, 2012
• 274500 "Save changes in <filename>" prompt even if no changes are made Q274500 KB274500 October 18, 2012
• 2772563 Excel cannot change the paper size using Mac RDC Q2772563 KB2772563 October 17, 2012
• 2671933 Convert and open unsupported file formats to Excel 2010 Q2671933 KB2671933 October 5, 2012
• 2768406 IAdviseSink::OnDataChange not called when copy/pasting Excel cells Q2768406 KB2768406 October 4, 2012
• 2720580 Using Advanced Filters in Excel 2010 Q2720580 KB2720580 October 3, 2012
• 2697462 Text has incorrect format when using paste in Microsoft Office Q2697462 KB2697462 October 2, 2012
• 2678993 Print Preview doesn't match print in Excel 2010 Q2678993 KB2678993 October 2, 2012
• 2745652 Object Model calls may fail from WorkbookOpen event when exiting Protected View Q2745652 KB2745652 September 18, 2012
• 2750155 Office files that have RMS protection seem to crash Q2750155 KB2750155 September 4, 2012
• 2616546 Word and PowerPoint will print gridlines of embedded Excel object Q2616546 KB2616546 August 16, 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
• 2589320 MS11-089: Description of the security update for Microsoft Office 2010 and Microsoft Office 2010 Service Pack 1: December 13, 2011 Q2589320 KB2589320 July 18, 2012
• 2725909 Error message when you try to open an IRM protected Excel 2010 workbook Q2725909 KB2725909 July 6, 2012
• 2511140 Excel add ins do not follow Office user interface language setting Q2511140 KB2511140 July 3, 2012
• 2716388 Excel 2010: Sort is slower and causes errors after MS12-030 Q2716388 KB2716388 June 28, 2012
• 2721825 Unable to create DSN for Microsoft Office System Driver on 64-bit versions of Windows Q2721825 KB2721825 June 26, 2012
• 949585 How to obtain the latest service pack for the 2007 Office suite Q949585 KB949585 June 13, 2012
• 2475796 [SDP 3][2b9f8e72-b947-496e-b197-762a74fcaaf2] Excel Baseline AppLog, RegKeys, CheckSym Q2475796 KB2475796 June 1, 2012
• 2461088 [SDP 2][127EBB54-94F2-4E7E-A086-514C075E7529] Excel - Checksym Applog Q2461088 KB2461088 June 1, 2012
• 2703186 Fix for an error in custom Office solutions that occurs after you install MS12-027 Q2703186 KB2703186 May 23, 2012
• 2451764 Excel 97-2003 workbooks (.xls) display #N/A! for Analysis Toolpak functions when opened in Excel 2003, Excel 2007 or Excel 2010 Q2451764 KB2451764 May 17, 2012
• 2409781 Filtered out cells are overwritten at copy and paste Q2409781 KB2409781 May 17, 2012
• 2694355 Excel 2010: Recording a macro in Header/Footer produces Strange Behavior Q2694355 KB2694355 May 15, 2012
• 2384361 Performance degradation opening Excel workbooks Q2384361 KB2384361 May 15, 2012
• 2293211 MS10-080: Vulnerabilities in Microsoft Excel could allow remote code execution Q2293211 KB2293211 May 11, 2012
• 2553070 MS11-072: Description of the security update for Excel 2010: September 13, 2011 Q2553070 KB2553070 May 8, 2012
• 2694157 Cannot Autofit Rows or Columns if Cells are Merged Wrapped Q2694157 KB2694157 April 18, 2012
• 303409 You cannot import an image with a scanner or a camera that uses the TWAIN drivers in Office Q303409 KB303409 April 12, 2012
• 2062934 Error inserting SmartArt: "The following file or files contain errors which prevent them from working." Q2062934 KB2062934 April 11, 2012
• 2674515 Office 2010 error: This action is only valid for products that are currently installed Q2674515 KB2674515 March 21, 2012
• 2683270 VBA Error Handling may result in search for WINHELP.INI Q2683270 KB2683270 February 28, 2012
• 2480833 Percentage format in pasted chart data table and axis will change to Numeric when source workbook is closed Q2480833 KB2480833 February 17, 2012
• 170787 Description of limitations of custom functions in Excel Q170787 KB170787 February 16, 2012
• 2597710 Excel may experience an unhandled exception when attempting to call Chart.Activate in the Worksheet_PivotTableUpdate() event Q2597710 KB2597710 February 15, 2012
• 2526883 Excel 2010 error "Excel cannot complete this task with available resources" Q2526883 KB2526883 February 15, 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
• 214286 XL: Some Worksheet Functions Do Not Allow Array Constants Q214286 KB214286 February 2, 2012
• 214078 Excel: How to Find the Percentage of Change Between Values Q214078 KB214078 February 1, 2012
• 2671038 Subtotal Remove All command does not remove all Subtotals in Excel versions prior to 2010 Q2671038 KB2671038 January 30, 2012