How about using AF Table Link to read Excel contents instead of excel odbc?
I checked my machine and AF Table Link does not lock the Excel Sheet.
So you can use AF Link Table to get the Excel's data. Also you can edit the Excel contents by opening Excel.
Using "Table provided time series data" option, Table Lookup attribute can returns time series data.
Does it work for you?