Excel 2013 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 2013 that have been released in Year 2012. The list is daily updated.

• 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
• 2764076 Workbook structure is not protected with a password after you save it as an .xls file in Excel 2013 Q2764076 KB2764076 December 19, 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
• 2769378 File size increases if you select "Add this data to the Data Model" in Excel 2013 Q2769378 KB2769378 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
• 2769338 "Excel found unreadable content in '<workbook name>'" error when you open an Excel 2013 workbook that contains Turkish letters in Excel 2010 Q2769338 KB2769338 December 7, 2012
• 2769366 Data shifts up when you use the "Text to Columns" tool to parse the data in an Excel workbook Q2769366 KB2769366 November 30, 2012
• 2769343 Excel 2013 does not recognize data as Date type data after you import the data from a SQL Server data source to an Excel workbook Q2769343 KB2769343 November 30, 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
• 2761247 "Unable to refresh data for a data connection in the workbook" error when you try to refresh an Excel 2013 workbook in PowerPivot Gallery in SharePoint Server 2010 Q2761247 KB2761247 November 23, 2012
• 2782523 You cannot open an IRM protected workbook in Protected View in Excel 2013 Q2782523 KB2782523 November 20, 2012
• 2758433 Power View sheet is not displayed in a workbook when you open the workbook in Excel 2013 Q2758433 KB2758433 November 16, 2012
• 2756731 You cannot create a PivotTable in Excel 2013 when field names in a source range contain similar characters Q2756731 KB2756731 November 6, 2012
• 2756728 PivotTable is not displayed after you open and repair a workbook in Excel 2013 Q2756728 KB2756728 November 6, 2012
• 2755143 Formulas do not reference the cells that you intended to reference after you sort a range in Excel 2013 Q2755143 KB2755143 November 6, 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
• 2769345 "We cannot locate a server to load the workbook Data Model" error on a SharePoint site when you refresh a PivotTable in an Excel 2013 workbook Q2769345 KB2769345 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
• 2761246 "3241607174" error code when you try to enable a scheduled data refresh on an Excel 2013 workbook that is stored in SharePoint Server 2010 Q2761246 KB2761246 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
• 2755126 "Unable to refresh data for a data connection in the workbook" error when you interact with an Excel 2013 workbook in a SharePoint Server 2010 farm Q2755126 KB2755126 October 23, 2012
• 2772563 Excel cannot change the paper size using Mac RDC Q2772563 KB2772563 October 17, 2012
• 2761182 No animation when you run VBA code to animate objects in Excel 2013 Q2761182 KB2761182 October 12, 2012
• 2755122 "You cannot use an Internet address here" error message when you click the Browser button in the data consolidation feature to search for a web location in Excel 2013 Q2755122 KB2755122 October 12, 2012
• 2768406 IAdviseSink::OnDataChange not called when copy/pasting Excel cells Q2768406 KB2768406 October 4, 2012
• 2511140 Excel add ins do not follow Office user interface language setting Q2511140 KB2511140 July 3, 2012