Excel 2010 articles, fixes and updates - Year 2011

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 2011

2556041 Description of the Office updates: June 14, 2011 Q2556041 KB2556041 June 16, 2011

2555016 Excel 2010 may crash when using HP Printers Q2555016 KB2555016 June 13, 2011

2519799 When exporting an Excel spreadsheet as a PDF file, the page dimensions may change Q2519799 KB2519799 May 26, 2011

922850 You receive an error message when you try to open or to save a file type that was blocked by your registry policy settings in one of the Office 2010 programs, in one of the 2007 Office programs or in one of the Office 2003 programs Q922850 KB922850 May 23, 2011

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 May 23, 2011

925757 How to disable hyperlink warning messages in 2007 Office programs and in Office 2010 programs Q925757 KB925757 May 20, 2011

2521018 Office Excel 2010 crashes when you programmatically print or print-preview a file Q2521018 KB2521018 May 19, 2011

2501584 Microsoft Security Advisory: Microsoft Office File Validation for Office 2003, 2007 Office, and Office 2010: April 12, 2011 Q2501584 KB2501584 May 19, 2011

2513337 An embedded image is resized when you paste it into an Excel 2010 workbook Q2513337 KB2513337 May 13, 2011

983047 An Office 2010 document opens in Protected View even though you enable the "Open Office documents as read/write while browsing" policy setting Q983047 KB983047 May 12, 2011

2545346 Description of the Office updates: May 10, 2011 Q2545346 KB2545346 May 10, 2011

2547338 Hyperlink to MHT File in Office Documents Fails to Load in Internet Explorer Q2547338 KB2547338 May 6, 2011

2528533 Office 2010 Cumulative Update for April 2011 Q2528533 KB2528533 April 28, 2011

2516490 Description of the Excel 2010 hotfix package (Excel-x-none.msp): April 26, 2011 Q2516490 KB2516490 April 28, 2011

2516486 Description of the Excel 2010 hotfix package (excel-x-none.msp, graph-x-none.msp): April 26, 2011 Q2516486 KB2516486 April 28, 2011

2516481 Description of the Excel 2010 hotfix package (excel-x-none.msp, graph-x-none.msp, oart-x-none.msp, oartconv-x-none.msp): April 26, 2011 Q2516481 KB2516481 April 28, 2011

2516480 Description of the Excel 2010 hotfix package (excel-x-none.msp): April 26, 2011 Q2516480 KB2516480 April 28, 2011

2513216 Microsoft Query lists user objects and system views in the query wizard Q2513216 KB2513216 April 28, 2011

2121306 A summary of the support information for Office 2010 programs that run on 32-bit and 64-bit versions of Windows operating systems Q2121306 KB2121306 April 26, 2011

2464297 A Microsoft Excel, Word or PowerPoint 2010 file does not open because of incorrect file associations Q2464297 KB2464297 April 22, 2011

2535422 Description of the Office updates: April 12, 2011 Q2535422 KB2535422 April 12, 2011

2489279 MS11-021: Vulnerabilities in Microsoft Excel could allow remote code execution: April 12, 2011 Q2489279 KB2489279 April 12, 2011

2475876 Description of the Excel 2010 hotfix package (excel-x-none.msp): February 22, 2011 Q2475876 KB2475876 April 12, 2011

2466146 MS11-021: Description of the security update for Excel 2010: April 12, 2011 Q2466146 KB2466146 April 12, 2011

2534497 Description of the guidelines for selecting the appropriate picture format in an Office program Q2534497 KB2534497 April 10, 2011

2534458 How to obtain the latest service pack for the 2007 Office suite Q2534458 KB2534458 April 10, 2011

2535767 OLAP Server Formatting results in DISCOVER command against all cubes Q2535767 KB2535767 April 8, 2011

2519419 How to obtain a new product key for a Microsoft Office suite Q2519419 KB2519419 April 7, 2011

983031 The DSUM and DCOUNT functions in Excel 2010 do not work with pivot tables Q983031 KB983031 April 6, 2011

983034 ATP function names are not automatically translated in Excel 2010 Q983034 KB983034 April 5, 2011

2458237 Error message when you try to open an Excel 2010 file on a 32-bit computer: "Excel cannot complete this task with available resources. Choose less data or close other applications." Q2458237 KB2458237 April 1, 2011

2520049 Description of the Excel 2010 hotfix package (Excel-x-none.msp): March 13, 2011 Q2520049 KB2520049 March 30, 2011

2062934 Error inserting SmartArt: "The following file or files contain errors which prevent them from working."Q2062934 KB2062934 March 30, 2011

2528682 You cannot open .xls files with Microsoft Office Excel 2010 Q2528682 KB2528682 March 25, 2011

2475796 [SDP 3][2b9f8e72-b947-496e-b197-762a74fcaaf2] Excel Baseline AppLog, RegKeys, CheckSym Q2475796 KB2475796 March 22, 2011

2345338 Description of the Excel 2010 hotfix package (excelc-x-none.msp, excel-x-none.msp): August 31, 2010 Q2345338 KB2345338 March 22, 2011

926430 You are requested to "search Microsoft Office Online for "VBA Converters" when you try to open or save a workbook in Excel 2007 or Excel 2010 Q926430 KB926430 March 22, 2011

2503335 An ActiveX control does not reappear as expected in an Excel 2010 workbook when you unhide the columns that include the control Q2503335 KB2503335 March 21, 2011

