Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: Excel 2010

Article ID Article Title Hidden
81518 Using a custom number format to display leading zeros
162059 How to configure Internet Explorer to open Office documents in the appropriate Office program instead of in Internet Explorer
170787 Description of limitations of custom functions in Excel
202261 You cannot use a pound character in a file name for a hyperlink in an Office program
207574 Files do not open in Excel or "File Not Found" occurs when open by double-click
210684 Copying worksheet programmatically causes run-time error 1004 in Excel
211470 Calculated field returns incorrect grand total in Excel
211967 Chart trendline formula is inaccurate in Excel
213181 Run-time error using FormulaArray property
213477 VBA macro to concatenate columns of data in Excel
213630 How to use the IF THEN ELSE statement and the SELECT CASE statement in examples written in Visual Basic for Excel
213750 How to use a macro to add labels to data points in an xy scatter chart or in a bubble chart in Excel
213826 XL2000: Visual Basic Macro to List Circular References
213983 Error message when you open or save a file in Microsoft Excel: "Filename is not valid"
214073 You receive an error message when you try to save a file in Excel
214286 XL: Some Worksheet Functions Do Not Allow Array Constants
214383 Only the first worksheet is printed duplex in Excel
257757 Considerations for server-side Automation of Office
269370 Last digits are changed to zeroes when you type long numbers in cells of Excel
274500 "Save changes in <filename>" prompt even if no changes are made
274537 When to use SUM(IF()) instead of COUNTBLANK() in Excel
275165 When to use a SUM(IF()) array formula
282830 Programmatic access to Office VBA project is denied
282847 Some Excel features are unavailable if you disable Visual Basic for Applications and run Excel
291110 Cannot use keyboard shortcuts to select ranges in RefEdit control in Excel
291323 Sample macro code to change the case of text in Excel
295971 Not all items are displayed in the AutoFilter/PivotTable list
299490 Data validation list entries all on one line in Excel
299958 Errors that the RegClean utility finds after you install Microsoft Office
305568 Error message: To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet
312188 Multiple workbooks with links to the same source update each other
320473 Excel data does not retain its formatting in mail merge operations in Word
325573 You receive error messages when you try to open an Office document
327006 External links may update when you open a file that was last saved in a previous version of Excel
328440 Description of link management and storage in Excel
814068 Description of the way that Excel saves files
825012 How formula calculations are performed in Excel
826917 Nothing happens when you try to use the "Export to Microsoft Excel" command in Internet Explorer
829766 Mailbox and other printer-specific settings are saved with an Excel file
838006 Controls on an Excel 2003 or Excel 2010 worksheet change size after you change the screen resolution
873209 How to install the Excel 2002 Report Manager add-in and Template Wizard add-in in Excel 2003 and in Excel 2007
915971 Excel workbook is not held or stored on the printer when the whole workbook is printed to the private or secure area of the printer
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
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
924074 How to open new file formats in earlier versions of Microsoft Office
926430 You are requested to search Microsoft Office Online for "VBA Converters" when you try to open or save a workbook in Excel
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
948355 The modified date of the original.xls file is not reset to the original modified time stamp when you save an .xls file in Excel 2007 & Excel 2010
967950 Error message "Do you want to download the converter?" when you try to open a file in Excel, Word or PowerPoint
968095 MS10-105: Vulnerability in Microsoft Office Graphics Filters could allow remote code execution