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.

Get the fastest and the most accurate tool to update Primavera from Excel (It's free)

4 replies [Last post]
Fri, 2019-12-20 23:41
Mohammed Ali
User offline. Last seen 1 year 45 weeks ago. Offline
Joined: 16 Mar 2018
Posts: 72
Groups: None

Today you can get the XLS Magic Tool (It's free)

The fastest and the most accurate tool to update Primavera 

The features and capabilities:

  • Format the project file to suit update requirements.
  • Provide the project file with all the data required for the update process.
  • Transfer all project file data according to Primavera settings.
  • Detecting any errors in the project file that may prevent it from re-exporting to Primavera.
  • Specify the added data and the modified data during the update process.
  • Confirm that all updates data have imported into Primavera as required.
  • Comparing any two Primavera projects through Excel.

This video illustrates how to use the XLS Magic Tool and all of its features 

https://youtu.be/6fx25pT-Hao

The XLS Magic Tool download link is

http://www.mediafire.com/file/7ill1qgdz9lwntx/XLS_Magic_Tool.xlsm/file

It can be used with Excel 2007 or 2010 on and with all of the Primavera versions.

Top

Replies

Tue, 2020-01-14 22:02
#1
Mohammed Ali
User offline. Last seen 1 year 45 weeks ago. Offline
Joined: 16 Mar 2018
Posts: 72
Groups: None
It was planned to do that, but I don't know if this will be enough time to do that or not.In general, most of engineers who would like to use the Magic Tools, have installed Excel 2007 or 2010 in addition to their original versions.
Top
Tue, 2019-12-31 13:15
#2
Zoltan Palffy
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

do you plan on testing it on the latest version of excel ?

Top
Mon, 2019-12-30 14:51
#3
Mohammed Ali
User offline. Last seen 1 year 45 weeks ago. Offline
Joined: 16 Mar 2018
Posts: 72
Groups: None

Hi Zoltan

Thank you for your note.

As I have explained in this video

https://youtu.be/6fx25pT-Hao

in its minute 18:35 the XLS magic tool is working very well on Excel 2007 and 2010.

I didn't test any other versions.

All of the Magic Tools family:

1- The SDK Magic Tool.

2- The XER Magic Tool.

3- The XLS Magic Tool. 

are working very well on Excel 2007 and 2010.

Top
Mon, 2019-12-30 13:55
#4
Zoltan Palffy
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

when I open it I get this error i am using office 365 version 1911 Build 1228.20364

 

7191
errorcapture.jpg

Top