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,