another excel utility is called KUtools I use the heck out of it I can add the tick marck in front of any cell even whole columns it has a lot things excel does not.
Same as your case, I have been doing alot of shorcuts with excel expor=>import with versions 6.2 and 7, all was fine starting with updating to resource loading and relationships. Now, this feature simply does not work on 16.2 although I consider myself very familiar with excel import in earlier versions of P6.
I noticed that the exported excel file is in Version 2010 instead of 2003 with P6 V7. I thought that Oracle wanted to keep pace with Ms Office but instead, they messed it up, giving us a very hard time. Taking weeks to do what took an hour before.
I hope someone with better IT background will take us through this issue.
Same as your case, I have been doing alot of shorcuts with excel expor=>import with versions 6.2 and 7, all was fine starting with updating to resource loading and relationships. Now, this feature simply does not work on 16.2 although I consider myself very familiar with excel import in earlier versions of P6.
I noticed that the exported excel file is in Version 2010 instead of 2003 with P6 V7. I thought that Oracle wanted to keep pace with Ms Office but instead, they messed it up, giving us a very hard time. Taking weeks to do what took an hour before.
I hope someone with better IT background will take us through this issue.
lets say your dates are in column L to add the apostrophe just insert another column let's call that K and put the apostrophe in column K and copy it to the bottom. Now in column M use this excel function =K&L. Now copy column M and go to column L and select paste special and select value. Now delete columns K and M and import the excel file.
Member for
16 years 3 monthsyou need the latest patch
you need the latest patch
Member for
21 years 8 monthsConsider using ASAP Utilities
Consider using ASAP Utilities Free.
http://www.asap-utilities.com/
Member for
8 yearsHi All, Please help me with
Hi All,
Please help me with the same problem..
I can't import my updated activities from excel to primavera 16.2 ..
Please provide with simple steps to overcome it..
Thanks and best regards
Member for
16 years 3 monthsanother excel utility is
another excel utility is called KUtools I use the heck out of it I can add the tick marck in front of any cell even whole columns it has a lot things excel does not.
https://www.extendoffice.com/order/kutools-for-excel.html
Member for
11 years 4 monthsTHIS IS VERSION 16.2
THIS IS VERSION 16.2 PROBLEM!
Same as your case, I have been doing alot of shorcuts with excel expor=>import with versions 6.2 and 7, all was fine starting with updating to resource loading and relationships. Now, this feature simply does not work on 16.2 although I consider myself very familiar with excel import in earlier versions of P6.
I noticed that the exported excel file is in Version 2010 instead of 2003 with P6 V7. I thought that Oracle wanted to keep pace with Ms Office but instead, they messed it up, giving us a very hard time. Taking weeks to do what took an hour before.
I hope someone with better IT background will take us through this issue.
Member for
11 years 4 monthsTHIS IS VERSION 16.2
THIS IS VERSION 16.2 PROBLEM!
Same as your case, I have been doing alot of shorcuts with excel expor=>import with versions 6.2 and 7, all was fine starting with updating to resource loading and relationships. Now, this feature simply does not work on 16.2 although I consider myself very familiar with excel import in earlier versions of P6.
I noticed that the exported excel file is in Version 2010 instead of 2003 with P6 V7. I thought that Oracle wanted to keep pace with Ms Office but instead, they messed it up, giving us a very hard time. Taking weeks to do what took an hour before.
I hope someone with better IT background will take us through this issue.
Member for
10 years 5 monthsIt didnt worked. I have been
It didnt worked. I have been using ASAP for a long time. While I was using p6 15.1 I had no problem to import
I couldnt anything from excel since we have installed P6 16.2.
Note that My exported excel spreedsheet's cells doesnt include Apostrophe in front.
Member for
16 years 3 monthslets say your dates are in
lets say your dates are in column L to add the apostrophe just insert another column let's call that K and put the apostrophe in column K and copy it to the bottom. Now in column M use this excel function =K&L. Now copy column M and go to column L and select paste special and select value. Now delete columns K and M and import the excel file.
I do this all of the time.
Member for
10 years 5 monthsIt didnt work Zoltan. To
Member for
16 years 3 monthsjust EXPORT a few activities
just EXPORT a few activities that have actual dates. Then use this as a template to import your actual dates. You must include the times also.