[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Pasting Excel Data into Microsoft Projet

Posted on 2013-11-14
Medium Priority
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 1500 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

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.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

656 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