Saturday, March 26, 2011

Icons are missing from Project Tracking Workspace Template in SharePoint 2007

 This is a global issue and I am very surprised that do not get any solution on internet.
When we create a site using Project Tracking Workspace template (Fantastic 40), following ICON images are missing from the site

It shows  red cross icon instead of following icons.

List Icons:


Site Feature Icon:



Download missing icons from internet and add them into images folder on server

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\IMAGES folder

After which list and feature looks like

Friday, March 25, 2011

Distorted Toolbar or No Toolbar in Document Library


Sometimes back I have found very interesting issue on one of my document library.

Even if I login through system account, not getting menu bars icons.

This is only with a specific document library, if I create a new document library all menu icons were available.

  • As per the missing list toolbar, please go to SharePoint Designer 2007
  • Open the view page includes this list view web partRight click that web part > Convert to XSLT List View Web Part
  • Right click the web part again > Data View Properties > General Tab > enable "Show List Toolbar"
  • Verify "SharePoint List Toolbar" must be checked.
 And here is the toolbar

If all these don't work replace working Allitems.aspx page with faulty one.

In addition you can customize toolbar using above steps.

Wednesday, March 23, 2011

Change Calendar Item appearance in MOSS 2007

By default when we create any item in MOSS 2007 calendar we only get Start Time in Calendar View.
To display the End Time of an event follow below steps

·        Create a new column with Calculated type.
·        Enter a name, as data type choose date & time.
·        And enter below formula

=Title&" from "&TEXT([Start Time],"hh:mm AM/PM")&" to "&TEXT([End Time];"hh:mm AM/PM")

·        After you have successfully created this column you have to modify the Calendar View.
·        So go back to the Calendar and click on Modify View. You will see an area called 'Calendar Columns’; there you can specify which column should be shown.
·        Change the Views Month, Week and Day. Here you have to choose newly created Column.
·        Click Ok and have a look at the result

MySite Search issue with Access Denied error

Each time the crawling on MySite site collection would generate numerous errors in event log as below
System.UnauthorizedAccessException: Access denied.
   at Microsoft.SharePoint.Utilities.SPUtility.HandleAccessDenied(Exception ex)
   at Microsoft.SharePoint.SPGlobal.HandleUnauthorizedAccessException(UnauthorizedAccessException ex)
   at Microsoft.SharePoint.Library.SPRequest.CheckOutFile(String bstrUrl, String bstrWebRelativeUrl, Boolean bCheckoutToLocal, String bstrLastModified)
   at Microsoft.SharePoint.SPFile.CheckOut(Boolean bCheckoutToLocal, String lastModifiedDate)
   at Microsoft.SharePoint.SPFile.CheckOut()
   at ABC.Intranet.Web.UI.WebControls.MySiteModifier.b__0()Additional Information:
  Site Collection URL - |
  Web Site URL - |
  HttpRequest URL - Documents/Forms/AllItems.aspx |
  HttpContext User  - abc\Crawl_Acct |
  SPWeb User - abc\ Crawl_Acct |
The crawling account has READ permission over My Site collection and this account does have NO access to the specific URL in error below –
This issue is resolved after adding Content Access Account under
 Central Administration > SSP > User Profiles and properties > Personalization services permissions
with "Manage user profiles" permission

Intermittent Authentication Error: 403 Forbidden

Some days back I have faced an Intermittent Authentication Error issue.
Several users received a 403 Forbidden error when they try accessing the SharePoint site.  If they clear all IE cookies, they were able to log in one time but if they close and reopen the browser, they receive the 403 error again until they clear their IE cookies once more.  
After clearing the cookies, they were prompted for re authentication when attempting to open any MS Word documents as well and the document fails to open
Finally I have got below articles to get rid of this issue.

Tuesday, March 15, 2011

Import / Export data from a SharePoint page (which is not a List / Library) to Excel

To export a data from a page (not Document Library / List) to Excel
  • Open MS Excel 2007
  • Go to Data Tab
  • Select From Web option

  • Put in the URL with http://URL/_layouts/storman.aspx > Click GO

  • It will display the Storage Space Allocation page in the pop up window
  • Select the area which you want to import
  • Click on import button
  • It will import the data from Storage Space Allocation page to Excel

