The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document.

After some troubleshooting, I found that the document library was created with multiple nested folders.

When we go to third or fourth level of the folder and try to edit any file with office application, we are getting an error – The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document. However if we try to edit the document uploaded on the root of the document library, we can edit it properly.

You cannot edit the office document once the URL exceeds the character limit 340. You can edit the documents only till URL path length is upto 339 characters. You can open the documents, you can upload documents but you can't edit them by right click on document and click on "edit in Microsoft Word". Even this behavior is same with non-office documents also like text documents.

Workaround:
-The only workaround possible is

- open the file directly from the folder, modify and save it as a new file.

Every time you need to save it as a new file. It wont allow to save in the existing file. Or, Move the file one level up and you will be able to do all the operations like edit,check-in and check-out too

Wiki Page not showing any content when a Wiki Page Library created from saved template

This is a weird issue I found. One of my users saved a Wiki Page library as a template and created a new wiki page library.

The new Wiki Lib works fine as expected and then he had deleted the old one.

Now when he tried to create another wiki library from the new wiki lib, it gave all the pages but the weird thing is all contents are gone.

I performed following steps to resolve this issue.

i.e. Source Wiki Page Library = Lib A

i.e. New Wiki Page Library = Lib B

·         Open Lib B which made from Lib A and having all the content

·         Click on the drop down of each pages and then click “Edit Properties”

·         Click on OK without changing any content

·         Then save Lib B as a template

·         Create a new Wiki Lib (i.e. Lib C)

·         You will get all contents (Wiki Pages) with all contents in it.

Please let me know in case of any issues / queries.

How to: Export a Discussion topic List item (SharePoint 2007) to excel or PDF ?

Here is  some tricky way to achieve this GOAL

When you reply to a discussion it changes to Flat view and redirected to flat.aspx page.

So to export discussion topic in excel you have to manually change the URL from flat.aspx to allitems.aspx.

I.e. to enable export to spreadsheet option URL should be http://siteURL/Lists/discussionname/allitems.aspx

Else to export from “Flat view” tries following steps.

·         Open Excel

·         Click on DATA tab

·         Select from Web option

·         Then in URL provide the URL with http://siteURL/Lists/discussionname/flat.aspx

·         This will open a page with Allitems.aspx in pop up and then you can select (arrows) to insert required data to excel.

·         And from Excel you can easily export to PDF

Feel free to reach me in case of any queries / issues related to above post.

How to check the Storage space for a Sharepoint Subsite

To check the Size or the Storage space of a Subsite you will have to open the site Collection in Windows Explorer.

Look for the Subsite(Folder), Right click on that and select properties. It will show you the exact space of the Subsite. There is no way to check that from the Site settings page or from Central Admin.



 

Let me know if anyone has found other way to check the Size for Sharepoint Subsite.

 

 

How to add Webparts on NewForm.aspx, DispForm.aspx or EditForm.aspx on Sharepoint list and Libraries

Recently i found something interesting, so thought of sharing .

Did you ever tried adding a webpart on newform.aspx, edirform.aspx and dispform.aspx, there is no option to edit the page and add a webpart correct ?

There is a  solution for that. Try the following steps and then you can add the webpart on Sharepoint List and Libraries Item level page.

1. Open the SharePoint site and navigate to the  list or library page and view a list item. This should take us to the dispform.aspx page


2. Modify the URL and replace everything after ../dispForm.aspx?ID=# with&PageView=Shared&ToolPaneView=2 


3. At the end your URL should look like ../dispForm.aspx?ID=#&PageView=Shared&ToolPaneView=2 and press Enter.

That page will give you an option to Add the webpart.

Unable to add users to a group Sharepoint permissions

I worked on one of the issue wherein I was unable to add Users to ANY of the group, even though we were having 3 groups on the Site.

Here is what I did to resolve the issue. Hope this steps will help you solve your issue Quickly J

Whe we go to Advanced permissions, You can see that there are already 3 Groups added with different permission levels.



From Advanced permissions page click on New – Add user- It takes us to the page where we can add the user explicitly or inside a Group. In this case, "Add Users to SharePoint Group" option was grayed off - (Above 3 Groups are not visible)




After some investigation I found that, those groups were removed from the Groups – Quick launch




To add them back – Click on the Groups – Settings – Edit Group Quick Launch – Add these 3 Groups there and say Okay.




Once these 3 groups are visible Under the Quick Launch – Click on New – Add user.




Issue is resolved now; you can see the groups in the drop down as expected

How to hide the Left navigation bar or Quick launch Sharepoint 2010

To hide the left navigation bar\ Quick launch , you can add the follow the below mentioned steps.

Site Actions

Edit Page 

Add a webpart

Add Content Editor Webpart

Modify shared webpart - Edit the Source Code and paste the below code in Source code .

