Unable to Load Workbook + The workbook that you selected cannot be opened + The workbook may be in an unsupported file format, or it may be corrupt

Excel services work with Excel 2007 and allows you to share, load, calculate Excel workbooks on Microsoft SharePoint Server 2007 portals and dashboards. You can share an entire Workbook or just few parts of it like charts, tables etc. By using a Web browser, end users can view and interact with the workbooks.

However, at times, when you publish a workbook to Excel Services and try to load it in a browser, you might run into an error message

Unable to Load Workbook

The workbook that you selected cannot be opened.

The workbook may be in an unsupported file format, or it may be corrupt.

Would you like to try and open this file in Excel?

How I resolved this issue:

1)   Remove the space character that is in front of the caret operator in the formula.

2)   Save the workbook in the non-XML binary workbook format (.xlsb). Then, publish the workbook to the server

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 u.

For more information about Excel Services, visit the following Microsoft Web sites:

1)   http://msdn2.microsoft.com/en-us/library/ms546696.aspx  

2)   http://office.microsoft.com/en-us/sharepointserver/HA101054761033.aspx

You do not have permissions to open this file on Excel Services

If you are troubled with the above errors in SharePoint while publishing and viewing the excel services forms in browser then I believe you are in the right place. I am not sure if my guidelines will solve your problem but at least it solved my issues.

Resolution:

1. In SharePoint Central Administration, go to 'Manage this farm's shared services'

2. Select your shared service. (Default is SharedServices1)

3. In 'Excel Services Settings' select Edit Excel Services settings.

4. Ensure that File Access method is Process Account. Click OK.

5. Back in 'Excel Services Settings' select 'Trusted File Locations'

6. Add a new Trusted file Location:

 > URL: Specify the report library or the entire portal

 > Location Type: Windows SharePoint Services

 > Children: Trusted

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 u

Office documents prompting for credentials

Multiple users are suddenly facing problems while accessing sharepoint site.

SYMPTOMS:

Users are prompted for credentials when accessing Office documents via ISA. 

Customer is using Forms-Based Authentication [FBA] to authenticate external users.

ERROR MESSAGE:

None

ENVIRONMENT:

Office SharePoint Server 2007

CAUSE:

ISA defaults to a settings "Never use persistent cookies"

Resolution:

On the SharePoint site - 

On the properties of the SharePoint publishing rule on ISA, 

go to the following location - Listener - Forms - Advanced Form Options - Cookie Settings - Use 

Persistent Cookies - set this to “On All Computers” (the default setting is “Never use persistent cookies”)

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.

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