21 August, 2013

To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser + SP2010


One of my user has opened a ticket by mentioning that he is facing some problems while opening excel files. Further probing stated that he has office 2010 already installed on the machine but still he is facing the problem.

Note: let me tell you that you might face the same problem with Office 2013 also.

User’s machine configuration:
Operating system: Windows 7 -32bit Version.
Office 2010 -32bit version.
IE 9 (internet explorer)-32 bit.

Error Message:
To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser.

Very important note: before starting any troubleshooting on this, make sure that your IE version should not be 64-bit.

Why?- Internet Explorer x64 is currently not an optimal approach since many Microsoft- and thirst-party ActiveX objects still do not support 64 bits. Office 2007/2010 does not ship 64-Bit controls for SharePoint integration, such as single document upload or multiple document upload, or "Connect to Outlook", "Open in Explorer View" and many more. Considering these limitations you may want to use the 32 bit version of Internet Explorer for the future to take benefit of the SharePoint integration features.

The required component / add-ons are simply missing for IE x64 and therefore causing several features not to function, being greyed-out or generate an [error] message once requested, such as "Message from webpage: The document could not be opened for editing"

Resolution:
Repair is a great Office tool that I have used in many previous versions of Office to fix things like the Normal.dot template being changed in Word, Outlook PST and email problems, etc. If Office 2013 is running slow or having some other issue, try performing a repair and hopefully it will fix your problem. Enjoy!

Here I will share the repair process for 3 different office versions i.e. Office 2010, Office 2013 and Office 2007.

If you are using Office 2010 then please try to repair by following steps:

1.   Click on Start and then Control Panel.
2.   After the Control Panel window opens, click on Uninstall a Program.
3.   A list of all installed programs should now appear. Highlight Microsoft Office 2010, and click on Change.
4.   After the dialog box loads, choose the Repair option and click Continue.
5.   This process may take a few minutes, but after completion, you will be prompted to exit and restart any open Office programs. You may then click Close.
6.   You may be prompted to reboot your computer to apply all changes and complete setup.

If you are using Office 2013 then please try to repair by following steps:
1.   To repair Office 2013, you first have to open the Control Panel and then click on Programs and Features.
2.   Click on Office 2013 and then click on the Change button.
3.   Next, click on the Repair radio button and click Next. This will start the repair process.
4.   It’ll take some time to repair and once it has finished, you’ll see a message saying the configuration of Office 2013 is complete.
5.   You’ll then have to restart the computer in order for the repair to complete.

If you are using Office 2007 then please try to repair by following steps:

1.   To begin, go to the Start Menu > All Programs > Microsoft Office > Microsoft Office Tools, and then click on Microsoft Office Diagnostics.
2.   After Microsoft Office Diagnostics opens, click Continue on the first page.
3.   By default, all of the diagnostic tests are enabled, so you may click on Run Diagnostics to proceed with diagnosis and repair.
4.   After running the diagnostics, a results page will be displayed.
5.   After clicking continue, your web browser will load with Microsoft's recommendations for the next steps to resolve any discovered issues with Microsoft Office.

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.

Request: If you have any other resolution then please share so that it would be useful for the entire community. Thanks again!

June 2013 CU + April 2013 CU + March Public Update for SharePoint 2013

June 2013 CU for SharePoint 2013
The KB articles for June CU will be available at the following locations in a couple of days:
  • KB 2817346 - SharePoint Foundation 2013 June 2013 CU
  • KB 2817414 - SharePoint Server 2013 June 2013 CU
  • KB 2817415 - SharePoint Server 2013 with Project Server June 2013 CU
  • KB 2817350 - Office Web Apps Server 2013 June 2013 CU
The Full Server Packages for June 2013 CU are available through the following links:
April 2013 CU for SharePoint 2013
March Public Update for SharePoint 2013
Install future cumulative updates for SharePoint 2013 it will be mandatory to first install the March public update.
  • KB 2768000 - SharePoint Foundation 2013
  • KB 2767999 - SharePoint Server 2013
  • KB 2768001 - Project Server 2013
The Full Server Packages for March 2013 PU are available through the following links:
After installing the fixes you need to run the SharePoint 2013 Products Configuration Wizard on each machine in the farm.

August 2013 CU for SharePoint 2013

The product group released the August 2013 Cumulative Update for the SharePoint 2013 product family.

The KB articles for August CU will be available at the following locations in a couple of days:
  • KB 2817517 - SharePoint Foundation 2013 August 2013 CU
  • KB 2817616 - SharePoint Server 2013 August 2013 CU
  • KB 2817615 - SharePoint Server 2013 with Project Server August 2013 CU
  • KB 2817521 - Office Web Apps Server 2013 August 2013 CU
The Full Server Packages for August 2013 CU are available through the following links:
After installing the fixes you need to run the SharePoint 2013 Products Configuration Wizard on each machine in the farm.


20 August, 2013

SharePoint 2013 interview questions and answers

What's new in SharePoint 2013 compared to SharePoint 2010?

What is Shredded Storage?

Difference between SharePoint 2013 and SharePoint 2013 preview?

What are Apps in SharePoint 2013?

How to deploy .wsp Solutions from SharePoint 2010 in SharePoint 2013?

Is it possible to create sandboxed solution in SharePoint 2013?

What are the hardware and software requirements for SharePoint 2013?

What are the new workflows introduced in SharePoint 2013?

Can I reuse a SharePoint 2010 workflow in SharePoint 2013 Site?

What are the new web parts introduced in SharePoint 2013?

What is the Content Search Web Part?

What’s are the new Delegate Controls in SharePoint 2013?

What are the new improvements in Visual Studio 2012 for SharePoint 2013?

How SharePoint 2013 authentication works?

What are improvements in Social features in SharePoint 2013?


How to migrate from SharePoint 2010 to SharePoint 2013?

19 August, 2013

august cumulative update SharePoint 2010

The product group released the August 2013 Cumulative Update for SharePoint 2013 product family.

The KB articles for August CU will be available at the following locations in a couple of days:

KB 2817517 - SharePoint Foundation 2013 August 2013 CU
KB 2817616 - SharePoint Server 2013 August 2013 CU
KB 2817615 - SharePoint Server 2013 with Project Server August 2013 CU
KB 2817521 - Office Web Apps Server 2013 August 2013 CU

The Full Server Packages for August 2013 CU are available through the following links:


After installing the fixes you need to run the SharePoint 2013 Products Configuration Wizard on each machine in the farm.