How to enable ‘New Folder’ option in document library + Custom list + New Folder disabled - SharePoint 2010

I want to create a new folder in a document library but this option is disabled.

Let’s see how we can make this option enabled...

 

Click on Library (Top portion- Ribbon) – Please refer the following screenshot

 

Click on Library settings - Please refer the following screenshot

Click on Advanced settings - Please refer the following screenshot

Go to the folder section and select the option Yes - Please refer the following screenshot

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…

Learning PowerShell from Microsoft Resources

These days PowerShell has become a very strong scripting language to manage any MS technology from the command prompt.

However, the person like me who is a newbie to SharePoint keeps thinking from where to start and how to start.

So here I have presented some of the resources for my reference and others reference from Microsoft and these can be quickly referred to.

Windows PowerShell Quick Reference

http://www.microsoft.com/en-us/download/details.aspx?id=7097

Windows PowerShell Scripting from TechNet Learning Section

http://technet.microsoft.com/en-gb/scriptcenter/powershell

PowerShell for Beginners from Wiki library Section

http://social.technet.microsoft.com/wiki/contents/articles/4307.powershell-for-beginners.aspx

Windows PowerShell for SharePoint 2013 IT pros

http://technet.microsoft.com/en-US/sharepoint/jj672838

Windows PowerShell for SharePoint Command Builder

http://www.microsoft.com/resources/TechNet/en-us/Office/media/WindowsPowerShell/WindowsPowerShellCommandBuilder.html

Windows PowerShell Crash Course http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/WSV321-R

Hope this piece of information will be helpful for you all and will let you refer to any external resources other than the MS Ocean.

If you have any queries and questions please do let me know. I would be more than happy to answer those.

Applies to:

1)   SharePoint 2010

2)   SharePoint 2013

3)   Windows PowerShell 3.0

An Excel workbook that contains a PowerPivot table is corrupted after you upload the Excel workbook to a SharePoint PowerPivot gallery

Problem:

One of our clients reported when he tried to open Excel workbook which contains Pivot table from the SharePoint Pivot Gallery, after doing the refresh, the Excel workbook doesn’t open or opens in the repair mode.

Background: Office 2010, Excel 2010. Windows 7 64-bit.

Troubleshooting:

1)   Checked if multiple versions of office installed.

2)   Downloaded the local copy of the file and it was opening fine.

3)   Checked the content of the Excel file that does contain the pivot tables and using the external connection in the source file was fine.

4)   Tried to use the different connection string in the Excel, i.e. fetching data from any other external source.

5)   Local copy of the file was working fine, whereas when publishing to SharePoint it breaks.

Resolution:

This was a prolonging issue and MS has confirmed that this is not a SharePoint issue and has to be the SQL 2008 issue, which got fixed in the Cumulative update 2 for SQL Server http://support.microsoft.com/kb/2072493

You can also get a hot fix which is supported by KB- http://support.microsoft.com/kb/2028769

If you face any difficulties or have any further queries, please flag them, I would be happy to assist you with them.

Applies to:

Microsoft SQL Server 2008 R2 Enterprise

Microsoft SharePoint Server 2010

Microsoft Excel 2010

Find SharePoint installed feature information in SharePoint: SharePoint 2010

It is possible by means of the SharePoint Power Shell Console below is the PW script which does this for you. 

PS 1: Gives a simple output of all features in table format sorted by solutionId then featureName. 

PS 2: Gives the output of all features in table grouped by solutionId, then solutionId is replaced by actual solution name with a separate lookup (very minor performance loss due solution name replacement)

If you have any issue in executing these scripts do let me know, I would be happier to assist you.

How to Edit the Web.config Using PowerShell

While working with Client you get to work on a lot of changes and a lot of modifications to the default configuration of the farm and it is always difficult to work on these changes manually.

Recently I was trying to find a way to modify the webconfig file via some command line utility, then, I came across a very detailed article on the the MS blog Hey, Scripting Blog !, which was exactly fit for my needs so I thought of sharing it with all of you as well.

At this link you can find a detailed step by step guide by Josh the MS Premier field Engineer,http://blogs.technet.com/b/heyscriptingguy/archive/2010/09/14/use-powershell-to-script-changes-to-the-sharepoint-web-config-file.aspx  

A zillion thanks to Mr Josh for publishing this for us....!!!