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

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.

October 2013 Cumulative Update

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.

Free Training & Resources from Microsoft

Windows Server 2012 Evaluation Download

System Center 2012 Suite Evaluation Download

Hyper-V Server 2012 Evaluation Download

Windows Server 2012 Training at MVA

System Center 2012 Training at MVA

Licensing Training at MVA

Private Cloud Guided Labs

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

SharePoint 2007: Error 'The Compressed (zipped) Folder is invalid or corrupted'

Issue: Whenever my client tried to open a .zip files from SharePoint it throws the below error message.

Background: One of my clients had zipped the .excel files in on his local desktop and uploaded to SharePoint site. There files contains the project level information and was needed to extract after two years. When he clicked the file to open from SharePoint had encountered the issue.

Now the task begins of a SharePoint admin.

Troubleshooting:

Tried to open the file from SharePoint site, no go.

Downloaded the file on desktop of the client, no go.

Tried the same steps at my end, no success.

Strange this accessing file on SharePoint server also does give the same error.

With the above basic stuff, it was clear that it is something to deal with the zip file itself as it doesn’t seems to be SharePoint issue anymore.

Being a digger try to dig some more in it and seems like something to deal with the excel documents zipped may be was in protected mode.

Client was having no clue for this.

Resolution: Tried to find the Repair tool on the internet and million thanks to Christina Marley who created a zip file repair utility which when ran has repaired the file and is available for download here. Christina MarleyChristina Marley

http://gallery.technet.microsoft.com/The-Compressed-Zipped-d39407b2

Asked the user to download the files and repair them with the utility.

However, you can also find some other relevant repairing tools which may provide the evaluation version or you may need to buy the licence version of the tool.

http://www.diskdatarecovery.net/repair-zip/

If you feel any difficulty in understanding the tool or have any query I would be happier to help you.

 

TechNet Wiki Link

Applied to: SharePoint 2007, WinZip, and WinRAR. Windows XP.

 

 

Virus Found Opening an Infopath form from SharePoint 2007 Site.

Error message: /sites/Sharepoint].xml" contains the following virus: "Reason:= ".

If you want to open this file, you'll need to clean the file using your own virus scanning software. Do you want to save the file to your computer and attempt to clean it.

Background: A user reported that he tried to open an InfoPath form from a SharePoint site and got the error message mentioned above. There is no error occurring when opening any other file. If he clicks yes, and saves the file on the local desktop, he gets the exception error:
“Exception from HRESULT: 0x80041050”

 Troubleshooting:

Tried opening the file on the same site, get error message.
Tried to download the file, get the exception error message.
Tried opening the other file on the same site and it is opening fine.
The only issue was with the one file.

Resolution:

Based on the TechNet article http://technet.microsoft.com/en-us/library/dd795107(v=office.12).aspx
To determine whether or not the file is actually infected, you will need to look at the error message for the specific error code 0x80041050. This means that the item is virus-infected. If the item is virus-infected, either delete the infected item, or attempt to clean it using your virus scan application. If the item is not virus-infected, restart the content deployment job.

You can also try to look if there is Virus infected file in the SQL Content DB by running the following query:

Create a new query and run:Select *
from AllDocs
where (VirusStatus > 0) and (VirusStatus is not null)
If you get any results this is your issue!  (Given that you don't actually have some virus in that file.)
Run the next query: Update AllDocs
set VirusStatus = null
where (VirusStatus > 0) and (VirusStatus is not null)

Applies to: WSS 3.0, SharePoint 2007. 

Failed to download Excel Services chart

Playing with excel is day to day task! Excel services and its errors are full of excitement :)

Today we got one ticket that user is facing some problem while displaying excel document by means of excel web access webpart. Further probing, we came to know that he is trying to display some chart by means EWA and getting the error as mentioned below:

Failed to download Excel Services chart

 

 

There is no need to troubleshoot this error we have a predefined setting in the central administration so easy resolution!

Let me describe step by step so that there would be no confusion.

Resolution:

Open the Central Administration
Manage service applications
Excel service application
Click on it
Manage trusted file location settings
Click on the trusted location of that web application
In the Workbook Properties section, there is a "Maximum Chart Size" setting that is "1" (meaning the maximum chart size is 1MB) by default.
Increase that and then click OK.

That’s it, you are done! Check the site on which you were facing the problem and that should be resolved now.

In case of 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.

Product applies to:

SharePoint Server 2010
SharePoint Foundation 2010
SharePoint Server 2013
SharePoint Foundation 2013

Event ID: 5586 Generated in the SharePoint server: SharePoint 2007

Issue: Event ID: 5586 Generated in the SharePoint server.

Error: Event ID 5586 generated in SharePoint server application event logs.
 
Event Type:      Error
Event Source:  Windows SharePoint Services 3
Event Category:            Database
Event ID:          5586
Date:                09/10/2013
Time:               10:24:22
User:                N/A
Computer:        ++++++++++++
Description:
Unknown SQL Exception 1035 occurred. Additional error information from SQL Server is included below.

Background: As a part of daily health check on the server, I have noticed allot many occurrences of the event ID 5586 on multiple servers.

This is something occurs on regular intervals but not specific to on e server.

By looking some of the reference on the internet I happened to find the TechNet Article which talk about the possible resolution of this error.

Resolution:
This error occurs in both the versions of the SharePoint i.e. 2007 and 2010; however in my case it was reported for the SharePoint 2007.

Remedies for SharePoint 2007: http://technet.microsoft.com/en-us/library/cc561042(v=office.12).aspx  
 
Remedies for SharePoint Server 2007: http://technet.microsoft.com/en-us/library/ee513056(v=office.14).aspx  
 
Great thanks to MS to keep the record of the most relevant event IDs and sharing the possible remedies
If you feel any difficulty in following any of resolution listed in the articles, do let me know. I would be more happy to help you put with. Products Applies to: SharePoint 2007, SharePoint Server 2010, Windows Sever 2003, Windows Server 2008, SQL Server 2005 and SQL Server 2008.