Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
SharePoint GroupsView
Sharepoint Portalserver
Sharepoint Portalserver Development
Sharepoint Windowsservices
Sharepoint Windowsservices Development
Sharepoint Design_And_Customization
Sharepoint Development_And_Programming
Sharepoint General
Sharepoint Setup_And_Administration

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Apps
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft Sharepoint General Posts  Ask A New Question 

Tracking Project Status

H posted on Monday, January 29, 2007 8:20 AM

Hello,

I have an excel spreadsheet which has serveral columns. The columns include
the following (project name, % complete, estimated hours,  hours used to
date, date started, status details, etc.).  With this spreadsheet, I am using
over 20 columns to keep track of the data.

I need to use SharePoint to keep track of the status of several projects.
Could you tell me the best way to use SharePoint to do this? I heard that you
could create a list to do this however i have several columns that are needed
so i'm looking for an efficient solution to my problem.

Thanks.
reply

 

the answer will depend on which version of WSS you are using.

Dean posted on Monday, January 29, 2007 11:22 AM

the answer will depend on which version of WSS you are using. There is
built-in Task list that is intended to do exactly what you want, some of the
limitations in WSS 2 have been removed in WSS 3. You could add additional
columns to the Task list and then copy/paste your data from Excel, (the
columns will need to be arranged in the correct sequence and the data types
in your SharePoint list must be the same as the columns in Excel)

You can also use the Publish List feature in Excel to create a new custom
list in a WSS site that contains the exact same columns as your excel
worksheet. To do this, select your range, convert to List, publish list to
an existing WSS site-details in the Excel Help.
reply


Previous Microsoft Sharepoint General conversation.