STIWasabi
asked on
Pasting Excel Data into Microsoft Projet
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
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
ASKER
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
Please let me know, This is getting critical as I wasn't able to find a solution yet.
Thanks
MASTER.xlsx
MASTER.doc
apologies, I don't have access to that version of project during working hours, I will look at it later today
Reg
Reg
ASKER
Attached a 2000-2003 version, hoping it will react the same as my 2013 version.
MASTER-2003.doc
MASTER-2003.doc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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