AnsweredAssumed Answered

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

Question asked by bryancouch on Jan 14, 2015
Latest reply on Jan 28, 2015 by Eugene Lee

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,