16 Replies Latest reply on Jan 28, 2015 1:08 AM by Eugene Lee

    How to automatically update a embedded object (MS Excel) in a Processbook PDI file whenever the PDI file is opened?


      I have embedded a MS excel object into a PDI file.  The exel file contains a tabular "daily report."  The excel file automatically opens every morning at 6:15am (via Windows task scheduler) and runs a Auto_Open macro to refresh all of the PI Datalink functions.  Even though the excel file automatically updates the data, I still have to manually update the object within the Processbook PDI file by:  going to build mode;  clicking the object; right clicking the menu; and selecting "edit object."


      How do I get the ProcessBook PDI file to "automatically" update the embedded file?


      Thanks in advance,