How I will open Excel Workbook in SharePoint

Asked By Kyle M Arteaga 50 points N/A Posted on - 05/15/2014

Hi,

When I try to open an excel workbook from SharePoint I could not open it. I got an error message saying ‘that’s a big workbook. Unfortunately, we can’t open a workbook. You’ll need to open this in Excel.’ However, I need it open in SharePoint, is there any alternate ways to solve this problem other than opening in Excel. Please help me, thanks a lot. 

 

Couldn’t Open the Workbook

Wow, that’s a big workbook.

Unfortunately, we can’t open a workbook larger than 5 MB.

You’ll need to open this in Excel.

• Status: Open
• Question Views: 875
• Answer Count: 1
• Vote Up 2 Vote Down

• Answer Accepted: No
• Question Category: MS SharePoint

Answered By points N/A #169622

How I will open Excel Workbook in SharePoint

There is a limitation to the size of workbook selected inside “SharePoint Central Administration”. Due to this reason, you’re unable to open files that are larger than 5 MB. The limitation to your case is 5 MB and the file you’re trying to open is more than that. You can increase the file size value by doing the following:

1. Open “SharePoint Central Administration”.
2. Go to Application Management >> Manage Service Applications >> ExcelServiceApp >> Trusted File Locations.
3. Click “Address”.
4. Beneath “Workbook Properties”, the value for “Maximum Workbook Size” is located. Increase the value. Notice that the file is in MB.
5. Click “OK”.

Don’t forget to make the value high enough so that you don’t have to face such issue in the future.

About

Questions
0

Answers
6

Best Answers
31531

• Vote Up 0 Vote Down

• Posted on - 05/15/2014
• Question Category: MS SharePoint