Hi, Peter Thanks for reply. I do understand that one can sort the field, but that is only when one view it in Data Manger. No matter how I sort it when I view the data in Data Manger. The exported the excel is always sorted based on PnPID. I didn't find any setting that can help with this in Plant 3D so far. (Plant 3D 2012 is what I used.) I also checked about the Report Creator before, But I understand the Report Creator only allow you to create the report, not export to excel and read back? Moreover, I believe that Report Creator doesn't allow you to union the class like Access. With the report that we are creating, we need to union some of the class. With the amount of information we deal with, we need to be able to export to excel, put in the informations and import back to Plant 3D. Let me explain why I have to do these. 1. P&IDs are always changed during the design process. There are new valves, instruments added. Some valves, instruments are deleted. This is happened like every week. In order to make sure the information is not missed or wrong, we are export the schedule, edit it and put back to plant 3D database (This is the process filling the data for schedules). 2. in every submission of schedules to the client, the number of items in Data Manager is always different. It is needed to identify the new one, deleted one, etc. With the PnPID number order output, it just very hard to find the information, understand the data. That's why we think about sorting the excel output of the Data Manager. 3. during the life the design, there might be different engineers who process the schedules. 4. excel file outputted from Data Manger is not allowed to sort and some of the other basic excel function. In order to sort the data, we had to copy the whole sheet out and copy to a new sheet, edit it and copy it back, time consuming and dangerous. So, we are thinking, it is easier to have the excel output ordered as we needed to speed up the process. Cheers, Peggy -- Best Regards, Peggy Lin
