Wow, that's a big workbook. Unfortunately, we can't open a workbook larger than 10 MB. You'll need to open this in Excel.

Problem description:

One user has reported an issue where he was getting an error while accessing the excel files from SharePoint site.

Before contacting the user, I tried uploading one dummy excel file to check the behavior and it works fine so I thought it might user who is doing some mistake. Further probing on the issue, I got the following details.

Entities:

1.   SharePoint 2013

2.   Excel 2013 / Office 2013

3.   Internet explorer 8.0

How to reproduce this error?

a)   Upload your excel document in the document library

b)   Try to open this document by directly clicking on it or excel dropdown ->view in browser.

c)   You will get the following error:

Error Message#1:

Wow, that's a big workbook. Unfortunately, we can't open a workbook larger than 10 MB. You'll need to open this in Excel.

Error message#2:

Couldn't Open the Workbook. Wow, that’s a big workbook. Unfortunately, we can't open a workbook larger than 10MB. You'll need to open this in Excel.

Error message#3:

The form submission cannot be processed because it exceeded the maximum length allowed by the web administrator. Please resubmit the form with less data.

Resolution:

a)   Central administration

b)   Application management

c)   Service applications

d)   Manage service applications

e)   Excel Services Application

f)    Trusted File locations

g)   Select the document library where your web part is failing

h)   Refer the section named as “workbook properties”

i)     Change the maximum workbook size

j)    By default its 10MB

k)   Change it to 50MB / 100MB as per your requirement

l)     Click OK.

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.

Note:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product applies to:

1.   SharePoint 2013

2.   SharePoint Foundation 2013

3.   SharePoint 2010

4.   SharePoint Foundation 2010

We're sorry. We ran into a problem completing your request. Please try that again in a few minutes.

This article is based on usage of Performance Point services with SharePoint 2013. Basically I am trying to generate an excel report with the help of performance point service.

Entities:

1.   SharePoint 2013

2.   Performancepoint Services

3.   Excel Services

How to reproduce the issue / error?

Here are the details:-

1.   Open the dashboard designer

2.   If you have already created the data connection then it’s good, if not then right click on the data connection and create a new.

3.   Once that done then you will get that external data i.e. SP list, SQL data etc inside the dashboard.

4.   Right click on data source ->select New -> Report

5.   Select excel services

6.   Click OK

7.   Once you will see the excel file selected in the “excel workbook” location then click on ‘View’

That’s it – You will get the error as mentioned below-

Error message:

We’re sorry. We ran into a problem completing your request. Please try that again in a few minutes.

How to fix this issue?

Here is the resolution:

1.   Open the Central administration

2.   Application management

3.   Manage web applications

4.   Select the web application where your site resides underneath

5.   Manage service connections

6.   Select the Excel Services Application

7.   Click OK

That’s it – You are done! Your issue will be resolved J

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

Note: If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product Applies to:

1.   SharePoint 2013

2.   SharePoint 2010

3.   SharePoint Foundation 2010

4.   SharePoint Foundation 2013

"Setup is missing prerequisites" error message when you try to install the PowerPivot add-in for Excel in FAST Search Server 2010 for SharePoint

Problem Description:

Consider the following scenario:

• You have a server that has the Business Intelligence Indexing Connector feature installed in Microsoft FAST Search Server 2010 for SharePoint. 

• You have to crawl Microsoft Excel 2010 files that contain PowerPivot content. 

• You install the PowerPivot add-in for Excel on the server. 

In this scenario, the PowerPivot add-in for Excel does not install.

Additionally, you receive the following error message:

Setup is missing prerequisites:

This add-in requires Excel 2010. If you have 32-bit Excel, you must install the 32-bit version of the add-in. If not, you must install the 64-bit version. This add-in requires that the Office Shared Features component of Microsoft Office 2010 is installed.

Go to http://go.microsoft.com/Fwlink/?LinkId= 168472

Probable cause:

This issue occurs because Excel 2010 is not installed on the server.

Resolution:

To resolve this issue, install Excel 2010 on the server.

OR—Follow this article: http://support.microsoft.com/kb/982765

Please let me know in case of any queries/questions.

I would be more than happy to help you as well as resolves your issues, Thank you J

Note: When installing PowerPivot add-in for Excel, you don’t look at whether you have a 32-bit machine or a 64-bit machine; instead, you should look at whether you have 32-bit Excel or 64-bit Excel. In other words, if you are using the 32-bit version of Excel 2010, you must use the 32-bit version of PowerPivot and if you are using the 64-bit version of Excel 2010, you must use the 64-bit version of PowerPivot.