Hi,
Whenever I export data from P6 in Excel format the data comes out in a strange format where everything has a "`" in front. For example, 1303FR001 comes out like `1303FR001. And I can't perform a Vlookup or other action as Excel doesn't seem to recognise the data.
Is there a way to export from P6 into Excel and get a "normal", usable output?
Thanks very much
Dave
There is very easy method over here
Fastest method to export data from primavera p6 to excel
Hi
A nice plugin for excel is called ASAP Utilities which has a nice feature to remove those apostrophes in excel. There's a tutorial on updating activities through excel (with ASAP utils) over at https://www.planacademy.com/excellerate-your-updates-how-to-import-your-subcontractors-primavera-updates-from-excel/
Michael
Thanks very much guys.
Dave
David,
Use the export through SDK....