<Style>
body #s4-leftpanel
{
display: none;
}
.s4-ca
{
margin-left: 0px;
}
</style>

Select Ok. Then from the Appearance Section Hide the webpart - Click Apply Ok. Exit Edit mode.

Hope this helps

How to Create a Site Collection in a Specific Content Database

You can follow the below steps if you have a requirement of creating a Site Collection in to a Specific Database when you have multiple Content Db for a Particular web application .

1. Under the Application Management section access the “Content Databases” link.


2. In the upper right hand corner make sure you are in the correct Web Application. If you aren’t then change to the correct one.


3. Click the link for each Content Database you have listed under the “Database Name” heading.


4. When the “Manage Content Database Settings” page opens set the “Database Status” to “Offline” and then click “OK”. After you click ok you’ll be taken back to the “Manage Content Databases page where the database you just changed should now show as “Stopped”.


5. Click the “Add a Content Database” link and create a new content database. Do not make any changes to the “Database Status” setting. It will show as “Started” in the list of Content Databases. You will also notice that the “Current Number of Sites” will be equal to 0.


6. Navigate to the SharePoint Site Management section and create your new site collection.


7. Go back to the Manage Content Databases list and you will now see that the Content Database you just created now shows that the Current Number of Sites is equal to 1.

You have just created a new site collection in the content database of your choice.

SharePoint 2010 useful links

Manage Excel Services trusted locations  

This article explains how to manage the default trusted location for a SharePoint Server 2010 farm. It also explains how to add, configure, delete, and edit existing trusted locations for Excel Services in Microsoft SharePoint Server 2010.

http://technet.microsoft.com/en-us/library/ff191194(office.14).aspx

Manage Excel Services connections  

This article explains how to deploy Excel workbooks with external data connections using Excel Services. It provides details for managing both trusted data connection libraries and trusted data providers.

http://technet.microsoft.com/en-us/library/ff191200(office.14).aspx

Manage Excel Services authentication  

This article explains how to manage Excel Services settings using the Central Administration site.

http://technet.microsoft.com/en-us/library/ff191192(office.14).aspx

Manage Excel Services with Windows PowerShell  

This article explains how to use the Windows PowerShell commands with Excel Services. It also provides several sample commands.

http://technet.microsoft.com/en-us/library/ff191201(office.14).aspx

Configure Secure Store Service for Excel Services  

This article explains how to configure and manage the Secure Store Service for Excel Services. It also provides details for setting permissions and accounts to use the unattended account with Excel Services.

http://technet.microsoft.com/en-us/library/ff191191(office.14).aspx

Plan visual upgrade (SharePoint Server 2010)  

This article discusses the new visual upgrade feature in SharePoint Server 2010. You can choose to preserve the look and feel of sites during an upgrade from Microsoft Office SharePoint Server 2007, or you can move all sites to the new user interface.

http://technet.microsoft.com/en-us/library/ff191199(office.14).aspx

Create a PowerPivot data connection (PerformancePoint Services)  

This article describes how to create a data source connection to PowerPivot using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191197(office.14).aspx

Create a SharePoint List data connection (PerformancePoint Services)  

This article describes how to create a data connection to a SharePoint Server 2010 using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191195(office.14).aspx

Create a SQL Server table data connection (PerformancePoint Services)  

This article describes how to create a data source connection to a SQL Server table using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191190(office.14).aspx

Create an Analysis Services data connection (PerformancePoint Services) 

This article describes how to create an Analysis Services data connection in PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191198(office.14).aspx

Create an Excel Services data connection (PerformancePoint Services)  

This article describes how to create a data source connection to Excel Services using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191193(office.14).aspx

Create an Excel Workbook data connection (PerformancePoint Services)  

This article describes how to import a workbook using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191202(office.14).aspx

Create data connections (PerformancePoint Services) 

This article provides an overview on creating data connections to external sources using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191196(office.14).aspx

Plan for backup and recovery (SharePoint Server 2010)  

This article has been updated to include a link to a planning worksheet, and includes updated information about choosing a backup solution.

http://technet.microsoft.com/en-us/library/cc261687(office.14).aspx

Backup and recovery overview (SharePoint Server 2010)  

This article has been updated to more fully describe granular backup, and how SharePoint Server 2010 backup works with the SQL Server FILESTREAM remote BLOB storage provider.

http://technet.microsoft.com/en-us/library/ee663490(office.14).aspx

Configure and use the Lotus Notes connector (SharePoint Server 2010)  

This article describes the process for installing and configuring the Lotus Notes connector for SharePoint Server 2010.

http://technet.microsoft.com/en-us/library/ff463593(office.14).aspx

Language packs (SharePoint Server 2010)  

This technical reference article lists the language packs that are available for SharePoint Server 2010.

http://technet.microsoft.com/en-us/library/ff463597(office.14).aspx

Restrict or enable access to a service application (SharePoint Server 2010)  

