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

Problem: Whenever client wanted to open the attached Excel file from a discussion board. He gets the below error.  

Error message: This workbook is larger than the maximum workbook size allowed to be opened in the browser.

 

Reason: By default the Maximum workbook upload size allowed in SharePoint is 10mb (this was 100mb in 2007 environment) increase this to 50 MB the issue goes away.

How to do this:

1.   In Central Administration, in Application Management, click Manage service applications.

2.   Click Excel Services Application.

3.   Click Trusted File Locations.

4.   Click the location. This will be an added trusted file location for the site collection or a new file location.

5.   Scroll to Workbook Properties.

6.   In Maximum Workbook Size, increase the file size from 10 to 50

Reference Article: http://technet.microsoft.com/en-in/library/ff487972.aspx

Applies to: SharePoint Server 2010

                  SharePoint Foundation 2013.

The Business Card As A Career Tool: by Jim Adcock

After talking with a job seeker the other day, I asked for his card so I could keep in touch with him. He replied that his company didn't give its employees business cards. He didn't have a personal business card either.

I was asking for his card because I had spoken with him a couple of months before, and he took my card and said he would contact me so I could pass job leads to him. But I didn't hear from him, and I had no way to initiate contact with him, so he missed a couple of good leads.

I realized that not everyone has been taught the value of a business card - their own personal business card - to their career.

Read more of this post

Quick Fix: “The document could not be opened for editing. A Microsoft SharePoint Foundation Compatible application could not be found to edit the document” by Jim Adcock

Problem:
A user tries to open an InfoPath form in the application instead of the browser, and get an error message:

The user can open in the browser just fine, and has been able to open the forms previously with no problem. User is able to download the form to their desktop and open the form in InfoPath. But when they try to open the form in the application from the context menu, the above error is shown.

In researching the error, I found a support posting that provided a clue to the problem. In it, the user is instructed to enable Add Ons in their Internet Explorer:

1. Go to Tools in IE, click Internet Options
2. Click Programs at the top
3. Click “Manage add-ons” near the bottom
4. Click Publisher, then you can see all of Microsoft Corporation together
5. Scroll to SharePoint names (May be one or several)
6. Make sure they are all enabled by clicking on the name; the Enable button is towards the bottom.
7. Then click OK and OK and restart IE

Can you guess what the problem was?
Read more of this post

Error in creating a SharePoint Wiki site in SharePoint 2010

Problem Description: Error in creating a SharePoint Wiki site in SharePoint 2010

Creating a subsite underneath site collection by using ‘enterprisewiki’ throws an exceptions.

Please refer the following exceptions which is a series of error messages and helpful to understand the cause behind it.

Error Messages:

Error#1: Failed to activate site-scoped features for template 'ENTERWIKI#0' in site ‘http://sharepoint2007/sites/SP2010Projects’.    a41b91e6-385b-42a9-a10f-c69e15de613a

Error#2: Failed to activate web features when provisioning site at url " http://sharepoint2007/sites/SP2010Projects" with site definition "ENTERWIKI#0"

               

Error#3: Failed to apply template "ENTERWIKI#0" to web at URL " http://sharepoint2007/sites/SP2010Projects".  a41b91e6-385b-42a9-a10f-c69e15de613a

Error#4: SPContentTypeBindingElement.ElementActivated(). ContentType '0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF39004C1F8B46085B4D22B1CDC3DE08CFFB9C' not found on web ' http://sharepoint2007/sites/SP2010Projects'.              a41b91e6-385b-42a9-a10f-c69e15de613a

Error#5: specified argument was out of the range of valid values. Parameter name:content type not found(‘0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF39004C1F8B46085B4D22B1CDC3DE08CFFB9C’).

Analysis:

Wiki template is a dependency section of Publishing Infrastructure as per the following articles:

http://technet.microsoft.com/en-us/library/ee721051.aspx  

http://technet.microsoft.com/en-us/library/ee837434.aspx

Resolution:

Activate publishing infrastructure at the site collection level as well as at the site level.

How to do this:

Activate Publishing Infrastructure @site collection level:   

-Open the site

-site actions

-Site settings

-site collection Administration

-activate “SharePoint Server Publishing Infrastructure”

Activate Publishing Infrastructure @site level:   

-Open the site

-site actions

-Site settings

-site actions

-manage site features

-activate “SharePoint Server Publishing Infrastructure”

That’s it; your issue will be resolved.

If you have any queries 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.

Product Applies To:

SharePoint Server 2010

SharePoint Foundation 2010

SharePoint workflow solutions – Surface Tablet door prize

Able Solutions next event — Automate Business Processes using SharePoint and Nintex — is just 2 weeks away! If you haven't already registered, I would encourage you to do so now.

We will be hosting lunch at the Microsoft Office in Alpharetta on April 30 to take a deep dive into the things you really want to know about using Nintex to enhance your SharePoint deployment. You'll hear from our top consultants and a key customer or two. One attendee will go home with a free Windows Surface!

Click this link to register today: https://clicktoattend.microsoft.com/en-us/Pages/EventDetails.aspx?EventID=168956

 

Creating customized search results in SharePoint 2013

With the launch of SharePoint 2013 came some exciting new features and improvements in the realm of Web Content Management (WCM). Content authoring improvements like Image Renditions and the ability to drag and drop navigation items directly onto a page create a better experience for content authors, while branding advancements like the new Design Manager and Device Channels further empower web designers. Throw in Managed Navigation, Cross-site Publishing, Catalog-enabled lists and libraries, Category pages, clean URLs and the ability to capture a video thumbnail straight from the video and it is clear that WCM has received quite the facelift courtesy of SharePoint 2013.

Read the full tip here...

Extending your Enterprise Workflows and Forms with Services Offered in the Cloud

Today’s modern company is comprised of multiple offices, telecommuters, business travelers and clients on various continents in different time zones.  In this global economy, business applications are required to meet the needs of each employee and customer whether they are in Atlanta or Hong Kong.  No one wants to be sitting in an important meeting not being able to access and interact with the data and processes they need.  For this month’s Tip of the Month, we’re examining the benefits of utilizing the powerful cloud features of Nintex Live with Nintex Workflow and Nintex Forms.

Read the full tip here...