In order to get the functionality and graphing ability of Excel I placed an
unbound Excel Object on a form with the spreadsheet data source linked to
another Excel file external to the database.

My problem is when I open this form, I can't get the data in the graph to
update unless I double click and "activate" the object. Is there a way to
force the object to update automatically upon opening the form ?

Any help is greatly appreciated! Thanks, Adam