This article describes how to restrict access to a service application by assigning and removing service accounts. It also describes how to reestablish local farm-wide service access to a service application.

http://technet.microsoft.com/en-us/library/ff463596(office.14).aspx

Diagnostic logging in Business Connectivity Services overview (SharePoint Server 2010)  

This article describes how to use diagnostic logs on servers that are running SharePoint Server 2010 and on Microsoft Office 2010 client applications to troubleshoot issues related to Microsoft Business Connectivity Services. It also describes how to use Activity IDs to trace issues to external systems.

http://technet.microsoft.com/en-us/library/ff463594(office.14).aspx

Versioning, content approval, and check-out planning (SharePoint Server 2010) 

This article describes how to plan to use versioning, content approval, and check-out functionality in SharePoint Server 2010 to control document versions throughout their lifecycle.

http://technet.microsoft.com/en-us/library/cc262378(office.14).aspx

Records management overview (SharePoint Server 2010)  

This article describes records management and provides an overview of the process of planning for records management.

http://technet.microsoft.com/en-us/library/cc261982(office.14).aspx

Create a file plan to manage records in SharePoint Server 2010  

This article describes the contents of a file plan and summarizes how to create one for your organization.

http://technet.microsoft.com/en-us/library/cc261708(office.14).asp x

Plan how records are collected (SharePoint Server 2010)  

This article reviews techniques that you can use to declare active documents to be records.

http://technet.microsoft.com/en-us/library/cc263464(office.14).aspx

Physical records planning (SharePoint Server 2010)  

This article describes how to plan to use SharePoint Server 2010 to manage physical records.

http://technet.microsoft.com/en-us/library/cc263416(office.14).aspx

Planning for eDiscovery (SharePoint Server 2010)  

This article describes how SharePoint Server 2010 supports eDiscovery.

http://technet.microsoft.com/en-us/library/ff453933(office.14).aspx

Plan Visio Services security (SharePoint Server 2010)  

This article describes security for Visio Services in Microsoft SharePoint Server 2010. It has been updated to provide additional information about available security options.

http://technet.microsoft.com/en-us/library/ee663483(office.14).aspx

Create a Visio Graphics Service application proxy (SharePoint Server 2010)  

This article describes how to create a Visio Graphics Service application proxy. It has been updated to clarify when such a proxy can be created by using the SharePoint Central Administration Web site.

http://technet.microsoft.com/en-us/library/ee524060(office.14).aspx

Configure Visio Graphics Service global settings (SharePoint Server 2010)  

This article describes the various global settings for Visio Graphics Service. It has been updated to include more information about cache and recalculation options.

http://technet.microsoft.com/en-us/library/ee524061(office.14).aspx

Configuring Visio Graphics Service trusted data providers (SharePoint Server 2010)  

This article describes Visio Graphics Service trusted data providers configuration. It has been updated to provide more detailed information about the included trusted data providers.

http://technet.microsoft.com/en-us/library/ee524056(office.14).aspx

How to add a Video on Sharepoint Site

 A Very Simple way to Embed a video on your sharepoint site.  

1. Upload a media file to a standard SharePoint Document Library


2. Navigate to the site where you want to embed the video


3. Edit the page and select Add a Web Part


4. Under Miscellaneous, insert a Content Editor Web Part


5. From the Web select Open the Tool Pane


6. From Tool Pane, select Source Editor


7. Copy in the following code (replace http://link to video here with the actual link to the video in the library):

<div align="center">

   <embed src="http://link to video here"

      autoplay="true"

      loop="false"

      width="200"

      height="200"

   </embed>

</div>

Click Apply and Voila :)

Unable to send Alerts to a user or Group

Issue

Whenever you add a user or  group to alerts section in a library\list. Alerts are not getting delivered when anything is changed.

Resolution

Make sure those groups are added in the Library\Lists permissions. They should atleast have read access to get the alerts.

Unable to add DL to sharepoint permissions

Issue
 whenever you try to add a DL to sharepoint permissions, it doesn't resolve and gives an error

Resolution
 If you want to add any DL to the sharepoint permissions, it should be converted to Security Groups. As soon as that is converted to Security Group it will be resolved in the permissions section and users will be able to access the site.

Note: If those DL's are having SUB DL's inside it , then they should also be converted to Security Groups.

Export SharePoint Permissions to Excel

I have seen multiple requests from the users asking to Export SharePoint permissions to Excel Sheet. Now there is a way to export it from sharepoint 


To do this , you will have to Open Excel Sheet , Navigate to Data Tab – Click on "From Web", as shown in the below Screen shot





Once You click on that , it will bring up a New Web Query pop up Box, You will have to Enter the URL and Select the check boxes Highlighted in yellow to import it in Excel.





Select the desired users, Click on Import and Voila . All the users imported.


Hope this Helps.