How to overwrite or disable the List View Threshold value for particular list in SharePoint 2010 Using PowerShell

If you want to overwrite or disable the threshold limit of List View items for particular list then execute the following cmdlets in Powershell.

$WebApplication = Get-SPWeb http://<SiteCollectionName>

$List = $WebApplication.Lists["List Name"]

$List.EnableThrottling = $false

$List.Update()

There is one property of SPList called "Enable Throttling" which has to be set to false to overwrite the threshold limit set on Web Application for all the lists.

I hope this is helpful and If you have any questions then please let me know, Thank you.

Applies to SharePoint Server 2010.

Error while opening excel files after upgrade your SharePoint site to 2010

Error Message: The workbook cannot be opened because it is not stored in an excel services.

Cause: By default the setting in the library is set to "open the file in browser".

Resolution: Change the Library settings to open files in Client application.

Steps: 

-Open your document Library

-Click on "Library" under "Library tools" (See screenshot)

 

-To the extreme right on the ribbon, please click on "Library settings".

-Click on Advanced settings under General settings.

-In the settings for "Opening Documents in the Browser"

-Change the radio button and select Open in the client application.

-Click OK

You must change this setting in all the document libraries.

 

Applies to: SharePoint Foundation 2010/SharePoint Server 2010.

 

 

Attachments doesn’t open when attached with a discussion boards.

The lists can be configured to open documents in client mode but this doesn’t happen with discussion boards and other collaborative lists which do not have a special provision for attachments.

Error messages may say that the features included in the files are not supported by web browser.

Reason: Uploaded excel files may contain macros or other calculations which needs an excel client. In SP 2010 all the office documents open in client by default so ether make the settings suggested below or turn on a feature to open all documents in client by default.

Steps to do this:

• Go to Site Actions 
• Site settings 
• Site collection Features 
• Open documents in Client Applications by default

Applies to: SharePoint Server 2007/2010.

Windows Server and Virtualization Bulletin.

Should You Consolidate onto a Private Cloud? Free Checklist

Download »

9 Reasons Why SaaS Makes More Sense for Network & Server Monitoring

Download »

How to Avoid the Top 3 Challenges of SharePoint

Download »

File Sharing Using iPads: What CIOs Must Know

Download »

The 5 Biggest Storage Problems

 

Understanding Hyper-V in Windows Server 2012 - 180-Page Guide

Download »

Extending the Life of an Existing SAN

Download »

How to Improve Cooling Capacity & Operating Costs

Download »

The 5 Biggest Virtualization Problems

Register »

How to Manage Your Virtual Desktop with Layers

Download »

How to Build a Cloud in a Day

Download »

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.