you can define libname with excel engine to point it to the excel file as below. SAS will treat the file as a data set.

libname S EXCEL 'c:\temp\book1.xlsx';

****your SAS programs***;

libname S clear;

这样可以实现自动更新？