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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
free project software 4 489
MS Project 2013 reports 1 114
Centralised Project Managment Software 3 93
Do standard MS Project mpp files have databases that can be queried? 2 98
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

730 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