Thursday, February 23, 2012

Cannot connect to the server at this time. Changes to your data cannot be saved Export to Spreadsheet

One of my colleague reported an issue with  “Export to Spreadsheet” in Sharepoint 2007 list. He was the only one who was getting this error message. So this was sure that this was a machine specific issue and has to do something with the IE settings.

When he clicked on one of the list it says “Cannot connect to the server at this time. Changes to your data cannot be saved” and at the same time i was able to get this working.

After some troubleshooting we found that,  when the SharePoint site had been accessed from Vista/Win7 clients with SSL (https) and with the local user account. Turned out that the problem was related to certificate revocation lists (CRLs) and had been an issue due to the following setting in IE: “Check for server certificate revocation” which is switched on by-default on Vista/Win7 clients as opposed to XP clients. When this IE switch got turned off, everything was working fine.

Breadcrumbs shows wrong URL

Today I have gone thru a very good example of auto redirection. I was doing some routine exercise on a custom list and converted it to XSLT view in SharePoint Designer to customize it. For safety I took couple of copied of AllItems.aspx page and started customizing default one. For some reason I did not like customization and I deleted the original AllItems.aspx and renamed the copied one.

Now when I go to List Settings from browser and click on the list name in bread crumb it redirected me to Web Portal.
(I went to list settings to delete the list, but suddenly I found I was deleting something wrong J) this was more than shocking to me as I missed to make necessary changes.

This was really small and easy change I made, went to SharePoint Designer > Browsed to List > Right Clicked on Properties > Supporting Files > Default view Page.
Make sure it displays “AllItems.aspx” page, in my case it was blank.

Friday, February 17, 2012

Unable to create a new page in Sharepoint Site - Access denied

ISSUE:   When attempting to create a page by clicking Site Actions Create Page, the user immediatly receives an Access Denied. This occurs even if the user is a member of the Site Owners group with Full Control.

ERROR MESSAGE: Access Denied

CAUSE: : The access denied was a result of the user not being a part of the Style Resource Readers group. According to technet, this group allows a user to read the Master Page Gallery and Restricted Read the Style Library. By default, this group contains only the NT AUTHORITY\Authenticated Users group. This will allow all users who have authenticated to the site to read the Master Page gallery and Style Library.


1) Open the site you are having issues with 2) Click Site Actions Site Settings 3) In the Users and Permissions section, click People and Groups 4) Click Groups 5) Click Style Resource Readers 6) Click New Add User 7) In the Add Users section, click the Add all authenticated users link 8) Click OK

Wednesday, February 15, 2012

Sharepoint quick links


Sharepoint Links which might be helpful while troubleshooting issues

FunctionAdd to the URLNotes
Add Web Parts Pane?ToolPaneView=2Add to the end of the page URL; WILL ONLY WORK IF THE PAGE IS ALREADY CHECKED OUT
Create list in a different portal area/_layouts/new.aspx? NewPageFilename=YourTemplateName.stp& ListTemplate=100& ListBaseType=0When you save a template in a portal area and try to create a new list in a different portal area, the template will not show on the Create page. Use this URL to force it to show.
Documents and Lists/_layouts/viewlsts.aspx
List Template Gallery/_catalogs/lt
Manage Audiences/_layouts/Audience_Main.aspx
Manage Cross Site Groups/_layouts/mygrps.aspx
Manage List Template Gallery/_catalogs/lt/Forms/AllItems.aspx
Manage My Alerts/_layouts/MySubs.aspx
Manage People/_layouts/people.aspx
Manage Site Collection Administrators/_layouts/mngsiteadmin.aspx
Manage Site Collection Users/_layouts/siteusrs.aspxTo access you must be an admin on the server or a site collection admin for the site.
Manage Site Groups/_layouts/role.aspx
Manage Site Template Gallery/_catalogs/wt/Forms/AllItems.aspx
Manage Site Template Gallery/_catalogs/wt/Forms/Common.aspx
Manage Sites and Workspaces/_layouts/mngsubwebs.aspx
Manage User Alerts/_layouts/AlertsAdmin.aspx
Manage User Alerts/_layouts/SiteSubs.aspx
Manage User Permissions/_layouts/user.aspx
Manage Web Part Gallery/_catalogs/wp/Forms/AllItems.aspx
Master Page Gallery/_catalogs/masterpageAlso includes Page Layouts
Modify Navigation/_layouts/AreaNavigationSettings.aspx
Recycle Bin/_layouts/AdminRecycleBin.aspx
Save as site template/_layouts/savetmpl.aspx
Site Column Gallery/_layouts/mngfield.aspx
Site Content and Structure Manager/_layouts/sitemanager.aspx
Site Content Types/_layouts/mngctype.aspx
Site Settings/_layouts/settings.aspx
Site Settings/_layouts/default.aspx
Site Template Gallery/_catalogs/wt
Site Theme/_layouts/themeweb.aspx
Site usage details/_layouts/UsageDetails.aspx
Site Usage Summary/_layouts/SpUsageWeb.aspx
Site Usage Summary/_layouts/Usage.aspx
Sites Registry/SiteDirectory/Lists/Sites/Summary.aspx
Top-level Site Administration/_layouts/webadmin.aspx
User Information/_layouts/userinfo.aspx
Web Part Gallery/_catalogs/wp
Web Part Page Maintenance?contents=1Add to the end of the page URL

Old image displayed in Sharepoint picture library

Issue: User came with the issue that the old image appears even after the old image is deleted and a new image is uploaded into the Library. But he is able to view the updated image in the other user's machine

Resolution: 1. A copy of the file was store into the recycle bin of his machine. 2. Deleted the Old image from the Recycle bin. 3. Cleared the Cache. 4. Tried to Open the Iamge and it Opens up correctly. 5. Done

Saturday, February 11, 2012

TechNet SharePoint Virtual Labs

A very good resource from Microsoft to learn SharePoint by your own. A list of virtual labs including all versions of SharePoint from portal server 2003 to SharePoint 2010. The perfect material to dive into SharePoint.

SharePoint Server 2010

Thursday, February 2, 2012

SharePoint Administration Tools and Management Tools - Idera SharePoint Admin Toolset

SharePoint admin toolset v3.0

FREE Tools to Simplify SharePoint Management

Simplify and streamline day-to-day SharePoint administration tasks
  • 7 essential tools for monitoring, securing and administering SharePoint
  • Reduces administrative activities from hours to minutes
  • Performs key tasks without the need for deep SharePoint expertise
  • Dramatically enhances site performance
  • Shows what can be accessed by whom in seconds