Is there an exsisting Excel worksheet to input data into Proje...

B

Book

I have several individuals who are not familiar with Project. They are
familar with Excel. I would like to know if a template exsists that they can
input data into. I would then utilize this excel template to input data into
Project.


Thanks, "Book"
H. E. Booker, SMSgt, USAF
 
J

John

Book said:
I have several individuals who are not familiar with Project. They are
familar with Excel. I would like to know if a template exsists that they can
input data into. I would then utilize this excel template to input data into
Project.


Thanks, "Book"
H. E. Booker, SMSgt, USAF

SMSgt Booker,
I'm not aware of any templates but it shouldn't be too hard to put
something together that the guys could all use. The first thing you need
to do is define exactly what kind of data you want to export from Excel
to Project (i.e. task names, dates, durations, resources, etc.). Once
you have that definition then use the Project import mapping structure
to develop a worksheet "template".

John
Project MVP
 
R

Rod Gill

Hi,

For Project 2002 and 2003 there is an Excel Template:

Select File, Save As
Select file type Excel *.xls
In step 2 of the wizard select option Project Excel Template

Add your details to the relevant pages then open in Project:
File Open with file type Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top