Claim Your Free! Membership

Error while importing form excel to p6, however the baseline is set and few performance % also updated

Dear All,
 
I am facing the following error,
 
Error while importing from excel to p6, however, the baseline is set and

New folder 1.zip


performance % also updated, attaching the compressed file contains excel and p6 files
 
Thanks in advance for your time and efforts
 
Regards
Bilal Ashraf on November 21 at 06:13 AM in Planning
2 Answer(s)
Best answer
Your Sheet is missing the Column heading in Cell A1 in worksheet TASKRSRC

Please type task_code in this cell and it should work.

See this photo: 
 
Hany Ismael on November 21 at 08:53 AM
This Solution Worked, At least importing completed but another issue came up after importing, activities were not under previous WBS, All activities separated out & WBS Separated !!
on November 21 at 10:36 AM
Export the same excel sheet again from P6 and include the WBS path so when you import it the activities will go to the correct WBS.
on November 21 at 10:53 AM
Can you delete the following columns and try to import again?
 

Hany Ismael on November 21 at 06:37 AM
It didn't work Sir
on November 21 at 07:08 AM
Your Sheet is missing the Column heading in Cell A1 in worksheet TASKRSRC

Please type task_code in this cell and it should work.

See this photo: https://engineerbook.net/uploads/photos/thumbnail/2018/11/21/9346/1500_529badee194a843f7311b9275c0986e2.png
on November 21 at 08:26 AM