Solved

Pasting Excel Data into Microsoft Projet

Posted on 2013-11-14
5
202 Views
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.

Thanks
0
Comment
Question by:STIWasabi
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:regmigrant
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

Reg
0
 

Author Comment

by:STIWasabi
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.

Thanks
MASTER.xlsx
MASTER.doc
0
 
LVL 19

Expert Comment

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

Reg
0
 

Author Comment

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

Accepted Solution

by:
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

Reg
MASTER1.xlsx
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
A simple overview of the possibilities of using technology for project management.
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

792 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