98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Software
Software
Resolved · Low Priority · Version 2007
Robert has attended:
Project Intro Intermediate course
Software
What is the most affective way to get info from Excel to project
RE: Software
Hi Robert,
Thank you for your question.
There are a couple of ways. If the data in Excel is arranged in columns and includes data like task names and durations, you can copy and paste the data directly into your project file in the task sheet.
The second way is to use the File Open command and navigate and choose the excel file you want. You will then get the Import wizard and you will have to map the fieldnames in the spreadsheet with the relevant field names in Project.
I hope this answers your question.
Regards
Simon
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Avoid Accidental ConstraintsThe initial default table is the Entry table. Enter a task name and duration, but do not enter start or finish dates. Form the plan using links, predecessors. Typing dates introduces constraints. To remove these constraints, double click on a task, and on the Advanced page of Task Information set the constraint back to As Soon As Possible (all other options are there too.) |