Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Exporting & importing to EXCEL

1 reply [Last post]
Thu, 2012-04-12 12:14
Jaime Sax Maliwat
User offline. Last seen 3 years 34 weeks ago. Offline
Joined: 23 Sep 2010
Posts: 7
Groups: Building Information Modelling, Civil Engineering, GPC Qatar, MS Project for Planners, Pinoy Planning Planet Community, Planning, Claims & Contracting, PMO Best Practices, Re baseline

I successfully export P6 files to excel,but when I importing back excel to p6 after I load resources,BOQ,cost either the program said out of memory or not responding.I have 25,000 activities in the Project. Your help will be highly appreciated.

Top

Replies

Mon, 2012-04-16 08:47
#1
Daniel Limson
User offline. Last seen 5 years 4 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None

Hi Jaime,

Try doing it in batches, the file must be too big. Note that when importing back to P6, you need the same file or source, when you export to P6, there are actually 2 worksheets created.

Best regards,

Daniel

Top