31 October, 2013

This workbook is larger than the maximum workbook size allowed to be opened in the browser

Today we faced one more new issue and it was quite easy to understand and predict what will be the resolution! But today’s article is especially for those who are business managers/IT analyst/vice presidents/governance etc. - who does have access to the servers.

To display a workbook in an Excel Web Access Web Part, you must add the Web Part to a page and then connect the workbook to the Web Part by entering the workbook URL or UNC in the Excel Web Access tool pane. As a final step, you can customize the Web Part by selecting properties in the Excel Web Access tool pane for the Web Part.

User reported an issue that he is trying an excel file in the excel web access webpart (EWA) and getting the following error message-
This workbook is larger than the maximum workbook size allowed to be opened in the browser.
 
Here is the step by step resolution:
1)     Open the central administration
2)     Application management
3)     Manage service applications
4)     Excel service application
5)     Click on Trusted File locations
6)     Select the document library link where your excel files are stored
7)     Go to the section termed as “Workbook Properties”
8)     Maximum workbook size
9)     By default its set to 10MB
10) Set it as per your requirement – like 50MB/100MB
11) Click OK


Go back to your site now where you were facing the problem -> refresh the page and check the results!

It should be resolved now. Thank you.

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.

28 October, 2013

October 2013 Cumulative Update

October 2013 Cumulative Update Packages for SharePoint Foundation 2013 and SharePoint Server 2013 have been released

October 2013 CU for SharePoint Foundation 2013 - KB 2825674 http://support.microsoft.com/kb/2825674

October 2013 CU for SharePoint Server 2013 - KB 2825647 http://support.microsoft.com/kb/2825647

Note: This is build 15.0.4551.1001 of the cumulative update package.

SharePoint Server 2010 Training for Beginners

Setting Up the Development Environment for SharePoint 2010 on Windows Vista, Windows 7, and Windows Server 2008
These instructions enable you to get started with an environment that is specifically suited to developing SharePoint custom solutions.
http://msdn.microsoft.com/en-us/library/ee554869.aspx

Introduction of SharePoint Server 2010 site templates
Videos provide in the following link is a quick preview of the templates, you can go through them quickly and decide which template is best for you. 
http://office.microsoft.com/en-us/sharepoint-server-help/a-preview-of-the-sharepoint-server-2010-site-templates-HA101907564.aspx

Getting started with SharePoint Server 2010
http://office2010.microsoft.com/en-us/sharepoint-server-help/getting-started-with-sharepoint-server-2010-HA010371435.aspx

What is SharePoint : Capabilities & Benefits
http://sharepoint.microsoft.com/en-us/Pages/default.aspx

SharePoint 2010 for End Users
http://sharepoint.microsoft.com/en-us/product/benefits/End-User/Pages/default.aspx

Learn SharePoint Server 2010 - IT Pros
http://technet.microsoft.com/en-us/sharepoint/ee410529

SharePoint 2010 Developer Training Course
http://msdn.microsoft.com/en-us/gg620703

SharePoint 2010 Resources for Developers
http://sharepoint.microsoft.com/en-us/resources/Pages/Developer-Training-Guide.aspx

SharePoint 2010 Developer Resource Centers
http://msdn.microsoft.com/en-us/sharepoint/bb964529.aspx

Developer Best Practices Resource Center | SharePoint 2010
http://msdn.microsoft.com/en-us/sharepoint/ff660756.aspx

SharePoint Developer Center: Download -Code & Templates
http://msdn.microsoft.com/en-us/sharepoint/default
 

http://www.techsolutions.net/SharePointSolutions.aspx

Advance - SharePoint Training Course
SharePoint 2010 and Windows Phone 7 Training Course
http://msdn.microsoft.com/en-us/SharePointAndWindowsPhone7TrainingCourse

SharePoint and Silverlight Training Course
http://msdn.microsoft.com/en-us/SharePointAndSilverlightTrainingCourse

SharePoint 2010 and Windows Azure Training Course
http://msdn.microsoft.com/en-us/SPAzureTrainingCourse