try using the open document event as a excel macro:
open excel > goto tools / macro / vb
editor > click on this workbook and on the top left combo click workbook and on the top right click open you should have this:
Private Sub Workbook_Open()
...where it says stop type in the code, i tested it and it hit stop right away when i opened it. All you have to do then is open the file from access, the code will trigger even if opened from access. Save the file as a template, just an idea.