I have an Excel Pivot table embedded in a OLE object


(as shown here: https://www.youtube.com/watch?v=-HNeqxnmrW0).
However it doesn,t update automatically (I have to open/edit the OLE object in excel, and update there).
Is it possible to run VBA code or other way to get the table updated every time I update the database? Thank you for your help