Please let me know in case of any queries.

Thank you.

Monday, March 14, 2011

Excel 2003 files try to open in Word 2003 when using SPS 2003

SPS 2003
Office 2003
If I click an Excel file in SharePoint, it opens read-only in Excel, as expected.  If I use the drop down and choose Edit in Microsoft Office Excel, then the file tries to open in Word instead of Excel - which does not work, of course.

If I close all instances of Excel before trying to open from SharePoint into Excel, then it does work.  The issue only occurs when I have other instances of Excel open.

Opening Excel files from websites that are not SharePoint works as expected.  This issue only occurs with Excel files stored on SharePoint.

Other office files work as expected, also immediately upon choosing the Edit in Microsoft Office Excel menu item, I get the error below and then the document tries to open in Word.

Error Message -
The document could not be edited. The required application may not be installed properly, or the requested document cannot be opened. Please ensure that the necessary application is installed and that the path to the document is correct. If the application was set to install on first use, run the application and then try editing a document again.

Repaired Office 2003 from control panel and everything works fine

Thursday, March 10, 2011

SharePoint 2010 Versions

SharePoint 2010 Version Microsoft Support KB  Version Number 
SharePoint 2010/Foundation December 2010 Cumulative Update 2459257, 2459125
SharePoint 2010/Foundation October 2010 Cumulative Update 2394320, 2394323
Foundation July 2010 Hotfix 2032588 14.0.5050.5001
SharePoint 2010/Foundation June 2010 Cumulative Update 983319, 983497, 2182938 , 2281364, 2124512, 2204024 - / KB 2028568 / TechNet summary
SharePoint 2010 RTM N/A
SharePoint Server 2010 Release Candidate N/A
SharePoint Server 2010 Public Beta N/A
SharePoint Server 2010 SPC2009 Demos N/A
SharePoint Server 2010 Technical Preview “2” [another SPC2009 demo build] N/A
SharePoint Server 2010 Technical Preview N/A

SharePoint 2007 Versions

SharePoint 2007 Version Microsoft Support KB  Version Number 
MOSS 2007 or WSS 3.0 Cumulative Update February 2011 KB2475885/ KB2475886
MOSS 2007 or WSS 3.0 Cumulative Update December 2010 KB2458605/ KB2458606
MOSS 2007 or WSS 3.0 Cumulative Update October 2010 KB2412267/ KB2412268
MOSS 2007 or WSS 3.0 Cumulative Update August 2010 KB2276472/ KB2276474
MOSS 2007 or WSS 3.0 Cumulative Update June 2010 KB983310/ KB983311
MOSS 2007 or WSS 3.0 Cumulative Update April 2010 KB981042/KB981043
MOSS 2007 or WSS 3.0 Cumulative Update February 2010 KB978395/KB978396
MOSS 2007 or WSS 3.0 Cumulative Update December 2009 KB977026/KB977027
MOSS 2007 or WSS 3.0 Cumulative Update October 2009 KB973409/KB973410
MOSS 2007 or WSS 3.0 August 2009 Cumulative Update KB973409/KB973410
MOSS 2007 or WSS 3.0 June 2009 Cumulative Update KB971537/KB971538
MOSS 2007 or WSS 3.0 April 2009 Cumulative Update  KB968851/KB968850
MOSS 2007 or WSS 3.0 SP2 KB953334/KB953338
MOSS 2007 or WSS 3.0 Cumulative update  KB956056/KB956057
MOSS 2007 or WSS 3.0 Infrastructure Update  KB951695/KB951297
MOSS 2007 or WSS 3.0 post-SP1 hotfix KB948945
MOSS 2007 or WSS 3.0 post-SP1 hotfix KB941274
MOSS 2007 or WSS 3.0 post-SP1 hotfix KB941422
MOSS 2007 or WSS 3.0 SP1 KB936984/KB936988
MOSS 2007 or WSS 3.0 Security Bulletin MS07-059 KB942017
MOSS 2007 or WSS 3.0 August 24, 2007 hotfix package KB941422 (updated)
MOSS 2007 or WSS 3.0 RTM [Released To Manufacturing] N/A
MOSS 2007 or WSS 3.0 Beta 2 TR N/A
MOSS 2007 or WSS 3.0 Beta 2 N/A