- Logged into the Central Administration of the Sharepoint on the relevant server.
- Clicked on Application Management
- Clicked on Manage Service Applications
- Cicked on Excel Service Application which is a hyperlink in blue
- Clicked on Trusted File Locations and clicked on the relevant link as shown below
Tuesday, May 15, 2012
Workbook is larger than the maximum workbook size
I use sharepoint 2010 to display the data analysis tool I have created in excel 2010 to manage the Microsoft licenses as well as to utilise the excel 2010 capabilities of slicers and dicers. This has been going pretty smoothly until yesterday when I stumbled with this error below.
"Workbook is larger than the maximum workbook size"
So I had to go through the Excel web services properties on the sharepoint server and increase the maximum file size.
Here are the steps that I followed.
At my work I have inherited a database where the partitioning was not done correctly. This database holds millions and millions of records...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...