Pasting Excel Data into Microsoft Projet

Posted on 2013-11-14
Last Modified: 2014-03-06
I'm desperately trying to paste data from an excel file into a Microsoft Project plan. Microsoft Project always seems to do some sort of calculations which is overriding the real data. For example :

Excel Source Data :
    Start     |Actual Work|Remaining Work|Actual Duration|Remaining Dur|  Finish |
11/26/13  |           5           |           20               |           2                |              1            |11/28/13 |

Once inserted into Microsoft Projet Data
    Start     |Actual Work|Remaining Work|Actual Duration|Remaining Dur|  Finish |
11/26/13  |      18.33         |         6.67              |           2                |              1            |11/28/13|

Task type is currently set to Fixed Work but I tried all sorts of trickery (all task types / manual vs auto shceduling) and it always does the same thing.

How to make this work? I realize the 20h in a single day, this is just an example. Bottom line is I want Project to trust the data and not override anything.

Question by:STIWasabi
  • 3
  • 2
LVL 19

Expert Comment

ID: 39677509
the changed information is because (probably) you are mixing the various tables project maintains when pasting the data. The Gantt chart view shows a mix of data from Task, Assignment, Resource, Calendar and when you past the mix project is trying to balance all the various elements.

It looks like you are trying to bring Actuals information into the sheet so you should setup all the tasks then swtich to view, table:tracking  and do the paste there.

However this can still be modified if your calendar and resources enforce any changes so turn off auto calculation and auto levelling until the paste is complete

If this doesn't work then a copy of the file(s) would help


Author Comment

ID: 39681744
Attached a sample excel projet and the related project file (rename extension to mpp) into which I'd like to paste my excel projet data.

Please let me know, This is getting critical as I wasn't able to find a solution yet.

LVL 19

Expert Comment

ID: 39685137
apologies, I don't have access to that version of project during working hours, I will look at it later today


Author Comment

ID: 39685404
Attached a 2000-2003 version, hoping it will react the same as my 2013 version.
LVL 19

Accepted Solution

regmigrant earned 500 total points
ID: 39685501
I think the problem is that your spread sheet has actual values summed on all outline levels - the summary figures have to be calculated by adding the lower levels together and rolling up.

Try with the attached where I  have cleared down the actuals from the summary tasks


Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MSProject EditCopyPicture question 1 283
MS Project 2013 Milestone report 4 1,134
ms project 3 338
Scrum, Product owner, Scrum Master, and Burn-Down chart 4 143
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now