13 September, 2013

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…

12 September, 2013

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

Windows PowerShell Scripting from TechNet Learning Section

PowerShell for Beginners from Wiki library Section

Windows PowerShell for SharePoint 2013 IT pros

Windows PowerShell for SharePoint Command Builder


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