2470235 You cannot save an auto-saved document without saving the auto-revision information when the AutoRecover feature is enabled in Excel 2010 Q2470235 KB2470235 March 21, 2011

2204028 Description of the Excel 2010 hotfix package (Excel-x-none.msp): June 29, 2010 Q2204028 KB2204028 March 9, 2011

2493730 Office 2010 Cumulative Update for February 2011 Q2493730 KB2493730 February 28, 2011

2500863 Description of the Excel 2010 hotfix package (excel-x-none.msp): February 22, 2011 Q2500863 KB2500863 February 24, 2011

983462 Prescriptive guidance for sequencing Office 2010 in Microsoft App-V Q983462 KB983462 February 24, 2011

2475875 Description of the Excel 2010 hotfix package (excel-x-none.msp, graph-x-none.msp): February 22, 2011Q2475875 KB2475875 February 23, 2011

2273257 Office Application Custom Code Solutions Q2273257 KB2273257 February 21, 2011

2496739 A Microsoft Office application will crash if you run the Close or Quit method from the PowerPoint object model Q2496739 KB2496739 February 14, 2011

2479871 Security settings for graphic filters for Microsoft Office 2010, the 2007 Microsoft Office system, Microsoft Office 2003, and Microsoft Office XP Q2479871 KB2479871 January 20, 2011

2276904 Office Deployment Q2276904 KB2276904 January 12, 2011

2487346 Error: "The provided Secure Store target application is either incorrectly configured or does not exist" when saving a PowerPivot refresh schedule job Q2487346 KB2487346 January 10, 2011

2479673 Office 2010 Cumulative Update for December 2010 Q2479673 KB2479673 January 6, 2011

You are attempting to open a file that is blocked by your registry policy setting.

Number of error messages that will be fixed when you will apply the resolution:

You are attempting to open a file that is blocked by your registry policy setting.

You are attempting to open a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

You are attempting to open a file that was created in an earlier version of Microsoft Office. This file type is blocked from opening in this version by your registry policy setting.

You are attempting to save a file that is blocked by your registry policy setting.

You are attempting to save a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

Your error message will be anyone which are mentioned above. but don't worry Microsoft has already published a KB for this and your issue will be resolved when you will apply the mentioned resolution.

Resolution:

To resolve this issue, click the following article number under the name of the Office program that you are using to view the article in the Microsoft Knowledge Base: 

Word 2010, Word 2007, or Word 2003

I receive an error message when I try to open or save a file in Word

Excel 2010, Excel 2007, or Excel 2003

I receive an error message when I try to open or save a file in Excel

PowerPoint 2010, PowerPoint 2007, or PowerPoint 2003

I receive an error message when I try to open or save a file in PowerPoint


If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you

The provided Secure Store target application is either incorrectly configured or does not exist

Yesterday, i was configuring Schedule PowerPivot Data Refresh as per this microsoft article: 

http://msdn.microsoft.com/en-us/library/ee210651.aspx 

What i did exactly ?

-Open a SharePoint 2010 site

-Uploads Powerpivot

-selects schedule a data refresh for the workbook

-at step 7, i have selected third option i.e. The user enters a known existing Secure Store Target application ID in the Credentials section inside the "Connect using the credentials saved in Secure Store Service" field.

-Clicks OK to save the schedule and got the following error message:

"The provided Secure Store target application is either incorrectly configured or does not exist"

I have successfully resolved this issue by following the below mentioned steps:

Note: I am still debugging this issue to find out the root cause. Will share the details asap.

Resolution Steps:

1.       In Central Administration browse to Application Management 

2.       Click Manage Service Applications

3.       Click to the right of the Secure Store Application link so the row appears highlighted. The objective is to activate the Administrators button in the menu ribbon.  

4.       Click on the Administrators button and add the user (or an appropriate security group including user) to the field.  

5.       Click Add, and then check the "Manage target applications" check box.

If you have any queries/questions then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you

When opening an excel file I get the following error "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

If you are working on Office Web apps in SharePoint 2010 then you may come across this error…

“This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

To create an Excel Services Application trusted location, contact your system administrator.”

its very simple to resolve this error and start working on excel again :-)

there are 2 methods to resolve this issue:

Option 1: Configure to open in Client Application

At the site collection level activate the "Open Documents in Client Applications by default Feature"

Option2: At the Document Library set the "Opening Documents in the Browser" setting to "Open in client application"

OR

1. open central admin 
2. go to Manage service applications
3. Click on Excel services Application.
4. Then click on “Trusted file locations”
5. You can see that http:// is already there, so you could just add https:// or put in a url to a specific location
6. Fill in the boxes, I also ticked the trust children box.
7. Once you have done this go back to your Excel document and it will open up in the browser. 

If you have any queries/questions regarding the above mentioned information then please let me know, thank you

System error 5 has occurred. Access is denied.

This issue occurs if you use a connection method that uses Windows shell components or Explorer View. For example, you may experience one or more of the following symptoms:

1-if you try to map a drive to a document library by using the net use command, you are prompted to type your user name and password. After you type your user name and password, you receive the following error message:

System error 5 has occurred.
Access is denied.

2-If you try to view a document library by using Explorer View, you are prompted several times to type your user name and password. If you click Cancel, Explorer View displays Web folders. 

To have us enable Basic authentication on the client computer for you, go to the "Fix it for me" section. If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.

Fix it for me

To fix this problem automatically, click the Fix it button or link. In the File Download dialog box, click Run, and then follow the steps in the Fix it Wizard.

Fix this problem
Microsoft Fix it 50623