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:

itpwscom.gif  

itpwsris.gif 

Site Feature Icon:

PwsCollab.gif    

Resolution

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

Distorted Toolbar or No Toolbar in Document Library

Issue:

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.

Resolution:

• 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.

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

Error:

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 - http://xyz.abc.com/personal/user |
  Web Site URL - http://xyz.abc.com/personal/user |
  HttpRequest URL - http://xyz.abc.com/personal/user/Personal 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 –

http://xyz.abc.com/personal/user/Personal Documents/Forms/AllItems.aspx  

Resolution:

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.

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

Resolution:

Finally I have got below articles to get rid of this issue.

http://support.microsoft.com/kb/932118

http://support.microsoft.com/kb/2019105

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.

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

Environment

SPS 2003

Office 2003

Issue

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.

Resolution

Repaired Office 2003 from control panel and everything works fine

SharePoint 2010 Versions

SharePoint 2010 Version	Microsoft Support KB	Version Number
SharePoint 2010/Foundation December 2010 Cumulative Update	2459257, 2459125	14.0.0.5130
SharePoint 2010/Foundation October 2010 Cumulative Update	2394320, 2394323	14.0.0.5128
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	14.0.0.5114
SharePoint 2010 RTM	N/A	14.0.0.4762
SharePoint Server 2010 Release Candidate	N/A	14.0.0.4730
SharePoint Server 2010 Public Beta	N/A	14.0.0.4536
SharePoint Server 2010 SPC2009 Demos	N/A	14.0.0.4524
SharePoint Server 2010 Technical Preview “2” [another SPC2009 demo build]	N/A	14.0.0.4514
SharePoint Server 2010 Technical Preview	N/A	14.0.0.4006

SharePoint 2007 Versions

SharePoint 2007 Version	Microsoft Support KB	Version Number
MOSS 2007 or WSS 3.0 Cumulative Update February 2011	KB2475885/ KB2475886	12.0.0.6554
MOSS 2007 or WSS 3.0 Cumulative Update December 2010	KB2458605/ KB2458606	12.0.0.6550
MOSS 2007 or WSS 3.0 Cumulative Update October 2010	KB2412267/ KB2412268	12.0.0.6548
MOSS 2007 or WSS 3.0 Cumulative Update August 2010	KB2276472/ KB2276474	12.0.0.6545
MOSS 2007 or WSS 3.0 Cumulative Update June 2010	KB983310/ KB983311	12.0.0.6539
MOSS 2007 or WSS 3.0 Cumulative Update April 2010	KB981042/KB981043	12.0.0.6535
MOSS 2007 or WSS 3.0 Cumulative Update February 2010	KB978395/KB978396	12.0.0.6529
MOSS 2007 or WSS 3.0 Cumulative Update December 2009	KB977026/KB977027	12.0.0.6524
MOSS 2007 or WSS 3.0 Cumulative Update October 2009	KB973409/KB973410	12.0.0.6520
MOSS 2007 or WSS 3.0 August 2009 Cumulative Update	KB973409/KB973410	12.0.0.6514
MOSS 2007 or WSS 3.0 June 2009 Cumulative Update	KB971537/KB971538	12.0.0.6510
MOSS 2007 or WSS 3.0 April 2009 Cumulative Update	KB968851/KB968850	12.0.0.6504
MOSS 2007 or WSS 3.0 SP2	KB953334/KB953338	12.0.0.6421
MOSS 2007 or WSS 3.0 Cumulative update	KB956056/KB956057	12.0.0.6327
MOSS 2007 or WSS 3.0 Infrastructure Update	KB951695/KB951297	12.0.0.6318
MOSS 2007 or WSS 3.0 post-SP1 hotfix	KB948945	12.0.0.6303
MOSS 2007 or WSS 3.0 post-SP1 hotfix	KB941274	12.0.0.6301
MOSS 2007 or WSS 3.0 post-SP1 hotfix	KB941422	12.0.0.6300
MOSS 2007 or WSS 3.0 SP1	KB936984/KB936988	12.0.0.6219
MOSS 2007 or WSS 3.0 Security Bulletin MS07-059	KB942017	12.0.0.6039
MOSS 2007 or WSS 3.0 August 24, 2007 hotfix package	KB941422 (updated)	12.0.0.6036
MOSS 2007 or WSS 3.0 RTM [Released To Manufacturing]	N/A	12.0.0.4518
MOSS 2007 or WSS 3.0 Beta 2 TR	N/A	12.0.0.4407
MOSS 2007 or WSS 3.0 Beta 2	N/A	12.0.0.4017