Excel Pivot auto update

I have excel pivot reports that I have created via the odc and would like them to auto update when I add data to my access database, I want them to update without having to open excel or right click refresh. Is this possible???

Thank you.