Linking to access
 

When linking an excel spreadsheet to and Access database, is there anyway to
have the formulas that are set up to calculate in Excel transfer to Access.
The only way I can get them to update in Access is closing the Access
database and opening the Excel file. Is there an easier way?